Database Concepts - 2017

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
  • Availability for 2016: SP2 , SP3 , SP4
  • Availability for 2017: SP2 , SP3 , SP4
  • Assessment: Assignment 1 (20%) , Assignment 2 (30%) - Learn more

Unit provided by

or
2017 Fees
AUD$
Domestic 1,131.00
International 1,381.00

Databases and 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 unit is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. Topics include: an introduction to relational database systems, the relational database model and entity-relationship model, SQL (Structured Query Language), relational design, and advanced topics such as the enhanced entity-relationship model, object-oriented model, and SQL in web-based applications.

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

  1. explain the fundamentals of database modeling and design, and implementation of a simple database application
  2. apply fundamental database concepts including analysing, designing, defining, constructing and manipulating relational database systems
  3. model data as relations
  4. use SQL as a data definition language and as a data manipulation language and formulate queries for specific users’ information needs
  5. define views and formulate queries on views
  6. use functional dependency concepts in relational database design and derive well-designed database schemas
  7. use conceptual modeling mechanisms such as entity-relationship diagrams to design a database schema
  8. design and implement database solutions for various application areas and to build queries for users’ needs, based on analysis of data modeling problem specifications
  9. analyse data modeling problem specifications and derive alternative conceptual models that represent the problem in different perspectives leading to alternative database designs.
  • 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

This unit addresses the following topics.

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

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.

Textbook information for this unit is currently being updated and will be available soon. Please check back regularly for updates. Alternatively, visit the The Co-op website and enter the unit details to search for available textbooks.

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.