This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CIS 250 Sp09 Page 1 of 4 Database Project CIS 250 Spring, 2009 You have been retained as a consultant to design a database for a local health and fitness club. The database is to track the classes that are offered, the customers that are members of the club, and the classes that they register for. You must use the attached dataset and this database design for your project. Reminder : This is an individual project assignment. There is to be ABSOLUTELY no file sharing in any form for this assignment. The misconduct policy will be STRICKLY enforced! This project must be completed using Access 2007. Requirements for this database: 1) Tables are to be constructed as follows: a. CLASSES 1. ClassID primary key, text, field size 5 2. ClassName text, field size 25 3. HourlyPrice currency 4. Level text, field size 15, use lookup to build list (Easy, Medium, Hard) 5. ClassDay text, field size 3, use lookup to build list (Mon, Tue, Wed, Thu, Fri, Sat, Sun) 6. ClassTime date/time; select medium time b. CUSTOMERS 1. CustomerID primary key, text, field size 6 2. FirstName text, field size 25 3. LastName text, field size 25 4. Address text, field size 50 5. City text, field size 25 6. State text, field size 2; force uppercase 7. ZipCode text, field size 15; use zip code input mask 8. PhoneNumber text field size 15; use proper phone input mask 9. Membership text, size 1; valid entries I or F (Individual or Family) Include meaningful text for the Validate Rule 10. EmailAddr text, field size 50 c. REGISTRATION 1. RegID primary key, autonumber 2. CustomerID text, field size 6, foreign key 3. ClassID text, field size 5, foreign key 4. PaymentAmt currency 2) In addition to the information in the attached dataset, enter a CUSTOMERS record containing your personal information and a CLASS of you choosing. Be sure you Register yourself for your personal information and a CLASS of you choosing....
View Full Document
- Spring '09