Give a conceptual data model (CDM) for the following given scenario using the Entity-Relationship model, including the complete E-R diagram, the entity types, attributes, any required constraints, assumptions and limitations. A health club database keeps track of the health club’s employees, members, activities and special events. Suppose that after the requirements collection and analysis phase, the database designers provided the following description of the part of the health cub to be represented by the database. The health club is organized into departments such as administration, finance, training, recreation etc. Each department has a unique name a unique number and a particular employee who manages the department. The system keeps track of the start date when that employee began managing the department. A department controls a number of activity sessions, each of which has a description, a unique number and a single location. The database stores each employees name, ID number, address, salary, gender and birth date. An employee is assigned to one department but may work on several activities, which are not necessarily controlled by the same department. The system keeps track of the number of hours per week that an employee works on each activity session. The system also keeps track of the direct supervisor of each employee. It also keeps track of the members of the club. Each member is identified by a unique Id. Other details to be stored are the first name, last name, gender, date of birth, height, weight and medical condition. The health club conducts medical seminars and workshops time to time, the seminar ID, topic, date of seminar and the speaker information to be stored in the system. The members can join for special offer package program or regular one or they can just attend only seminar/workshops. if anyone can help me in this?
Posted on: Thu, 04 Dec 2014 11:33:48 +0000