diff --git a/STINK_student_records.xml b/STINK_student_records.xml index 5d99cbc..6268591 100644 --- a/STINK_student_records.xml +++ b/STINK_student_records.xml @@ -6,13 +6,13 @@ System specification and details -

The Southern Technical Institute for Natural Knowledge is a medium-sized tertiary education provider (founded in 1982) that teaches papers across many subjects, which lead to several different qualifications. They are currently in the process of designing and implementing a new student records database. The requirements analysis phase of the project is complete, and you have been brought in as a lead database developer. It will be your task to implement an initial prototype of the specification resulting from the requirements analysis phase. An ERD of the proposed database is shown in , and more detailed specifications of the database requirements may be found in the following sections.

+

The Southern Technical Institute for Natural Knowledge is a medium-sized tertiary education provider (founded in 1982) that teaches papers across many subjects, which lead to several different qualifications. They are currently in the process of designing and implementing a new student records database. The requirements analysis phase of the project is complete, and you have been brought in as lead database developer. It will be your task to implement an initial prototype of the database specification resulting from the requirements analysis phase. An ERD of the proposed database is shown in , and more detailed specifications of the database requirements may be found in the following sections.

- Design-level ERD of the proposed database (Barker notation) + ERD of the proposed database (Barker notation) - Design-level ERD of the proposed database (Barker notation) + ERD of the proposed database (Barker notation)
@@ -136,7 +136,7 @@ The paper code comprises a four-letter subject code (e.g., “INFO”) followed by a three digit course number (e.g., “214”). - The period of a paper must be one of the following: “SS” (Summer School), “S1” (Semester One), “S2” (Semester Two) or “FY” (Full Year). + The period must be one of the following: “SS”, “S1”, “S2” or “FY” (representing Summer School, Semester One, Semester Two and Full Year, respectively). @@ -271,7 +271,7 @@ * Salary - Monetary, 40450.00 + Money, 40450.00 @@ -316,11 +316,11 @@ - Staff and Student are subtypes of Person, and thus share the same primary key values. + Staff and Student are subtypes of Person, and thus share primary key values. - Contact phone numbers must cater for full national landline and mobile numbers. Students’ home phone numbers must cater for full international numbers, as many students are from overseas. + Contact phone numbers must cater for full New Zealand landline and mobile numbers. Students’ home phone numbers must cater for full international numbers, as many students are from overseas. - A staff member’s rank must be one of the following: “AL” (Assistant Lecturer), “L” (Lecturer), “SL” (Senior Lecturer), “AP” (Associate Professor) or “P” (Professor). Salaries for the highest level positions are over 100000. + A staff member’s rank must be one of the following: “T”, “AL”, “L”, “SL”, “AP” or “P” (representing Tutor, Assistant Lecturer, Lecturer, Senior Lecturer, Associate Professor and Professor, respectively). Salaries for senior positions exceed 100000. @@ -424,7 +424,7 @@ - The teaching year cannot be earlier than the year in which the Institute was founded. (Technically it should also not be in the future, but this is surprisingly difficult to check in ! You are welcome to try if you have already completed the rest of the assignment.) + The teaching year cannot be earlier than the year that the Institute was founded. (Technically it should also not be in the future, but this is surprisingly difficult to check in ! You are welcome to try, but please ensure that you complete the rest of the assignment first.) The role must be one of the following: “Coordinator”, “Lecturer” or “Tutor”. @@ -489,7 +489,7 @@ o Comments - Arbitrary text + Text (see below) @@ -499,9 +499,9 @@ - The year of enrolment cannot be earlier than the year in which the Institute was founded (nor in the future—see the note above under the Teachentity). + The enrolment year cannot be earlier than the year that the Institute was founded (nor in the future—see the note above under the Teachentity). - The Comments attribute is used to record details of any issues relating to the enrolment, e.g., a detailed explanation of the reasons for waiving a prerequisite, or a description of how a timetable clash is to be resolved. + Comments are used to record details of any issues relating to the enrolment, e.g., a detailed explanation of the reasons for waiving a prerequisite, or a description of how a timetable clash is to be resolved. @@ -601,13 +601,13 @@ - A new set of assessments is created for each year that a paper is offered. The year cannot be earlier than the year in which the Institute was founded (nor in the future—see the note above under the Teachentity). + A new set of assessments is created for each year that a paper is offered. The year cannot be earlier than the year that the Institute was founded (nor in the future—see the note above under the Teachentity). - The assessment type must be one of the following: “A” (assignment), “P” (presentation), “T” (test) or “X” (exam). + The assessment type must be one of the following: “A”, “P”, “T” or “X” (representing assignment, presentation, test and exam, respectively). - The Maximum_Mark attribute stores the maximum possible raw mark for the assessment (e.g., 30), while the Weight attribute stores the percentage weight of this assessment for the paper as a whole (e.g., 10). If Maximum_Mark is not specified, then applications should use Weight for both. + The Maximum_Mark attribute stores the maximum possible raw mark for the assessment (e.g., 30), while the Weight attribute stores the percentage weight of this assessment for the paper as a whole (e.g., 10). If Maximum_Mark is not specified, then front-end applications should use Weight for both. - The Release attribute controls whether or not the marks for this assessment are publicly accessible. + The Release attribute controls whether or not the marks for this assessment are accessible by students. @@ -693,7 +693,7 @@ - The Raw_Mark attribute stores the raw mark awarded for an assessment. Its value should be between zero and the value of Assessment.Maximum_Mark (note that only the former is required for this assignment—bonus marks if you can also achieve the latter). + The Raw_Mark attribute stores the raw mark awarded for an assessment. Its value should be between zero and the value of Assessment.Maximum_Mark (note that only the lower bound is required for this assignment—bonus marks if you can also implement the upper bound). The value of the Weighted_Mark attribute is calculated by the formula: Raw_Mark / Assessment.Maximum_Mark Assessment.Weight. @@ -701,7 +701,7 @@ The value of the Percentage_Mark attribute is calculated by the formula: Raw_Mark / Assessment.Maximum_Mark 100. - Note that the two calculations above are not constraints and should not be implemented as such. You may attempt to implement these calculations if you feel confident in your ability to do so, but please ensure that you complete the rest of the assignment first. + Note that the calculations for Weighted_Mark and Percentage_Mark are not constraints and should not be implemented as such! You may attempt to implement these calculations if you feel confident in your ability to do so, but please ensure that you complete the rest of the assignment first.