Database Concepts - 2018

Unit summary

CPT140

  • Level of Study: Undergraduate Level 1
  • Study load: 0.125 EFTSL
  • Delivery method: Fully Online
  • Prerequisites: Yes
  • Duration: 13 weeks
  • Government loans available: FEE-HELP, HECS-HELP
  • Availability for 2017: SP2 , SP3 , SP4
  • Availability for 2018: SP2 , SP3 , SP4
  • Assessment: Assignment 1 (20%) , Assignment 2 (30%) - Learn more

Unit provided by

or
2018 Fees
AUD$
Domestic 1,169.00
HECS 1,169.00
International 1,419.00
Databases and the database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.
 
This course is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. This course focuses on developing skills in designing databases for efficient data management and SQL programming for querying and using databases for various database applications. 

Upon successful completion of this unit you should be able to:

  1. Describe various data modelling and database system technologies
  2. Explain the main concepts for data modelling and characteristics of database systems
  3. Identify issues with and compare, justify relational database design using the functional dependency concepts
  4. Apply SQL as a programming language to define database schemas and update database contents
  5. Apply SQL as programming language to extract data from databases for specific users’ information needs
  6. Design a database schema using conceptual modeling mechanisms such as entity-relationship diagrams.
  • Assignment 1 (20%)
  • Assignment 2 (30%)
  • Invigilated Exam (50%)
For more information on invigilated exams see Exams and results

Recommended prerequisites

You are recommended to have completed the following unit(s) or have equivalent knowledge before starting this unit:

  • Broadband access — Stable broadband connection required to access online learning materials and live chat sessions / recordings. (note: mobile broadband users may have difficulties participating in live chat sessions) Unrestricted broadband access to enable using SQLDeveloper via the RMIT MyDesktop service is generally expected.

This unit addresses the following topics.

NumberTopic
1Introduction to databases
2Basic relational modelling
3Basic entity-relationship modelling
4Basic SQL programming
5Advanced Relational Modelling
6Relational database design
7Advanced ER modelling
8Advanced SQL programming

This unit is delivered using the following methods and materials:

Instructional Methods

  • Audio/Video conferencing
  • Discussion Forum/Discussion Board
  • Embedded Multimedia
  • Online assignment submission
  • Podcasting/Lecture capture
  • Standard Media
  • Streaming Multimedia
  • Web links

Online materials

  • Audio/Video - Streaming
  • FAQs
  • Printable format materials
  • Resources and Links

This unit is a core requirement in the following courses:

This unit may be eligible for credit towards other courses:

  1. 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.
  2. 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 Co-Op textbook list.

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

There are no required textbooks for this unit.

Enquire online

Need to ask a question that's best put down in words?
Make an online enquiry.

Enquire now

Ready to enrol?

Start studying this unit now.

or

Got a question?

Get an answer from one of our friendly Student Advisors.