We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.
No Plagiarism Guarantee - 100% Custom Written
COMPUTER SCIENCE AND TECHNOLOGY
Unit Name :
Systems Development and Modern Database Practices
Student’s Full names:
Unit Co-ordinator’s Name:
Assignment Leader Name:
Resit Assignment 2 all parts - Written report: Scenario-based Database System including SQL implementation
CIS020-2: Individual Referral Assignment – 2 Brief
Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure.
The following steps should be carried out and presented clearly in your report:
1) You should normalise the above table, stepping through 1st normal form, 2nd normal form and 3rd normal form, explaining in detail each respective normalisation phase and justify why you have taken the steps you have.
2) Once you have normalised the tables, draw a full Entity Relationship (ER) diagram of the final normalised tables, using the notation specified during lectures.
3) Write the Oracle SQL Code to create the tables and relationships identified in your normalisation (Note: There is no need to write the commands to insert the data)
- Written report submission (100%)