Myunsw Unsw Health
To full a course, we only think about the scholars who receive a mark for the course taken. Database Systems has worth ‘Database Systems’ within the Subjects.name area. You can find the information about all of the course offerings for a given topic from Courses. You should calculate the average mark of enrolled college students for a course offering from the table Course_enrolments.
A useful thing to do initially is to get a feeling for what information is definitely there. This might allow you to understand the schema higher and can make the descriptions of the workouts simpler to grasp. UNSW has spent a considerable sum of money ($80M+) on the MyUNSW/NSS system, and it handles much of the educational administration plausibly well.
This back-end system (Peoplesoft/Oracle) is usually known as NSS. We only contemplate the programs enrolled by no less than one international scholar. See also the Pro-Vice-Chancellor ‘s Privacy Code of Practice for particulars of UNSW coverage, procedures and safeguards in place to manage college students’ personal info. his app at present supplies access to course content material for students at UNSW.
NSS incorporates information about pupil, programs, courses, pre-requisites, quotas, and so forth. but does not include any representation of UNSW’s degree program buildings. Without such data in the NSS database, it is not attainable to do any of the above three. So, in 2007 the COMP9311 class devised a knowledge model that would characterize program necessities and guidelines for UNSW degrees. This was built on high of an current schema that represented all the core NSS information (students, workers, programs, lessons, and so forth.). All Universities require a major info infrastructure to be able to handle their affairs.
When calculating the average, only contemplate college students who’ve a not null mark. Each query is presented with a quick description of what’s required. If you want the total particulars of the expected output, check out the expected_qX tables supplied in the checking script. The MyMyUNSW database consists of information that encompasses the functionality of NSS, the UNSW Online Handbook, and the CATS database.
- Here you can see info on Accepting/Deferring your Offer, Enrolment, ID Cards, IT Services, Orientation, Settling In and so on.
- Without such info within the NSS database, it is not possible to do any of the above three.
- In such case, there isn’t any scholar enrolling in multiple course.
- Define an SQL view Q1 that gives the name of employees position (refers back to the staff_roles.name) and the number of distinct courses taught by every type of staff within the 12 months 2010 (refers to Semesters.12 months).
Only consider valid courses which have a minimum of 10 college students. Define an SQL view Q1 that gives the name of employees position (refers back to the staff_roles.name) and the number of distinct courses taught by every kind of workers in the yr 2010 (refers to Semesters.12 months). The outcomes must be ordered by course_num from lowest to highest. The goal is to construct some useful data entry operations on the MyMyUNSW database.
The MyMyUNSW data model, schema and database are described in a separate document. It seems you’re caught at a different step to me which I managed to get by way of. Is that the half the place you put in your course and UAC data? If so check that the course code is the UNSW code not the UAC code, they are completely different and this stumped me. The University reserves the best to alter terms, situations or policies concerning entry to and use of myUNSW at any time.