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
This note was uploaded on 02/10/2012 for the course CIS 250 taught by Professor Wright during the Spring '09 term at S. Alabama.
- Spring '09