CITS1402 Relational Database Management Systems

Credit
6 points
Offering
(see Timetable)
AvailabilityLocationMode
Semester 2UWA (Perth)Face to face
Details for undergraduate courses
  • Level 1 core unit in the Computer Science; Data Science major sequences
  • The area of knowledge for this unit is Mathematical and Physical Sciences
  • Category B broadening unit for students
  • Level 1 elective
Content
This unit deals with data modelling through the theory and practice of database design, implementation and use. Several database models are addressed, with a strong focus on the relational model and its theoretical grounding in sets and relational algebra. The process of problem decomposition into entity-relations, the design of appropriate relational schemas, and their refinement through normalisation underlies the unit. Critical issues surrounding the design of query languages and their implementation are addressed, and information retrieval is practised using a specific query language. Students learn database connectivity by building systems in one of several programming languages that support a connectivity Application Programming Interface (API).
Outcomes
Students are able to (1) understand existing database implementation and create refinements and improvements through analysis; (2) understand the 'business' requirements to design a database; (3) refine the database to improve and ensure correctness and reliability; (4) correctly program structured query language (SQL) queries and reports; and (5) build an application layer interface for easier user interaction.
Assessment
Indicative assessments in this unit are as follows: (1) weekly laboratory work; (2) small project; and (3) mid-semester test and final examination. Further information is available in the unit outline.

Supplementary assessment is not available in this unit except in the case of a bachelor's pass degree student who has obtained a mark of 45 to 49 overall and is currently enrolled in this unit, and it is the only remaining unit that the student must pass in order to complete their course.
Unit Coordinator(s)
Professor Gordon Royle
Unit rules
Prerequisites:
ATAR Mathematics Applications or MATH1720 Mathematics Fundamentals or equivalent or higher
Incompatibility:
CITS2232 Databases
Contact hours
lectures: 2 hours per week; labs: 2 hours per week
  • The availability of units in Semester 1, 2, etc. was correct at the time of publication but may be subject to change.
  • All students are responsible for identifying when they need assistance to improve their academic learning, research, English language and numeracy skills; seeking out the services and resources available to help them; and applying what they learn. Students are encouraged to register for free online support through GETSmart; to help themselves to the extensive range of resources on UWA's STUDYSmarter website; and to participate in WRITESmart and (ma+hs)Smart drop-ins and workshops.
  • Unit readings, including any essential textbooks, are listed in the unit outline for each unit one week prior the commencement of study. The unit outline will be available via the LMS and the UWA Handbook. Reading lists and essential textbooks are subject to change each semester. Essential textbooks can be purchased from the commercial vendors to secure the best deal. The Student Guild can provide assistance on where to purchase books if required. Books can be purchased second hand at the Guild Secondhand bookshop (second floor, Guild Village), which is located on campus. Copies of textbooks and other readings will be made available for students to access from the Library, online wherever possible as well as in print.