BUS107 Database I

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 2
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

Unit description 

This unit introduces the architecture of database systems and outlines different models. Students will learn how to design and implement a simple database system and explain how the system enhances the organisation’s business model. Students will also design interfaces and write in query languages. The main focus of the unit will be SQL query language. The theoretical discussion of the weekly topics is supported by practical hands-on exercises using relational database management systems.


Unit learning outcomes (ULO)   

  On the successful completion of this units student will be able to:
ULO1 Demonstrate a thorough theoretical understanding of database concepts and query languages. 
ULO2 Analyse possible risks and ethical and social considerations relevant to the design of a database system.
ULO3 Implement intermediary SQL syntaxes and semantics.
ULO4 Consider security mechanisms in data storage.
ULO5 Analyse and apply normalisation techniques for database creation.
ULO6 Compare database modelling techniques such as ER and EER and use modelling to create relational database designs. 

Topics to be included in the unit

1. Introduction to database management systems
2. Data modelling
3. Relational database
4. Entity relationship modelling
5. SQL syntax
6. ODB (Object Database)
7. Database design
8. Normalisation
9. File structure and performance
10. Data storage and recovery
11. Concurrency control and transaction management
12. Basics of secure database

Assessment 

Assessment Description Grading and weighting
(% total mark for unit)
Indicative due week 
Assessment 1: Mid-Semester Exam 30%  Mid-semester exam week 
Assessment 2: Individual Assignment  20%
Assessment 3: Final Exam 50% 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.