Reference no: EM132964673

Data Modelling Case Study

The Clearwater Country Club is located in Joondalup and is about 25 km from Perth CBD.

The club needs to store information about who is a member because only members could use facilities of the club. To become members, they need to pay "one-time" joining fees when they join the club, then pay membership fees per month. The amount of joining fee and monthly membership fee depend on the type of membership they hold. Currently, the club offers gold, silver and bronze membership.

Each month, members receive invoices that include monthly membership fees and any charges for food. Members can order any food from different menus which include Japanese, Chinese and Italian. Invoice also includes charges for using facilities like an 18-hole golf course, tennis courts and badminton courts. These facilities are charged in an hourly basis. Other facilities like swimming pool and gym room are free of charges.

Members get discounts on all charges depend on the membership type they hold, for example, silver members get 15% discount. The discounts are also shown on the invoice.

All of the above information needs to be stored in the database. The new General Manager of the club, Mr Dominic Bradley, wants you to design a data model for the club to support a new application software system that can be used to manage its operation.

Construct a data model using a standard methodology

• Read your assigned case study carefully.

• Identify all possible "things" that are related to the construction of your ERD.

• Examine the "things" and identify all possible entities.

• Examine the remaining "things" and categorise them according to the entities identified.

• Validate and remove all irrelevant entities and attributes.

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