Access

profileDeTazz
acc_project_wildoutfitters_data_model_1.zip
Home>Information Systems homework help>Access

ACC_Project_WildOutfitters_Data_Model_1.pptx

WildOutfitters.com Course Management System Data Model

*ClassID

ClassDate

ClassStartTime

ClassEndTime

ClassLocation

FKCustID

FKEmpID

FKCourseID

tblClass

tblEmployee

*EmpID

EmpLName

EmpFName

EmpPhNum

EmpEMail

=

One to Many Relationship

tblCustomer

*CustID

CustLName

CustFName

CustAddress

CustCity

CustState

CustZipCode

CustEMail

*CourseID

CourseName

CourseType

tblCourse

=

Unique Identifiers (become the primary keys in your tables)

*

Sample Table View of the Employee Entity

EmpID EmpLName EmpFName EmpPhNum EmpEMail
1 Johns Sara 555-1213 [email protected]
2 Marks Jennifer 555-1214 [email protected]
3 Timberlake Isaac 555-1215 [email protected]

Sample Table View of the Course Entity

CourseID CourseName CourseType
1 Intro. to Day Hiking Half-Day
2 Basic Backpacking Half-Day
3 Rock Climbing Fundamentals All-Day
4 Intro to Kayaking All-Day

Sample Table View of the Customer Entity

CustID CustLName CustFName CustAddress CustCity CustState CustZipCode CustEMail
1 Kregg Pat 123 Main Street Yourtown CA 90200 [email protected]
2 Lenten Lisa Rose 12 College Avenue Anytown GA 30600 [email protected]
3 Nicols Estelle 23 Church Street Mytown ND 73040 [email protected]

Sample Table View of the Class Entity

ClassID ClassDate ClassStartTime ClassEndTime ClassLocation FKCustID FKEmpID FKCourseID
1 10/28/2006 0900 1200 Rocky Bald State Park Conference Room 2 2 2
2 09/16/2006 0900 1100 In-Store 1 2 1
3 08/19/2006 0930 1530 Broad River Pavilion 3 3 4