ICT320 Database Programming

For Part A you are to include an analysis of the current database design in a word document or PDF. You should include:
• Identification of major implementation flaws in the existing system, and/or areas for improvement, including (but not limited to)
o Removing repeated data,
o De-normalization for optimization
o changing some areas to NoSQL (if so, include what type of NoSQL database).
o Rational for the creation of each specific constraint (Foreign Key and Unique) and/or index.
• Identification of the current Normal Form of the system.
• An ER Diagram for the current design of the system, and an ER Diagram for the re-designed system.
• Your assumptions and any supplementary design requirements regarding the system.
For Part B you are to submit
• A single plain text file, named <student_Number>_<student_first_name>_<student_last_name>_ICT320_PartB.sql. In this file you are to include all the SQL for your
database modification. This includes:
o ALTER/CREATE TABLE statements for: ? Changes proposed in your redesign from Part A
? Commands for the missing FOREIGN KEYs, INDEXes and UNIQUEness constraints.