Exercise: SQL Queries (3)
Consider a database to model UNSW:
- people: staff (academic/general), students, ...
- organisational units: schools, faculties, centres, ...
- places: buildings, rooms, phones, ...
- programs: title, degree, ownership, rules, ...
- subjects: code, title, syllabus, UC, hours/week, ...
- courses: subject, session, LIC, enrolments, ...
- classes: type, course, location, time, capacity, ...
In other words, what NSS/MyUNSW should have been ...
|
![[prev]](icon/prev.gif){kind=icon}
![[index]](icon/up.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}