1) Develop a Statement of Requirements (SOR) for a database system (targeting 3 to 5 Entity Types and a similar number of Relationship Types).

In the SOR describe what the information needs are for this system, what data is in-scope and also what data is out-of-scope.

Finally identify what processing needs to be included. The processing should include any calculations that will be required, what queries, forms, and reports need to be produced, and anything else to be included in the deliverable database system.

2) Develop an ERD (including attributes with their data types and domain constraints) for there requirements.

3) Create a Relation Diagram for this ERD.