IS223 Fitness First homework PDF

Preview

Summary

practice for exam...

Description

FITNESS FIRST David Ernesto is a recent graduate of Boston University’s Questrom School of Business. He is also a former varsity tennis player and interested in turning his interest in fitness and athletics into a business. He has partnered with his former roommate, also a Questrom graduate, and together they have rented space in a former warehouse in Allston. David is convinced that the growing population of young professionals in the Boston area who no longer have access to their college fitness facilities but who want to stay in shape represents a great market opportunity. He has also determined that to be competitive in the fitness business that he has to offer an array of different classes to attract members. He has begun to hire specialized instructors who will offer classes in yoga, boxing, cross-fit training and spinning. He and his roommate are interested in tracking which classes are the most popular and also which clients attend the most classes. He remembers from his IS223 class that he could set up an Access database to track this information but he is a bit rusty on the particulars. He has begun to map out an E-R diagram shown below, but is not sure how to turn that into a functioning database. He has returned to campus to find a current IS223 student who can help.

Assignment: You have been asked to review his initial design and help him create the database. Before you begin, you want to understand the business rules that he is incorporating into the model. Based on the model below, answer the following questions:   

Can a fitness class have more than one instructor assigned to it? Does each room have to be assigned to a fitness class? To be considered a customer, does someone have to be enrolled in a class?

Show the tables that you would create to help David get started with his business.

Fitness_Class PK

Instructor

Class ID

Description

PK

Instructor ID

Capacity

Last Name

Number Enrolled

First Name

Start Date

Address

Number of Weeks

Phone Number

Class Length

Email

Difficulty Level

Customer PK

Customer ID

Last Name First Name Address

Room PK

Room ID

Description...