Database Management System
CSE · Quiz · Summer 25
Paper 1 of 4Section 65_HSwitch
Section 65_H
Paper 1 of 4
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Database management System
Quiz-1
ID: Section-65_H Date:26.05.2025
Based on the following scenario, draw the ERD and Schema Table.
FitLife is a rapidly growing fitness center chain with multiple gym locations across various cities. Each gym operates independently but follows a centralized management system. Each gym has a unique identifier, a name, an address, and tracks the total number of registered members.
To provide diverse workout options, each gym offers multiple fitness classes, such as yoga, strength training, and aerobics. Every class has a unique identifier, a class name, a scheduled date and time, and a maximum capacity. Classes are conducted by one or more instructors who bring their expertise to different gym locations. Instructors have a unique identifier, name, contact details, and area of specialization.
Members who join FitLife gyms are assigned a unique membership ID. Their personal details, including name, contact number, and membership type (e.g., monthly, yearly), are stored. Members can attend classes at different gym locations but must enroll in specific classes to participate. Each enrollment records the date when the member signed up.
Each membership is associated with a specific gym and has details like start date, end date, and membership status (active, expired). A member can only have one active membership per gym at a time, but they can transfer their membership to another gym if needed.
To ensure smooth operations, FitLife employs staff members in different roles, such as front desk personnel, cleaners, and gym managers. Every staff member is uniquely identified and is assigned to a single gym, where their name, role, and salary are recorded. A gym can have multiple staff members, but no staff member is shared between different gym locations at the same time.