Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Consider the following un-normalized table which contains the following attributes: Staff Account Table AccountNo C007 Balance AccountType BranchID 1000 Current B12 Staff-ID 28 31
1. Consider the following un-normalized table which contains the following attributes: Staff Account Table AccountNo C007 Balance AccountType BranchID 1000 Current B12 Staff-ID 28 31 36 Staff Name Ahmed Mohammed Saeed Age 25 57 33 Address Rifaa S493 C200 C510 S289 2000 3000 1500 700 Saving Current Current Saving B13 B12 B15 B13 Manama Rifaa Zallag Manama 29 41 42 John Fatima 40 Note that One employee may have more than one account (like Saeed) and one account can be a joint account owned by two persons (like account No. 007). b) Produce the 2NF tables c) Produce the 3NF tables
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