COIT11237 - Database Design & Implementation
Term 2 - 2017


All details in this unit profile for COIT11237 have been officially approved by CQUniversity and represent a learning partnership between the University and you (our student). The information will not be changed unless absolutely necessary and any change will be clearly indicated by an approved correction included in the profile.

Overview

Relational databases are pervasive in the current society of information technology; designing and building these databases is a challenging and rewarding occupation. This unit introduces the student to data modelling, relational database theory and normalisation - essential skills for the design and implementation of relational databases. The problems associated with poorly designed and implemented databases are demonstrated. The important database language SQL is covered in sufficient depth to allow the student to appreciate its potential and limitations. Other topics covered in this unit include multi-user database processing and other front-end applications. During the unit, the student will design and implement a small database application. The unit aims to give the student the solid theoretical foundation so essential for working in the field of database design, while also providing an opportunity to apply the theory through the assignment work. **STUDENTS WHO ARE CURRENTLY ENROLLED IN OR WHO HAVE PREVIOUSLY COMPLETED COIT12167 DATABASE USE AND DESIGN CANNOT ENROL IN THIS UNIT.**

Details

Career Level Undergraduate
Unit Level Level 1
Credit Points 6
Student Contribution Band 2
Fraction of Full-Time Student Load 0.125

Pre-requisites or Co-requisites

Pre-requisite COIT11226 System Analysis

Note:- Students who are currently enrolled in or who have previously completed COIT12167 Database Use and Design cannot enrol in this unit.

Attendance Requirements

All on-campus students are expected to attend scheduled classes – in some units, these classes are identified as a mandatory (pass/fail) component and attendance is compulsory. International students, on a student visa, must maintain a full time study load and meet both attendance and academic progress requirements in each study period (satisfactory attendance for International students is defined as maintaining at least an 80% attendance record).

Offerings

Term 2 - 2017
  • Adelaide
  • Brisbane
  • Cairns
  • Distance
  • Melbourne
  • Rockhampton
  • Sydney
  • Townsville

Website

This unit has a website, within the Moodle system, which is available two weeks before the start of term. It is important that you visit your Moodle site throughout the term. Go to Moodle

Recommended Student Time Commitment

Each 6-credit Undergraduate unit at CQUniversity requires an overall time commitment of an average of 12.5 hours of study per week, making a total of 150 hours for the unit.

Class Timetable

Assessment Overview

Assessment Task Weighting
1. Practical and Written Assessment 30%
2. Practical and Written Assessment 30%
3. Examination 40%

This is a graded unit: your overall grade will be calculated from the marks or grades for each assessment task, based on the relative weightings shown in the table above. You must obtain an overall mark for the unit of at least 50%, or an overall grade of ‘pass’ in order to pass the unit. If any ‘pass/fail’ tasks are shown in the table above they must also be completed successfully (‘pass’ grade). You must also meet any minimum mark requirements specified for a particular assessment task, as detailed in the ‘assessment task’ section (note that in some instances, the minimum mark for a task may be greater than 50%). Consult the University’s Grades and Results Procedures for more details of interim results and final grades.

All University policies are available on the IMPortal.

You may wish to view these policies:

  • Grades and Results Procedure
  • Assessment Policy and Procedure (Higher Education Coursework)
  • Review of Grade Procedure
  • Academic Misconduct Procedure
  • Monitoring Academic Progress (MAP) Policy and Procedure – Domestic Students
  • Monitoring Academic Progress (MAP) Policy and Procedure – International Students
  • Refund and Excess Payments (Credit Balances) Policy and Procedure
  • Student Feedback – Compliments and Complaints Policy and Procedure
  • Acceptable Use of Information and Communications Technology Facilities and Devices Policy and Procedure

This list is not an exhaustive list of all University policies. The full list of University policies are available on the IMPortal.

Feedback, Recommendations and Responses

Every unit is reviewed for enhancement each year. At the most recent review, the following staff and student feedback items were identified and recommendations were made.

