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

Assignment Task 2: EERD

Copy-paste your diagram here, you may change page layout to be landscape if the diagram is wider

Assignment Task 3: LDM

Copy-paste your 3 separate diagrams here

Assignment Task 4: Normalization

Copy-paste the First Formal Form Table, the PK is …………………

Copy-paste the Second Formal Form Tables with PKs and FKs

Copy-paste the Third Formal Form Tables with PKs and FKs