CITS4405 Relational Database Management Systems
- 6 points
Availability Location Mode Not available in 2019 UWA (Perth) Face to face
- 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).
- 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.
- Indicative assessments in this unit are as follows: (1) laboratory based exercises; (2) programming project; and (3) final examination. Further information is available in the unit outline.
Supplementary assessment is only available in this unit in the case of a student who has obtained a mark of 45 to 49 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)
- Dr Jianxin Li
- Unit rules
- enrolment in the Master of Information Technology (62510)
- CITS1402 Relational Database Management Systems, CITS2232 Databases
- Contact hours
- lectures: 2 hours per week; labs: 3 hours per week
To be advised by the School of Computer Science and Software Engineering.
- 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.
- Books and other material wherever listed may be subject to change. Book lists relating to 'Preliminary reading', 'Recommended reading' and 'Textbooks' are, in most cases, available at the University Co-operative Bookshop (from early January) and appropriate administrative offices for students to consult. Where texts are listed in the unit description above, an asterisk (*) indicates that the book is available in paperback.