tbl Employee tbl Class Emp ID Class ID
tbl. Employee tbl. Class *Emp. ID *Class. ID Emp. Last. Name Emp. First. Name Emp. Position Emp. Phone Emp. Email Class. Date Class. Start. Time Class. End. Time Class. Location _________ tbl. Customer tbl. Course *Course. ID Course. Title Course. Type Course. Desc What should the foreign keys be here? * = Unique Identifiers (become the primary keys in your tables) *Cust. ID Cust. Last. Name Cust. First. Name Cust. Address Cust. City Cust. State Cust. Zip Cust. Phone Cust. Email = One to Many Relationship
Sample Table View of the Employee Entity Emp. ID Emp. Last. Name Emp. First. Name Emp. Position Emp. Phone Emp. Email 1 Felton Luca Instructor 970 -1231234 lfelton@wfi. com 2 Shumer Anya Instructor 912 -7771214 ashumer@wfi. com 3 Tucker Ramon Training Manager 404 -7771215 rtucker@wfi. com 4 5
Sample Table View of the Course Entity Course. ID Course. Title Course. Type Course. Desc 1 Intro to Backpacking All-Day Discussion of trip planning, equipment lists, and proper packing techniques. 2 Basic Caving Half-Day Safety and lighting fundamentals. You will get muddy. Dress appropriately. 3 Bouldering Fundamentals Half-Day Rock climbing basics applied to short (20 ft-30 ft) but difficult problems. 4 Introduction to Kayaking Learn the fundamentals of wet exit, rolling, and basic paddle technique. 5 All-Day
Sample Table View of the Customer Entity Cust. ID Cust. LName Cust. FName Cust. Address Cust. City Cust. State Cust. Zip. Code Cust. Phone Cust. Email 1 Turner Taylor 678 Maple Circle Austin TX 02108 (617) 8761234 TT@nphil. com 2 Morgan Kyle 18 River Street Savannah GA 31401 (912) 2345678 KM@minerva. org 3 Williams Ada 524 Zion Street Queens NY 10022 (212) 7463524 AW@qwlgm. com 4 5
Sample Table View of the Class Entity Class. ID Class. Date Class. Start. Time Class. End. Time Class. Location 1 07/07/2019 0900 1200 Granite State Park ? ? ? 2 07/16/2019 0900 1100 In-Store ? ? ? 3 03/15/2019 0930 1230 Troll Caverns ? ? ? 4 04/07/2019 0830 1600 Granite State Park ? ? ? 5 6 7 8 9 10 Foreign key?
- Slides: 5