Feedback Source Recommendation
Assessments need to show very clear requirements in order to avoid confusions in students, and frequent enquiries from students. Student evaluation feedback, student emails, and forum messages Careful review and more attention to details will take place in future development of the database files and assessment specification documents before release.
Students suggested to have the assessments progressively returned to each of the campuses on different dates, but not held back for release on a same later date. It is because students believed that timely feedback of a previous assessment will help improve the work in a subsequent assessment. Student evaluation feedback, student emails, forum messages and phone calls. The following solution will be implemented. To enable all students to receive the assessment 1 results and assessment 1 solution early enough to effectively start work on assessment 2 , any students who submits assessment 1 two weeks after the due date will be straight away awarded a ZERO mark as in the unit profile.
On successful completion of this unit, you will be able to:
  1. Differentiate database applications, systems, and their role in supporting business processes.
  2. Demonstrate competency in using Structured Query Language
  3. Design models using a specified data modelling approach.
  4. Create Relational Models
  5. Normalise tables using concepts relating to functional dependancy.
  6. Identify database implementation issues.

The aim of this unit is to provide the student with an understanding of database theory, technology, the database environment, and the role of database applications in support of enterprise. The focus is the use and design of databases using contemporary technology—relational database technology and SQL. An introduction is provided to database implementation issues and emerging database technology.

Australian Computer Society (ACS) recognises the Skills Framework for the Information Age (SFIA). SFIA is in use in over 100 countries and provides a widely used and consistent definition of ICT skills. SFIA is increasingly being used when developing job descriptions and role profiles.

ACS members can use the tool MySFIA to build a skills profile at https://www.acs.org.au/professionalrecognition/mysfia-b2c.html

This unit contributes to the following workplace skills as defined by SFIA. The SFIA code is included:

  • Database Repository Design (DBDS)
  • Program ming/Software Development (PROG)
  • Database Administration (DBAD)

Alignment of Assessment Tasks to Learning Outcomes

Assessment Tasks Learning Outcomes
1 2 3 4 5 6
1 - Practical and Written Assessment        
2 - Practical and Written Assessment    
3 - Examination

Alignment of Graduate Attributes to Learning Outcomes

  • Introductory Level
  • Intermediate Level
  • Graduate Level
Graduate Attributes Learning Outcomes
1 2 3 4 5 6
1. Communication
2. Problem Solving
3. Critical Thinking
4. Information Literacy            
5. Team Work            
6. Information Technology Competence
7. Cross Cultural Competence            
8. Ethical practice

Alignment of Assessment Tasks to Graduate Attributes

  • Introductory Level
  • Intermediate Level
  • Graduate Level
Assessment Tasks Graduate Attributes
1 2 3 4 5 6 7 8
1 - Practical and Written Assessment      
2 - Practical and Written Assessment      
3 - Examination    

Prescribed Textbooks

Database Concepts
Author/s: David M.Kroenke and David J.Auer Year: 2015
Edition: 7th edition Publisher: Pearson Education
City: Boston
Country: USA
View textbooks at the CQUniversity Bookshop
Note:

An ebook version is available directly through Pearson. However, if you prefer a paper copy you can purchase a copy through the CQUni Bookshop here: http://bookshop.cqu.edu.au

IT Resources

You will need access to the following IT resources:
  • CQUniversity Student Email
  • Internet
  • Unit Website (Moodle)
  • Microsoft Access
All submissions for this unit must use the Harvard (author-date) referencing style (details can be obtained here). For further information, see the Assessment Tasks below.
Unit CoordinatorUmapathy Venugopal - uvenu (u.venugopal@cqu.edu.au)
Note: Check the Term-Specific section for any additional contact information provided by the teaching team
Week Begin Date Module/Topic Chapter Events and Submissions
Week 1 10-07-2017

Introduction to Databases

Chapter-1

Week 2 17-07-2017

Structured Query Language (SQL)

Chapter-3

Week 3 24-07-2017

Structured Query Language (SQL)

Chapter-3

