High Life Computing (HLC) is an online store selling computing products and acce

Question

High Life Computing (HLC) is an online store selling computing products and accessories. Please review the table below, which contains sample data about orders placed by customers of HLC. Normalize this table into a set of tables such that all tables are in third normal form (3NF). Be sure that all normalized tables have primary key columns underlined (if a table’s PK is not listed in the given table below, add a PK column/s, as necessary).

Display your answer in the shorthand table notation – i.e. list of tables without the data. The student table below is an example of a table in shorthand notation:
      STUDENT (Student-ID, First-Name, Last-Name)

Customer Customer Price- Customer Customer Order- Product- Product- Product Manufacturer Manufacturer First Customer# Last Quantity Na Per- Phone# order# Date Co Name 111-1804 13634 s 1,400 APP 10/17/16 A22 Mike Apple Computer 111-7804 13634 Mike 10/17/16 A29 Apple Computer APP Samsung S850 SAM 1689 14987 10/05/16 B31 Johnson Jennifer Samsung MacBook $1,550 APP Johnson Jennifer 391-1689 14987 10/05/16 A22 Apple Computer Notebook S975 SAM Jennifer 391-1689 17892 1/13/17 B31 Johnson Samsung

Explanation / Answer

Shorthand Notations for Tables in 3NF form

1.) CUSTOMER(CUSTOMER-ID, FIRST-NAME, LAST-NAME, CONTACT-PHONE)

2.) PRODUCT(PRODUCT-CODE, PRODUCT-NAME, PRODUCT-QUANTITY, PRICE-PER-UNIT)

3.) ORDER(ORDER-ID, ORDER-DATE)

4.) MANUFACTURER(MANUFACTURER_ID, MANUFACTURER-NAME)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.