1. Convert this single table below to an equivalent collection of four tables th

Question

1. Convert this single table below to an equivalent collection of four tables that are in third normal form (3NF). INVOICE (INVOICE_NUMBER CUSTOMER_NUMBER, LAST, FIRST, STREET, CITY, STATE, ZIP_CODE, INVOICE_DATE, (INVOICE_PART_NUMBER, PART_DESCRIPTION, UNIT_PRICE, NUMBER_SHIPPED)) This table concerns invoice information. For a given invoice (identified by the invoice number) there will be a single customer. The customer's number, name, and address appear on the invoice as well as the invoice date. Also, there may be several different Invoice parts appearing on the invoice. For each part that appears, the Invoice Part Number, Part Description, Unit Price, and Number Shipped will be displayed. The price and part description are from the current master price list table. 2. Using your knowledge of an undergraduate college environment, convert this single table to four tables that are in 3NF. STUDENT (STUDENT_NUMBER, STUDENT_NAME, TOTAL_EARNED_CREDITS, ADVISOR_NUMBER, ADVISOR_NAME, DEPT_NUMBER, DEPT_NAME, (COURSE_NUMBER, COURSE_DESCRIPTION, COURSE_TERM, CREDIT_HOURS, GRADE)) Each student has many courses that appear in a transcript table. A course cannot be taken more than one time. Each course belongs to a single department. An advisor works in an enrollment center, not a particular department. Each advisor is assigned multiple students. A student has a single advisor. A student is not assigned to a particular department.

Explanation / Answer

Part 1

Table CUSTOMER(CUSTOMER_NUMBER, LAST, FIRST, STREET, CITY, STATE, ZIP_CODE)

Table INVOICE((INVOICE_NUMBER, CUSTOMER_NUMBER, INVOICE_DATE,INVOICE_PART_NUMBER)

Table INVOICE_PART ( INVOICE_NUMBER, iNVOICE_PART_NUMBER,PART_DESCRIPTION, UNIT_PRICE,NUMBER_SHIPPED)

Part 2

TableSTUDENT (STUDENT_NUMBER, STUDENT_NAME, TOTAL_EARNED_CREDITS, ADVISOR_NUMBER, GRADES)

Table ENROLLMENT(STUDENT_NUMBER,COURSE_NUMBER)

Table ADVISOR(ADVISOR_NUMBER,ADVISOR_NAME)

Table DEPARTMENT(DEPT_NUMBER, DEPT_NAME)

Table COURSE (COURSE_NUMBER, COURSE_DESCRIPTION,DEPT_NUMBER)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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