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 CSCI235
Subject Name Database Systems
Credit Points 6
Pre-Requisites CSIT115
Co-Requisites None.
Restrictions None.
Equivalence None.
Assessment 1.Assignments- 30% 2. Laboratory tasks - 10% 3. Final examination- 60%
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
Course
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 SIM Session 1  (03-01-2017 to 09-03-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 16-01-2017

Subject Availability
Session Autumn  (27-02-2017 to 22-06-2017)
Campus Wollongong
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours 3 hrs Lecture + 2hrs lab
Lecturer(s) and
Cons. times
Tianbing Xia
Coordinator(s) and
Cons. times
Tianbing Xia
Instance Comment  
Census Date 31-03-2017

Subject Availability
Session INTI Subang Jaya Session 1  (06-03-2017 to 12-07-2017)
Campus INTI Subang Jaya
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours  
Lecturer(s) and
Cons. times
Jane See Yin Lim
Seah Kuan Sow
Coordinator(s) and
Cons. times
Mark Freeman
Tianbing Xia
Vincent Loh
Instance Comment  
Census Date 31-03-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 Availability
Session SIM Session 3  (01-07-2017 to 07-09-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-07-2017

Subject Availability
Session Spring  (24-07-2017 to 16-11-2017)
Campus Wollongong
Delivery Method On Campus
Instance Name Class 1
Course Restrictions No restrictions
Contact Hours 3 hrs Lecture + 2hrs lab
Lecturer(s) and
Cons. times
Janusz Getta
Tianbing Xia
Coordinator(s) and
Cons. times
Janusz Getta
Tianbing Xia
Instance Comment  
Census Date 31-08-2017

Subject Availability
Session DXB UG Autumn  (17-09-2017 to 15-01-2018)
Campus Dubai
Delivery Method On Campus
Instance Name Class 1
Quota 60
Course Restrictions No restrictions
Contact Hours  
Lecturer(s) and
Cons. times
Farhad Oroumchian
Coordinator(s) and
Cons. times
Jun Shen
Instance Comment  
Census Date 11-10-2017

Subject Availability
Session SIM Session 4  (02-10-2017 to 30-11-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 13-10-2017

Subject Description
The subject presents more advanced topics in the modern relational database technology and it introduces the new non-relational (NoSQL) database technologies. The relational database technology component of the subject includes database design with meta modelling and spatio-temporal modelling, database normalization, advanced programming in SQL and programming of database server with stored PL/SQL procedures, functions, and triggers, concurrency control and database recovery techniques, design and programming of distributed database systems. The non-relational (NoSQL) database technology component of the subject includes the key-value data model, document-oriented model, column-family stores, graph data model, and new approaches to data distribution, consistency preserving, and transaction processing.


Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Design and create extendable and spatio-temporal relational databases using advanced conceptual modelling techniques
2. Adapt a theory of relational database normalization to prove the correctness of relational database designs
3. Design and create stored procedures, stored functions and database triggers in advanced SQL and in PL/SQL
4. Design and create effective database transaction based on the principles of transaction processing and theory of concurrency in database systems
5. Summarise the principles of distributed database systems, design and create distributed relational databases
6. Summarise the principles of modern non-relational (NoSQL) database technologies, design and create key-value and document oriented database systems
7. Adapt the principles of distributed and clustered computing systems to design and to create more effective database applications


Textbook Information

Text book information is available via the UniShop website:



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