Database Analysis and Design

Unit Code: HIT6402

Credit Points: 12.5 Credit Points

> Related Course/s
> Teaching Methods
> Assessment
> Aims & Objectives
> Content
> References

Related Course/s:

A unit of study in the Graduate Certificate of Information Technology, Graduate Diploma of Information Technology, Master of Information Technology, Master of Technology (Information Technology), Master of Information Technology Business Analysis, Graduate Diploma of Information Technology Business Analysis, Graduate Certificate of Information Technology Business Analysis. An elective unit of study in the Graduate Diploma of Multimedia, Master of Multimedia, Master of Multimedia Technology and Master of Multimedia (Honours).

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 and business rules
• DBMS terminology and concepts
• The relational data model
• Structured Query Language
• Entity relational analysis
• Normalisation of data
• Data integrity
• Data warehousing

References:

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