Related Course/s:

A unit of study in the Bachelor of Business Information Systems, Bachelor of Engineering (Robotics and Mechatronics)/ Bachelor of Science (Computer Science and Software Engineering) / Bachelor of Science (Computer Science and Software Engineering), Bachelor of Science (Professional Software Development), Bachelor of Science (Computer Science and Software Engineering), Bachelor of Engineering (Telecommunication and Network Engineering), Bachelor of Engineering (Telecommunication and Network Engineering)/ Bachelor of Science (Computer Science and Software Engineering), Bachelor of Science (Information Technology), Bachelor of Science (Computer Science) and Bachelor of Information Technology

Aims & Objectives:

Students who complete this unit of study should be able to:

• Describe the steps involved in database design and database systems development.
• Explain the fundamentals of the relational data model.
• Write SQL to define, query and manipulate a database.
• Use conceptual data analysis methods to produce and document a logical data model.
• Design and generate a simple inquiry and update system using a range of commercial DBMS tools.

Teaching Methods:

Lecture (24 hrs), Tutorial (12 hrs) and Tutorial (labs) (12 hrs) 

Assessment:

Group Assignment, Individual Assignment, test, examination

Content:

• Information in the organisation.
• DBMS terminology and concepts.
• The relational data model.
• Structured Query Language.
• Entity relational analysis.
• Normalisation of data.
• Data integrity.
• Data warehousing

Reading Materials:

Hoffer, JA, Prescott, MB & McFadden, FR, Modern Database Management, 7th edn, Upper Saddle River, NJ, Prentice-Hall, 2005.

Watson, RT, Data Management: Databases and Organizations, NY, Wiley, 2004.

Connolly T & Begg C (2007)., Database Systems, A Practical Approach…", Sixth Edition,
AddisonWesley.

Rob P. & Coronel C (2008) Database Systems, Eigth Edition, Thomson