This assessment is an individual Project. The actual scenario for carrying out the following tasks will be available on Moodle (in assessment section) by week 8.

Tasks to be completed:

1. Create a complete ERD with entities and relationships using given scenario.
2. Convert the ERD to a set of relational tables in at least 3NF and draw a dependency diagram.
3. Create a database using MySQL- with primary keys, foreign keys, and other attributes mentioned for each entity using proper constraints.
4. Input some significant data in each table showing your understanding of the scenario. e) Create FOUR queries.

ASSESSMENT SUBMISSION:

The assignment must be submitted online in Moodle. The ERD and dependency diagram must be in MS WORD and assignment submission should contain both MS WORD file and the actual database contained in one folder.

MARKING GUIDE (RUBRIC):

Marking Criteria	Lecturer Expectation	Marks	Comments
ERD	Right diagrammatic representation of entities, attributes, identifiers, and relationships	10
Normalisation	Reflect understanding of dependencies and normalization.	4
Database, tables, keys, fields, and data	Shows understanding of MySQL as a relational DBMS and how it supports database design and implementation for relational databases.	8
Queries	Reflect understanding SQL using MYSQL.	8
Total		30

please i need full marks