INFS 2009 Database Design and Development (UG Cert)
Credit Points 10
Description The main purpose of this unit is to provide students with an opportunity to gain a basic knowledge of database design and development including data modeling methods, techniques for database design using a set of business rules that are derived from a case study and finally implementation of the database using a commercial relational database management system. The unit also examines a number of important database concepts such as database administration, concurrency, backup and recovery and security.
School Computer, Data & Math Sciences
Student Contribution Band HECS Band 2 10cp
Check your HECS Band contribution amount via the Fees page.
Level Undergraduate Level 2 subject
Restrictions Students need to be enrolled in 7174 ? Undergraduate certificate of ICT
Basic programming skills, including variable declaration, variable assignment, selection statement and loop structure.
- Describe components of a database system, advantages and disadvantages of a database system, roles people play and the historical development of a database system in the context of a Relational Database Management System (RDBMS)
- Apply basic skills in database modelling, including ER diagrams and normalisation in RDBMS
- Explain the basic concepts of relational algebra and apply them in queries
- Describe the general concepts of transaction management
- Identify concepts in database administration
- Describe concepts in database security and backup
- Define and manipulate data using structured query language (SQL)
- Design and develop a database for a business application using a commercial database management system
2.Concepts in data modelling
3.Integration of data and data independence
4.Translating a case study into relational concepts and integrity constraints
5.Introduction to relational algebra/calculus
6.Data modelling: Conceptual, logical and physical database design
7.Data definition and manipulation using SQL
8.Concepts in generalisation and specialisation
9.Anomalies in databases and data normalisation
11.Introduction to database security and encryption
12.Introduction to transaction management, concurrency and locking.
The following table summarises the standard assessment tasks for this subject. Please note this is a guide only. Assessment tasks are regularly updated, where there is a difference your Learning Guide takes precedence.
|Portfolio-A Portfolio-B||Portfolio-A 500 words (1,2) 15% Portfolio-B 600 words (3-7) 20%||35||N||Individual|
|Applied Project||1200 words||40||N||Individual|
|Presentation||5 - 10 minutes||25%||N||Individual|