Week 4 31-07-2017

Database application forms and reports

Chapter-1 & supplementary materials

Week 5 07-08-2017

Entity-Relationship model

Chapter-4

Assignment-1 SQL queries, forms and reports Due Friday (11 Aug 17) 11:45 PM AEST
Vacation Week 14-08-2017
Week 6 21-08-2017

Entity-Relationship model

Chapter-4

Week 7 28-08-2017

Relational model and Normalization

Chapter-2

Week 8 04-09-2017

Database Design

Chapter-5

Week 9 11-09-2017

Database Administration

Chapter-6

Week 10 18-09-2017

Database Administration

Chapter-6

Assignment-2 Database design and implementation Due Friday (22 Sep 17) 11:45 PM AEST
Week 11 25-09-2017

Big Data, Data Warehouses and Business Intelligence Systems

Chapter-8

Week 12 02-10-2017

Revision

Review/Exam Week 09-10-2017
Exam Week 16-10-2017

Unit coordinator: Umapathy Venugopal

Email: u.venugopal@cqu.edu.au

Phone: (02) 93245789

1 Practical and Written Assessment

Assessment Title Assignment-1 SQL queries, forms and reports
Task Description

Assignment -1 consists of the following types of database related activities:

  • writing SQL queries to perform various processing and to retrieve data from the given database
  • developing forms and reports relevant to the given database


For further information, please refer to the assignment specification and marking guide / criteria available on the Moodle Website.

Assessment Due Date Week 5 Friday (11-Aug-2017) 11:45 PM AEST
Return Date to Students Within 2 weeks from the due date or within 2 weeks of submission (whichever is later).
Weighting 30%
Assessment Criteria

Assessment criteria will be included in the assignment specification.

Referencing Style Harvard (author-date)
Submission Online

Hard copy submissions are not allowed for this unit.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

1. Differentiate database applications, systems, and their role in supporting business processes.

2. Demonstrate competency in using Structured Query Language

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

1. Communication

2. Problem Solving

3. Critical Thinking

6. Information Technology Competence

8. Ethical practice



2 Practical and Written Assessment

Assessment Title Assignment-2 Database design and implementation
Task Description

Assignment-2 consists of the following database related activities:

  • designing a database to satisfy the requirements of one or more case studies
  • developing conceptual data model diagram
  • performing logical design and physical design
  • implementing the database

For further information, please refer to the assignment specification and marking guide/criteria available on the Moodle Website.

Assessment Due Date Week 10 Friday (22-Sep-2017) 11:45 PM AEST
Return Date to Students Within 2 weeks from the due date or within 2 weeks of submission (whichever is later).
Weighting 30%
Assessment Criteria

Assessment criteria will be included in the assignment specification.

Referencing Style Harvard (author-date)
Submission Online

Hard copy submissions are not allowed.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

3. Design models using a specified data modelling approach.

4. Create Relational Models

5. Normalise tables using concepts relating to functional dependancy.

6. Identify database implementation issues.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

1. Communication

2. Problem Solving

3. Critical Thinking

6. Information Technology Competence

8. Ethical practice



Examination

Outline Complete an examination
Date During the University examination period
Weighting 40%
Condition Minimum percentage of examination marks required to pass course - Minimum 50% in the examination and overall 50%.
Length 120 minutes
Details Dictionary - non-electronic, concise, direct translation only (dictionary must not contain any notes or comments).
No Calculators Permitted
Closed Book
Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

1. Differentiate database applications, systems, and their role in supporting business processes.

2. Demonstrate competency in using Structured Query Language

3. Design models using a specified data modelling approach.

4. Create Relational Models

5. Normalise tables using concepts relating to functional dependancy.

6. Identify database implementation issues.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

1. Communication

2. Problem Solving

3. Critical Thinking

4. Information Literacy

6. Information Technology Competence

8. Ethical practice


© 2017 CQUniversity
Page generated by apps-prod-01.cqu.edu.au at Thu Jun 29 19:05:21 AEST 2017