Database Concepts and Modelling
CIS211
Not sure where to start?
- Is online study right for me?
- Why OUA?
- What should I study?
- How does it work?
- How do I enrol?
Discover what's involved in studying through OUA.
Find out moreOverview
Level of study: What does Undergraduate Level 2 mean?
Undergraduate Level 2
EFTSL: What does EFTSL mean?
0.125
Delivery Method: What does delivery method mean?
Fully Online
Prerequisites: What are the prerequisites?
Availability: What is a Study period?
For enrolment (2012): For forward planning* (2013): What is Forward Planning?- -
- SP2
- -
- SP4
Duration:
13 weeks
Fee: Fees (current and planned)
- Domestic student fee:
- $1,039.00 (AUD)
- HECS student fee:
- $1,006.00 (AUD)
- International student fee:
- $1,264.00 (AUD)
Description
This unit extends the basic information technology skills gained in CIS13 to the development of a simple automated personal database update and retrieval system to solve a problem. This unit provides an understanding of the development and management of relational databases with emphasis on data modelling and conceptual database knowledge. The student acquires the foundation knowledge necessary to evaluate database management systems. Within this framework data information and corporate knowledge are distinguished. Highlighted are the importance of database security and recovery and the integral role of the Database Administrator (DBA). Advanced database concepts are explored, covering Distributed Database Management Systems (DDBMS), Object-Oriented DBMS and databases in electronic commerce.
Please note: Assessment values are indicative only; details will be advised at the start of the unit.
Prerequisites
Mandatory prerequisites
You must have successfully completed the following unit(s) before starting this unit:
If you have completed equivalent study at another university, please contact a Student Advisor for advice.
Assessment
- Assignment 1 — (20%-30%)
- Assignment 2 — (20%-30%)
- Invigilated Exam — (40%-50%)
- Online assessment — (10%-20%)
Learning Outcomes
At the completion of this unit students will be able to:
- understand the basic goals and functions of databases, their applications and social impact
- describe and give examples of relational database model concepts, eg. primary key, relational database, referential integrity, etc
- develop a working relational database using a specified DBMS tool
- understand the basics of query languages and how to manipulate and manage a database using SQL
- understand and use entity relationship analysis to develop E-R diagrams
- understand the concept of normalisation and be able to normalise tables to 3rd normal form
- explain the role of database administration
- demonstrate an understanding of database security, transaction failure and recovery
- understand and describe distributed database management systems (DDBMS)
- understand and describe data warehouses
- describe the features of object-oriented DBMS.
Topics
This unit addresses the following topics.
| Number | Topic |
|---|---|
| 1 | Abstraction and modelling |
| 2 | Entity-relationship modelling: entity types, relationship types and attribute types |
| 3 | The relational data model |
| 4 | Structured query language |
| 5 | Concurrency control |
| 6 | Database recovery and transaction management |
| 7 | Database design, implementation, management |
| 8 | Developments in database management systems |
Study Resources
This unit is delivered using the following methods and materials:
Print based materials
- Welcome Letter
Online materials
- Printable format materials
Textbooks are subject to change within the academic year. Students are advised to purchase their books no earlier than one to two months before the start of a unit.
Click on the titles of the listed books below to find out more:
Required textbooks
Recommended textbooks
Database Systems Design Implementation Management
By:Coronel Carlos
ISBN: -
Format:Print
Supplier:Go to Unibooks
Relevant Courses
This unit is a core requirement in the following courses:
- Bachelor of Technology (Information Systems), Swinburne University of Tnlgy
- Bachelor of Arts (Internet Communications), Curtin University
This unit is part of a major, minor, stream or specialisation in the following courses:
This unit is an approved elective in the following courses:
This unit may be eligible for credit towards other courses:
- Many undergraduate courses on offer through OUA include 'open elective' where any OUA unit can be credited to the course. You need to check the Award Requirements on the course page for the number of allowed open electives and any level limitations.
- In other cases, the content of this unit might be relevant to a course on offer through OUA or elsewhere. In order to receive credit for this unit in the course you will need to supply the provider institution with a copy of the Unit Profile in the approved format, which you can download here. Note that the Unit Profile is set at the start of the year, and if textbooks change this may not match the Unibooks textbook list.
If you would like to study this unit and enrol today, add it to your Study Cart. Alternatively if you are still exploring your options, you can save this unit to review later by clicking Save to Wishlist.
Let's talk
Have a question? Give us a call.
