MIT502 Database Systems

Unit outline

Important Update: Our aim is to provide you with an optimal learning experience, regardless of how this unit is delivered. Teaching will be delivered in line with the most current COVID Safe health guidelines.  This may include a mix of online and face-to-face.  Please check the learning management system for announcements and updates. Thank you for your flexibility and commitment to studying with Sydney Institute of Higher Education. 
Enrolment modes: Year 1, Semester 1
Credit point(s): 12.5
EFTSL value: 0.125
Prerequisite: Nil
Typical study commitment: Students will on average spend 10 hours per week over the teaching period undertaking the teaching, learning and assessment activities for this unit.
Scheduled learning activities: 4 timetabled hours per week, 6 personal study hours per week
Other resource requirements: Students will need access to lab computers or will need their own laptops in order to carry out lab exercises and assignments. Students will need to use MySQL, MS Access, and Visio.

Unit description 

This unit introduces fundamental concepts and principles of effective management, organization, manipulation and use of data. Students will learn how to design a database using a set of business rules and applying data modelling techniques such as ER (Entity-Relationship) modelling and relational database design. Students will also learn how to query databases using SQL (Standard Query Language).  Other database concepts will also be examined such as database administration, concurrency, data integration, data warehousing, backup & recovery, security and distributed databases.


Unit learning outcomes (ULO)   

 
On the successful completion of this units student will be able to:
ULO1 Evaluate effective data management techniques.
ULO2 Analyse the benefits of a range of databases and their applications.
ULO3 Apply database normalization techniques to avoid data anomalies.
ULO4 Use SQL to query data from existing databases.
ULO5 Evaluate the significance and requirements of data quality, currency and security.

Topics to be included in the unit

1. Introduction to databases, database environment, and development process
2. Modelling data and Entity-Relationship (E-R) model
3. Enhanced E-R model
4. Logical database design and the relational model
5. Introduction to SQL (Standard Query Language)
6. Advanced SQL
7. Databases in applications
8. Physical database design and database infrastructure
9. Data warehousing and data integration
10. Database administration
11. Distributed databases
12. Object-oriented data modelling & Revision

Assessment

Assessment Description Grading and weighting
(% total mark for unit)
Indicative due week 
Assessment 1: Class Participation 10% 12
Assessment 2: Online Quiz 10% 5
Assessment 3: Group Assignment 25% 8
Assessment 4: Individual Assignment 25% 12
Assessment 5: Final Exam 30% Final exam week

The assessment due weeks provided may change. Your lecturer will clarify the exact assessment requirements, including the due date, at the start of the teaching period.