Develop an entity relationship diagram

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.

Reference no: EM132964673

Questions Cloud

What is the aggregate present value : What is the aggregate present value of $500 received at the end of each of the next three years, assuming a discount rate of (i) 4 percent

Case study-shopify : In your opinion, how important was it that Lutke remained the CEO of the company? Do you think companies can grow if the founding team leaves?

Contrast managerial accounting and financial accounting : Contrast Managerial Accounting and Financial Accounting by highlighting the differences in their job focus for Amazon

Roi and cost-benefit analysis : How you would one use a ROI and cost-benefit analysis as part of a business strategy?

Develop an entity relationship diagram : Develop an Entity Relationship Diagram - Examine the remaining "things" and categorise them according to the entities identified.

Explain the ritz-carlton philosophy of selecting employees : Explain the Ritz-Carlton philosophy of selecting employees to build their capabilities for proficient strategy execution. How did the Ritz-Carlton get the "righ

Describe two ways community service workers : Describe two ways that community service workers could clarify their level of authority.

BUSI2231 Research Methods and Statistics Assignment : BUSI2231 Research Methods and Statistics Assignment Help and Solution, Durham University - Assessment Writing Service

Jornalize the purchase, the return and the payment made : Princess Jewelry purchased inventory for $ 7,000 on credit to Wholesale Jewelry on February 2. Jornalize the purchase, the return and the payment made

User Account

All Pages