Subject Descriptions - Subject Information

Calendar: 2017 Undergraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology

Subject Information
Subject Code CSCI315
Subject Name Database Design and Implementation
Credit Points 6
Pre-Requisites CSCI235
Co-Requisites None.
Restrictions None.
Equivalence None.
Assessment Assignments 3*10% Class tests 2*10% Final examination 50%
General Subject Yes.
EFTSL (Non Weighted) 0.125
Non Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
Pre-1997 Pre-2005 Post-2005 Post-2008 Post-2009 Post-2010
$ 1131  $ 1131  $ 1131  $ 1131  $ 1131  $ 1131 
Weighted Student Contribution Amounts
Commonwealth Supported (HECS) Students Only
1771-Bachelor of Laws (Honours) (Direct Entry)
1777-Bachelor of Laws (Direct Entry)
1827-Bachelor of International Studies - Bachelor of Laws
1845-Bachelor of Information Technology - Bachelor of Laws
1852-Bachelor of Business Information Systems - Bachelor of Laws
351-Bachelor of Laws (Honours)
760-Bachelor of Communication and Media Studies - Bachelor of Laws
770-Bachelor of Laws (Graduate Entry)
771-Bachelor of Arts - Bachelor of Laws
771H-Bachelor of Arts - Bachelor of Laws
772-Bachelor of Creative Arts - Bachelor of Laws
773-Bachelor of Commerce - Bachelor of Laws
774-Bachelor of Mathematics - Bachelor of Laws
775-Bachelor of Science - Bachelor of Laws
775H-Bachelor of Science - Bachelor of Laws
775M-Course information not Found
779-Bachelor of Engineering - Bachelor of Laws
858-Bachelor of Journalism - Bachelor of Laws
Work Experience No
Tutorial Enrolment Information Students should use the SMP OnLine Tutorial System (via SOLS) to enrol in Tutorial/laboratory groups for this subject. Once enrolments are open a link to the subject will appear in Tutorial Enrolments.

Subject Availability
Session CCCU Semester B  (02-01-2017 to 08-04-2017)
Campus UOW at CCCU HK
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours  
Lecturer(s) and
Cons. times
Coordinator(s) and
Cons. times
Guomin Yang
Janusz Getta
Instance Comment  
Census Date 21-01-2017

Subject Availability
Session SIM Session 2  (01-04-2017 to 08-06-2017)
Campus Singapore Institute of Management
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours  
Lecturer(s) and
Cons. times
Janusz Getta
Coordinator(s) and
Cons. times
Casey Chow
Instance Comment  
Census Date 14-04-2017

Subject Description
This subject investigates the process of relational database design starting from conceptual database design, through logical database design, denormalisation, up to and including physical database design and administration. The topics will include conceptual database design based on Object Modelling Technique, methodologies for conceptual design, view integration, logical database design, database normalisation and de-normalisation, physical database design including persistent storage allocation, indexing, view materialisation, partitioning, and clustering of relational tables.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Design a relational database using Object Modelling Technique in a systematic manner.
2. Prove the correctness and efficiency of the final design using the formal techniques.
3. Carry out cost/benefit analysis of the final design in the terms of physical database design techniques.
4. Implement the design using commercially available database management systems.
5. Carry out the basic functions of database administrator such as user management, access rights management and profiles management.
6. Explain an internal organisation of a sample relational database system.
7. Design indexing schemas and carry out performance evaluation of database indexing techniques.
8. Design materialised view, partitioned relational tables and clustered relational tables.

Textbook Information

Text book information is available via the UniShop website:

Search Criteria [Click here for help]
Subject Code / Name
Delivery Method
General Subjects