Requirements: Analyse a domain area of your choice. For this domain you are required to Analyse, Design and Implement a database in an RDBMS. Deliverables – part 1 This project counts for 50% of the...

Requirements:
Analyse a domain area of your choice. For this domain you are required to Analyse, Design and Implement a database in an RDBMS.
Deliverables – part 1
This project counts for 50% of the overall marks for the module.
Project deliverables should be completed in groups of two (2) people. Please agree the groups within a week.
The project work should be carried out as homework. You may also use any spare time you have in independent learning to work on this project.
 You may use any diagramming tool (Visio, Gliffy, Creately, Visio etc.) to carry out the diagramming but the final work must be presented on paper.
The construction portion of the project must be completed using MySQL.
 The Project needs to be completed and returned to Pádraig de Burca on paper and as a database by the above date. It should also be submitted on Moodle. One submission per team is enough.
1. Describe the application you are implementing in general terms. Include functional and non-functional requirements.
Draw up a Use Case model showing the system functions.
Give a detailed description of any one use case. The use case must contain an alternate flow.
These need to be detailed enough to drive your database and table development. 20%
2. Create a project plan for the development, implementation and testing of your system. 20%
The plan must include a minimum of 3 nesting levels and include all the major tasks and deliverables.
Describe how you monitor your project plan as you develop your project.
Use Microsoft Project to produce the Gantt chart and any diagramming tool of your choice to produce the Work Breakdown Structure (WBS).
3. List the main entities in your chosen system.
Create an Entity Relationship Diagram using the Barker notation (where possible) with all tables and attributes defined and optimized.
Include Optionality & Cardinality.
Include at least one operational master.
20%
4. Take at least two reports or forms relevant to your chosen system and normalise them to 3NF (third normal form). Show both the forms / reports and all steps in the normalisation process. Specify if and how the 3NF tables correspond with your ERD.
20%
5. Create the database tables on an RDBMS platform - MySQL - using SQL (use of the MySQL workbench is optional). There should be a very close relationship between the Tables & Relationships in your MySQL model & the Entity Relationship Diagram (deliverable 3). Populate the database with relevant data to be able to run substantial queries.
20%