Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Database Modeling With Neo4j

Authors: Ajit Singh

2nd Edition

B0BDWT2XLR, 979-8351798783

More Books

Students also viewed these Databases questions