50 likes | 293 Views
tblEmployee. tblCustomer. * EmpID EmpLName EmpFName EmpPhNum EmpEMail. * CustID CustLName CustFName CustAddress CustCity CustState CustZipCode CustEMail. tblClass. tblCourse. * ClassID ClassDate ClassStartTime ClassEndTime ClassLocation FKCustID FKEmpID FKCourseID.
E N D
tblEmployee tblCustomer *EmpID EmpLName EmpFName EmpPhNum EmpEMail *CustID CustLName CustFName CustAddress CustCity CustState CustZipCode CustEMail tblClass tblCourse *ClassID ClassDate ClassStartTime ClassEndTime ClassLocation FKCustID FKEmpID FKCourseID *CourseID CourseName CourseType * = Unique Identifiers (become the primary keys in your tables) = One to Many Relationship WildOutfitters.com Course Management System Data Model