Online discussion questions – Day 32 (Apr 3) – Designing Data
In the example below, there are four entities (Personnel, Member, Facility, Equipment). What are the attributes and the relationships? What are the relationship types?
Foothills Athletics is an athletic facility offering services in the greater Highlands Ranch, Colorado, area. All property owners living in Highlands Ranch are members of the Recreation Function of the Highlands Ranch Community Association (HRCA). Foothills Athletics consists of a recreation facility where residents have the opportunity to participate in athletic activities, enroll their children in day camp or preschool, or participate in an HRCA program.
- Personnel: Foothills Athletics has a number of employees, primarily fitness course instructors and administrative personnel (e.g., billing clerks, equipment managers, etc.). Records are kept on each employee, past and present, detailing employee name, address, phone number, date of hire, position, and status as either a current or former employee. Employees are assigned a unique four-digit Employee ID number when they are hired.
- Members: When joining the Foothills Athletic center, individuals are assigned a unique four-digit Member ID number. This information along with their name, address, phone number, gender, birth date, and date of membership are recorded. At the time of enrollment, each member decides on one of three available membership types along with a fixed membership fee: Platinum ($400), Gold ($300), and Silver ($200). This is a one-time fee that establishes a lifetime membership.
- Facilities and Equipment: Foothills Athletics has a variety of facilities and equipment choices. Each facility has a unique room number and a size limitation associated with it. Some of the rooms contain pieces of exercise equipment; all have a serial number (provided by its manufacturer) that is used for inventory purposes. In addition, for each piece of equipment, purchase date and the date of its last maintenance are recorded. Each piece of equipment belongs to a specific equipment type, such as stair master machine, and is assigned a unique three-digit identification number. The description, the manufacturer’s model number, and the recommended maintenance interval for that model of equipment are also kept on file. Each equipment type is associated with a single manufacturer that is referenced by a unique two-digit manufacturer ID number. Additional information maintained on each manufacturer is the company name, address, and phone number.
5 Responses to Online discussion questions – Day 32 (Apr 3) – Designing Data
Leave a Reply
You must be logged in to post a comment.
Personnel Attributes: ID#, name, address, phone number, hiring date, position, status (current vs former employee)
Member Attributes: ID#, name, address, phone number, gender, birth date, date of membership, Membership type
Facilities Attributes: Room ID#, size limitation, equipment in a room,
Equipment Attributes: ID#, Serial number, location, purchase date, date of last maintenance, type of machine, description, manufacturer’s model number, recommended maintenance interval, manufacturer, manufacturer ID#, manu. address, manu. phone number.
Relationship:
-There is a one to many relationship between facilities and equipment. That is a room can have multiple pieces of equipment in it but a piece of equipment cannot be in multiple rooms at once.
-There is a one to many relationship between equipment and manufacturer. That is a piece of equipment has only one manufacturer but a manufacturer can produce multiple pieces of equipment.
Personnel Attributes: employee name, address, phone number, date of hire, position, status, and ID number.
Member Attributes: ID number,name, address, phone number, gender, birth date, and date of membership.
Facility Attributes: room number, and size limitation
Equipment Attributes: serial number, three-digit identification number, description, purchase date and the date of its last maintenance, recommended maintenance interval, and two-digit manufacturer ID number.
There is a 1 to many relationship between personnel and members, indeed, a personnel can help many members. There is many to many relationship between members and equipment, in fact, many members can use many equipment, and there is a 1 to many relationship between facility and equipment in that one facility can have many equipment.
Throughout this example:
Personnel Attributes – ID Number, Name, Address, Phone Number, Hiring Date, Position, Status
Member Attributes – ID Number, Name, Address, Phone Number, Gender, Birth Date, Date of Membership, Membership Type
Facilities Attributes – Room ID Number, Size Limitation, Equipment
Equipment Attributes – ID Number, Serial Number, Location, Purchase Date, Date of Last Maintenance, Type of Machine, Description, Manufacturer’s Model Number, Recommended Maintenance Interval, Manufacturer, Manufacturer ID Number,
Relationship –
– There is a one to many relationship between facilities and equipment.
– There is a one to many relationship between personnel and members.
Member Attributes
Date of membership, phone number, id number, name, address, gender, birth date,
Personnel Attributes
id number .employee name, date of hire, phone number, address, position, status,
Facility Attributes:
Size limitation and room number
Equipment Attributes:
recommended maintenance interval, and two-digit manufacturer ID number, serial number, three-digit identification number, date of purchase, description, and last maintenance date,
-Members and personal: 1 to many (personal may help many members)
-Faculty and equipment: 1 to many (1 faculty can have many equipment)
-Members and equipment: many to many (many equipment is used by many members)
Personnel Attributes: ID#, name, address, phone number, hiring date, position, status (current vs former employee)
Member Attributes: ID#, name, address, phone number, gender, birth date, date of membership, Membership type
Facilities Attributes: Room ID#, size limitation, equipment in a room,
Equipment Attributes: ID#, Serial number, location, purchase date, date of last maintenance, type of machine, description, manufacturer’s model number, recommended maintenance interval, manufacturer, manufacturer ID#, manu. address, manu. phone number.
Relationship:
-There is a 1 to M relationship between facilities and equipment.
-There is a 1 to M relationship between equipment and manufacturer.