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 this 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... -- Course Website
Instructor: Assistant Professor Wei Liu
Prerequisites: CITS1200 Java Programming or CITS1210 C Programming or CITS1220 Software Engineering or CITS1005 Computing for Engineers and Scientists or CITS1001 Object-oriented Programming and Software Engineering or CITS1002 Programming and Systems or CITS1401 Proble
