In your role as a Database Consultant, you have been assigned a project to upgrade the college’s Student Record System. The objective of the new system is to allow authorized members to access the records of academically registered students. The system is required to provide a useable and well-managed interface for students, academics, and administrators to view and manipulate the data for which it is responsible. For each, it must allow the rapid formulation and resolution of queries related to the student information, such as students’ details, courses, and exams. There is also a requirement for the system to interact with other information sources as required during the resolution of queries.

Assessment Deliverables:

1. Design document (see below). You are required to submit an MS Word document describing all stages of the project. This is worth 50% of your overall grade for this module.

Assignment tasks (design document):

Requirements specification (20 Marks)

 data requirements

transaction requirements

Conceptual design (40 Marks)

draw EER diagram(s) in UML (it includes hierarchies);

explain entities, if necessary;? explain attributes (for each entity), if necessary; specify attribute domains;

Explain relationships, if necessary (you may need to specify further semantic assumptions (i.e., apart from the ones stated in the requirements specification) when you explain structural constraints);

Logical design (40 Marks)

Transform ER model into a relational model

specify ‘relational constraints’:

candidate keys; primary key;

foreign keys;

normalize the relational model

Your document should be in a report format containing a table of contents, headings, and sub-headings as necessary. You are also required to acknowledge any source of information you have used in your document in the form of in-text citations, and a references list at the end of your document. You can add any extra information that you deem relevant in an appendix section at the end of your report.