Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me with how this 3NF diagram would look like in SQL? I need to verify that all of the tables were created
Can someone help me with how this 3NF diagram would look like in SQL? I need to verify that all of the tables were created correctly with the appropriate constraints and relationships and Create an ERD showing all tables and their relationships. Thank you!
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started