1 Semester

48 hours

Hawthorn, Sarawak

Nil

Credit Points: 12.5 Credit Points

Related Course/s:

A unit of study in the Bachelor of Business Information Systems, Bachelor of Business Information Systems/Bachelor of Business, Bachelor of Computing, 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 Computing (Network Design and Security), Bachelor of Multimedia (Multimedia 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) 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 Laboratory (12 hrs) 

Assessment:

Assignment, test, examination.

Generic Skills Outcomes:

The graduate attributes which relate to this unit of study help to produce graduates who:

• Are capable in their chosen professional areas.
• Are adaptable and manage change.
• Operate effectively in work and community situations.
• Are aware of environments.

Content:

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

Reading Materials:

Hoffer, JA, Prescott, MB & McFadden, FR, Modern Database Management, 7th edn, Upper Saddle River, NJ, Prentice-Hall, 2005.
Kroenke, DM, Database Processing: Fundamentals Design and Implementation, 10th edn, Intl. edn, Upper Saddle River, NJ, Prentice-Hall, 2006.
Rob, P & Coronel, C, Database Systems: Design, Implementation and Management, 6th edn, Boston, Thomson, 2004.
Simsion, GC & Witt, GC, Data Modeling Essentials, 3rd edn, San Francisco, Morgan Kaufmann, 2005.
Watson, RT, Data Management: Databases and Organizations, NY, Wiley, 2004.