Microsoft Access
extrol12
LabExamCacophoneMusic.mdb| ClassID | CourseID | StartingDate | EndingDate | MaxEnrollment | ClassDay | ClassTime |
|---|---|---|---|---|---|---|
| BUS506E | BUS506 | 1/2/17 | 5/5/17 | |||
| BUS506EA | BUS506 | 1/2/17 | 5/5/17 | |||
| CNS323 | CNS323 | 1/4/17 | 5/7/17 | |||
| CNS413 | CNS413 | 1/5/17 | 5/8/17 | |||
| ELA100 | ELA100 | 1/4/17 | 5/7/17 | |||
| ELA200 | ELA200 | 1/4/17 | 5/7/17 | |||
| MIT531 | MIT531 | 1/3/17 | 5/6/17 | |||
| MIT531E | MIT531 | 1/3/17 | 5/6/17 | |||
| MIT532E | MIT532 | 1/4/17 | 5/7/17 |
| CourseID | CourseTitle | Fee | CourseRequirement |
|---|---|---|---|
| BUS506 | Management Information System | 400.50 | None |
| CNS323 | Group Counseling | 350.35 | None |
| CNS413 | Family Counseling | 350.12 | Group Counseling |
| ELA100 | Language Arts 1 | 300.15 | None |
| ELA200 | Language Arts 2 | 300.35 | Language Arts 1 |
| MIT531 | Database Design | 500.46 | Management Information System |
| MIT532 | Network Securities | 450.45 | None |
| StudentID | FirstName | LastName | PhoneNumber | EmailAddress | AmountPaid |
|---|---|---|---|---|---|
| 1 | Christine | Suiter | 703-425-8897 | [email protected] | ¤ 450.00 |
| 2 | Roy | Stuwart | 571-457-5647 | [email protected] | ¤ 350.00 |
| 3 | Rita | Zelonis | 571-547-3258 | [email protected] | ¤ 650.00 |
| 4 | Scott | Morgan | 210-254-8795 | [email protected] | ¤ 600.00 |
| 5 | John | Gill | 213-546-1456 | [email protected] | ¤ 650.00 |
| Student_ClassID | StudentID | ClassID |
|---|---|---|
| 1 | 1 | BUS506E |
| 2 | 1 | MIT531 |
| 3 | 2 | BUS506EA |
| 4 | 2 | MIT531E |
| 5 | 3 | ELA100 |
| 6 | 3 | CNS323 |
| 7 | 4 | ELA200 |
| 8 | 4 | CNS413 |
| 9 | 5 | BUS506E |
| 10 | 5 | ELA200 |
| TeacherPaymentID | PaymentAmount | Teachers_ClassesID |
|---|---|---|
| 1 | ¤ 400.00 | 1 |
| 2 | ¤ 500.00 | 2 |
| 3 | ¤ 600.00 | 3 |
| 4 | ¤ 400.00 | 4 |
| 5 | ¤ 500.00 | 5 |
| 6 | ¤ 600.00 | 6 |
| 7 | ¤ 300.00 | 7 |
| TeacherID | FirstName | LastName | Street | City | State | Country | PostalCode | Phone |
|---|---|---|---|---|---|---|---|---|
| 1 | Sander | Klaus | ||||||
| 2 | Faria | MacDonald | ||||||
| 3 | Donald | Liu | ||||||
| 4 | Thomas | Gan |
| Teacher_ClassID | TeacherID | ClassID |
|---|---|---|
| 1 | 1 | BUS506E |
| 2 | 1 | MIT532E |
| 3 | 2 | CNS323 |
| 4 | 2 | CNS413 |
| 5 | 3 | ELA100 |
| 6 | 3 | ELA200 |
| 7 | 3 | MIT531E |
| 8 | 4 | BUS506EA |
| 9 | 4 | MIT531 |
