Question: how would i write out the first normal form in relational schema form? a) The table below gives a small subset of transactions performed on
a) The table below gives a small subset of transactions performed on bank accounts. It indicates that customers can have more than one account. Also note, both the Sort Code and the Account Number are needed to uniquely define each account. Given the above form, the Un-normalised form (UNF) has been extracted as follows: (Client Number, Client Name, Date of Birth, Client Address, Telephone Number, ( Account Number, Sort Code, (Transaction Date and Time, Amount ))) Identify and write out the First Normal Form (1NF) in relational schema form
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
