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.