Database Analysis and Design
Unit code: HIT6402
|Credit points||12.5 Credit Points|
|Duration||1 Semester or equivalent|
|Contact hours||48 Hours|
Nil. Preclusion: HIT6016 Database 1
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 and 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.
ReferencesHoffer, 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,
Rob P. & Coronel C (2008) Database Systems, Eigth Edition, Thomson