Question: HI! I need help checking that all tables have the appropriate constraints and relationships. Then create an ERD showing all tables and their relationships. (Microsoft

HI! I need help checking that all tables have the appropriate constraints and relationships. Then create an ERD showing all tables and their relationships. (Microsoft SQL Server) Any help is appreciated and the more detail the better :) Thank you!!!!!

HI! I need help checking that all tables have the appropriate constraints

NF3 Employee_Project Project Employee Department Employee Employee No. No. Name Employee No. Hourly Rate Code PC010 S10001 22 S10001 L004 A Smith L Jones PC010 S10030 18.5 S10030 L023 PC010 S21010 21 S21010 P Lewis L004 PC045 S10010 21.75 S10010 B Jones L004 PC045 S10001 18 S31002 T Gilbert L023 PC045 S31002 25.5 S13210 L008 W Richards B James PC045 S13210 17 S10034 L0009 64 S31002 23.25 PC064 S21010 17.5 Department PC064 S10034 16.5 Department Department Name No. L004 IT Project_Code L023 Pensions Project L028 Database Project Title Project Manager Project Budget Code L008 Salary PC010 24500 L009 HR Pensions System M Phillips Salaries System H Martin PC045 17400 PC064 HR System K Lewis 12250

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 Databases Questions!