Design and implement a relational database system for KAP Speciality Chocolates Ltd based on the given case study. The assignment requires creating an Extended ER Diagram, developing SQL database structures with appropriate constraints, writing SQL queries for business requirements, populating the database with sample data, and demonstrating normalisation from Unnormalised Form (UNF) to Third Normal Form (3NF). Expected Deliverables: One PDF report containing: Extended ER Diagram with entities, attributes, relationships, keys and constraints SQL DDL statements for database implementation SQL DML queries with testing evidence/screenshots Normalisation process from UNF to 3NF
Megaminds has supported academic requirements in this discipline and related disciplines.