Posted: September 28th, 2023

What errors prevent the table displayed above from

Order IDOrder DateCustomer IDCustomer NameProduct IDProduct Desc.Product PriceQuantity Ordered100610/24/102Value Furniture754Dining Table
Writers Desk
Entertain Center800.00325.00650.00221100710/25/106Furniture Gallery1144 Drawer Dresser
Entertain Center500.00650.0043What errors
prevent the table displayed above from being first normal form compliant?
List all the
functional dependencies present in the table.
List all the
candidate keys.
Describe the
steps you would take to bring the table into first normal form compliance.
Display the resulting first normal form compliant table or tables,
identifying primary and foreign keys.
What error(s),
if any, prevent the now first normal form compliant table or tables from
being second normal form compliant?
List all the
functional dependencies present in the first normal form compliant
table(s).
List all the
candidate keys.
Describe the
steps you would take to bring the table(s) into second normal form
compliance. Display the resulting second normal form compliant table or
tables, identifying primary and foreign keys.
What error(s),
if any, prevent the now second normal form compliant table or tables from
being third normal form compliant?
List all the
functional dependencies present in the second normal form compliant
table(s).
List all the
candidate keys.
Describe the
steps you would take to bring the table(s) into third normal form
compliance. Display the resulting third normal form compliant table or
tables, identifying primary and foreign keys.Whatsamatter U also has a number
of students, of course. The table on the following page lists the information
gathered for each student, plus 5 sample records. Some business rules that
Whatsamatter U follows includes:
·
Each student has a unique ID number
·
A student has only a single advisor, but an
advisor can have either zero or many students.
·
Advisors are always faculty members (professors)
·
A student can have only a single major but, of
course, many students can have the same major
·
A student can take a course more than onceUsing the above business rules and the data in Table 1 on
the following page, do the following:What errors
prevent the table displayed above from being first normal form compliant?
List all the
functional dependencies present in the table.
List all the
candidate keys.
Describe the
steps you would take to bring the table into first normal form compliance.
Display the resulting first normal form compliant table or tables,
identifying primary and foreign keys.
What error(s),
if any, prevent the now first normal form compliant table or tables from
being second normal form compliant?
List all the
functional dependencies present in the first normal form compliant
table(s).
List all the
candidate keys.
Describe the steps
you would take to bring the table(s) into second normal form compliance.
Display the resulting second normal form compliant table or tables,
identifying primary and foreign keys.
What error(s),
if any, prevent the now second normal form compliant table or tables from
being third normal form compliant?
List all the
functional dependencies present in the second normal form compliant
table(s).
List all the
candidate keys.
Describe the
steps you would take to bring the table(s) into third normal form compliance.
Display the resulting third normal form compliant table or tables,
identifying primary and foreign keys.Table 1StudentsStudentIDNameeMailDepartmentMajorAdvisorIDAdvisorCoursesTakenN112233Rocky Squirrel.edu">squirrel@wmu.eduGSCISInformation SystemsP123John DataMMIS630
MMIS620N121212Bullwinkle Moose.edu">moose@wmu.eduBusinessAccountingP456Carl NumbersACCT810
MMIS630N212121Natasha BadenofNat@Bad.netGSCISInformation SystemsP123John DataMMIS630 MCIS610N234432Boris BadenofBoris@Bad.netGSICSComputer ScienceP789Rich GeekMCIS610

Tags: Best Online Essay Writers - Thesis and Dissertation Help, Custom Dissertation Writing Services for PhD Students, Essay USA, UK - Cheap Essay Writing Service