Question: Based on this data dictionary implement normalisation of all tables to 3rd Normal Forms. Branch P/F Field Name Data Type Size Notes P Branch ID

Based on this data dictionary implement normalisation of all tables to 3rd Normal Forms.

Based on this data dictionary implement normalisation of all tables to 3rd

Normal Forms. Branch P/F Field Name Data Type Size Notes P Branch

ID Number/int 10 Unique ID 250 Street Text City Text 20 Tele

Branch P/F Field Name Data Type Size Notes P Branch ID Number/int 10 Unique ID 250 Street Text City Text 20 Tele No Text 15 Staff P/F Field Name Data Type Size Notes P Staff ID Number/int 10 unique ID Staff Name 20 Text Text 20 Designation Number/int F Branch ID 10 Salary 10 int Branch P/F Field Name Data Type Size Notes P Branch ID Number/int 10 Unique ID 250 Street Text City Text 20 Tele No Text 15 Staff P/F Field Name Data Type Size Notes P Staff ID Number/int 10 unique ID Staff Name 20 Text Text 20 Designation Number/int F Branch ID 10 Salary 10 int

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!