WCOM1350 database design and management assignment answers
INTRODUCTION TO DATABASE DESIGN AND MANAGEMENT (WCOM1350) – Assignment-1
Assignment Task 1: ERD
Copy-paste your diagram here, you may change page layout to be landscape if the diagram is wider.
You need to list and briefly describe the extra entities you added
EXTRA ENTITY IS MANAGER WHO MANAGE THE MEMBER AND TRAINER
![WCOM1350 database design and management assignment answers Image 1](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-1.jpg)
Assignment Task 2: EERD
Copy-paste your diagram here, you may change page layout to be landscape if the diagram is wider
![WCOM1350 database design and management assignment answers Image 2](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-2.jpg)
Assignment Task 3: LDM
Copy-paste your 3 separate diagrams here
![WCOM1350 database design and management assignment answers Image 3](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-3.jpg)
Assignment Task 4: Normalization
Copy-paste the First Formal Form Table, the PK is …………………
![WCOM1350 database design and management assignment answers Image 4](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-4.jpg)
Copy-paste the Second Formal Form Tables with PKs and FKs
![WCOM1350 database design and management assignment answers Image 5](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-5.jpg)
Copy-paste the Third Formal Form Tables with PKs and FKs
![WCOM1350 database design and management assignment answers Image 6](https://www.assignmenthelp.net/webimg/yah/images/wcom1350-database-design-and-management-assignment-answers-image-6.jpg)