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 |
Other resource requirements: | Microsoft Access, MySQL |
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. 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% | 8 |
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.