This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. You will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system (Oracle). Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.
This unit has a requirement of 1-2 hours per week of asynchronous learning. Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled online and face to face learning activities and independent study. Independent study may include associated reading and preparation for scheduled teaching activities.
Develop programming structures within a database backend.
Apply the theories of the relational database model;
Manage data that meets user requirements, including queries and transactions;
Implement a relational database based on a sound database design;
Differentiate non-relational database model and the relational database model;
Develop a sound relational database design;
