Database Management System for the Fitness Centre - Case Study Example

FITNESS_ACTIVITIES. This table stores information about fitness activities.MEMBERS. This table stores information about members of the fitness center.TRAINERS. This table stores information about trainers at the fitness center.USAGE. This table stores information about the usage of the activities by members and their trainers. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key). Remove subsets of data that apply to multiple rows of a table and place them in separate tables.

Create relationships between these new tables and their predecessors through the use of foreign keys. Remove columns that are not dependent upon the primary key. (Chapple 2005)These attributes are used to store the following information:FITNESS_ACTIVITIESID - primary keyNAME - The name of fitness activityDESCRIPTION - Description of fitness activityMEMBERS ID - primary keyNAME - the name of a member of the fitness center DATE - the date when the person became a member of the fitness center ADD_INFO - additional informationTRAINERSID - primary keyMEMBER_ID - link to ID of the member who uses the activityTRAINER_ID - link to ID of the trainer who trains the member who uses the activityACTIVITY_ID - link to ID of the fitness activityBEGIN_TIME - time when usage beginsEND_TIME - time when usage ends