Description

Project

This should be completed in groups of 4 – 6. There will be a presentation and a final report for the project.
1. Analyze the requirements of the organization
2. Identify the relevant entities, attributes, and relationships together with any constraints and properties
3. Produce an E-R diagram for the database
4. Convert the E-R diagrams to relational schemas (clearly indicating the primary keys, foreign keys, functional and/or multivalued dependencies, as well as justifying that your designs are in good, normalized form)
5. Populate the schemas with a reasonable amount of realistic data
6. Produce sample SQL queries on these relations that are used for practical daily operations and activities
7. Produce sample SQL queries on these relations which are of an analytic or data mining nature (this part is optional and carries extra bonus points of up to 8% of the total project mark)
8. Suggest which data fields of the relational schemas should be indexed or hashed, and explain your decision
9. Implement 4 to 6 (and possibly 7) of the above.
The entire project will account for 25% of the total mark of the course, with 8% allocated to the presentation, and 17% to the report. With the extra bonus points, the total project mark will not exceed 27%. The report should indicate the nature of contribution of each member, including the division of labor. It is possible and acceptable that all members contribute equally to all aspects of the project, and if so, this should be indicated. However, no member should be unaware of the work of other members, and each member must have a good overall knowledge of the entire project. Good, grammatically correct English is the mark of a good report, and this will be taken into consideration in the assessment of the report.
In your report, you should include the following main sections:
1. Introduction and motivation
2. Design and implementation
3. Conclusion and self-evaluation
4. References
5. Appendices