lab4_mwilliams1.accdb
| Instructor_ID | Course_No |
| 1 | 222 |
| 4 | 222 |
| 5 | 222 |
| Campus_Name | Address | Zip | Phone_No |
| North | 123 Main Street | 88888 | 5559876541 |
| Online | 123 Main Street | 88888 | 5551234567 |
| South | 222 South Road | 88808 | 5554441234 |
| Class_Id | Course_No | Section_No | Semester_Name | Year | Instructor_ID | Campus_Name | Room_No | Start_Date | Start_Time |
| 1 | 222 | 02 | Spring | 2009 | 5 | Online | 302 | 033009 | 10:30 AM |
| Course_No | Course_Name | CreditHours |
| 222 | Welcome to Database | 3 |
| Instructor_ID | Last_Name | First_Name | Address | Zip | Office_No |
| 1 | Lane | Clark | | | 555 |
| 4 | birze | bbb | | | 4 |
| 5 | Smith | Bob | | |
|
| Campus_Name | Room_No | Facility | Capacity |
| Online | 302 | |
|
| Semester_Name |
| Fall |
| Spring |
| Summer |
| Student_ID | Last_Name | First_Name | Address | Zip | Major | Class | Status |
| 1 | Smith | James | 555 Ohio Road | 88888 | Business | | 5 |
| 2 | Doe | Jane | 32 3rd Ave | 88888 | Biology | | 10 |
| 3 | Miller | Mark | 511 Easy streer | 88808 | Math | | 5 |
| 4 | Smith | Ty | 54 Main Street | 88808 | Math | | 3 |
| Student_Id | Class_Id | Student_Grade |
| 1 | 1 | A |
| 2 | 1 | b |
| 3 | 1 | b |
Topsolutions
