|1.||Abstract data requirements into data models using entity-relationship diagram and relational data model and design relational databases;|
|2.||Formulate efficient SQL queries to store, manipulate and transform data into useful information to users;|
|3.||Assess and rationalise database design with functional dependencies and normal forms;|
|4.||Propose and devise query optimisation, transaction and security management for relational database management systems; and|
|5.||Exhibit mastery of theoretical knowledge and practical skills relating to the Relational Data Model and Relational Database Management Systems.|
|Laboratory Work||Laboratory submissions (10)||10%|
|Assignment||Group Database Project||40%|
Where to next?
As part of a course
This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.
VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.