You have been commissioned by your client to create: Design a database for Southern Cross University Fitness Centres at two different places "Bently" and "Mount Lawley".

1. Develop a short case study (about three hundred words) to describe the "things" you plan to store and how the "things" interact within your database.
2. Identify all possible "things" that are related to the construction of your ERD.
3. Examine the "things" and identify all possible entities.
4. Examine the remaining "things" and categorise them according to the entities identified.
5. Validate and remove all irrelevant entities and attributes.
6. Report the above findings by completing the following table.
7. construct a data model using a standard methodology
8. construct a database in a way that provides business value
9. conceptualise solutions to complex data requirements
10. apply SQL programming skills to create business solutions.
11. Dataset information
12. Analysis of your findings

Based on the entities and attributes identified above, develop an Entity Relationship Diagram (ERD), and a Relational Model that comply with Referential Integrity and being in Third Normal Form.

Your ERD must use the notation specified in the lectures and labs, i.e., a combination of Chen and Crow's foot notations.

Answer rating: 100% (QA)

Creating a database for Southern Cross University Fitness Centres at Bentley and Mount Lawley requires careful planning Heres a brief case study and a... View the full answer