Question: Make sure that you include table names ( you make those names ) in all of your diagrams. Primary keys underlined and foreign keys should

Make sure that you include table names (you make those names) in all of your diagrams. Primary keys underlined and foreign keys should have dashed underlines.
\table[[SemestCode,TicketNum,CourseNum,SemstDesc,ProfCode,CourseTitle,],[2137,10010,ACCT220,Fall2021,rs,Intro to Financial Acct,],[2137,10020,ACCT230,Fall2021,dp,Intro to Managerial Acct,],[2137,10030,ACCT350,Fall2021,ew,Intermediate Acct I,],[2137,10040,ACCT351,Fall2021,rk,Intermediate Acct II,],[2243,10010,ACCT220,Spring2022,rs,Intro to Financial Acct,],[2243,10020,ACCT220,Spring2022,rs,Intro to Financial Acct,Sto],[2243,10030,ACCT230,Spring2022,dp,Intro to Managerial Acct,Pin],[2243,10040,ACCT230,Spring2022,dp,Intro to Managerial Acct,Pin]]
Complete Functional Dependency Diagram (FDD)- remember to label types of dependencies - FD, PD, TD
\table[[SCode,TkNum,CrsNum,SDesc,PrfCode,CrsTitle,PrfName]]
Based on the above diagram (1 NF ), make choices using circle (for right answer) or "x"(for wrong wswwer) at each of the following choices:
Example: The Sun rises from the West Theon goes around the Earth
[1 point each] SCode SDesc SCode PrfCode q,
[2 points each] SCode +TkmCrSmq, SCode TKNum q, Cis Num Prifose q,[1 point] SCode SDesc is a TD q,2NF (after resolving partial dependency): Draw the diagram for 2 NF
Make sure that you include table names ( you make

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!