INFS7003 Databases and Information Systems

Offered By	School of Accounting & Business Info Systems
Academic Career	Graduate Coursework
Course Subject	Information Systems
Offered in	First Semester, 2011 and First Semester, 2012
Unit Value	6 units
Course Description	This course focuses on relational database systems and their use in information systems development. It aims to present the foundations of the relational database model, the principles of relational database modelling and design, query languages, and the basics of database application development using a representative database management software package. It also aims to introduce students to more advanced database or database-related technologies including object-oriented databases, hybrid systems and Web-enabled database systems.
Learning Outcomes	On completion of this course you are expected to have achieved: A sound understanding of the basic concepts and theoretical underpinnings of modern relational database systems. Competence in data modelling using the entity-relationship modelling technique as well as translating completed data models in correctly normalized relational database designs. The ability to write correct queries in the standard SQL database query language and also to use a typical graphical query language interface competently. An appreciation of the issues involved in physical database design as well as database security and performance. An understanding of selected advanced database-related topics.
Indicative Assessment	Case Study Review, Critiques, and In-Class Presentation (Individual) – 20% In-Class Discussion and Debate – 10% Assignment 1 – Case Study (Individual) – 30% Assignment 2 – Project (Group) – 40% Total 100%
Workload	Teaching for this course is likely to be in the format of one 3 hour seminar per week; however, enrolment numbers may dictate that it be run differently. You should aim to spend at least twice as much time in private study per week as there are actual contact hours (i.e. lectures and tutorials/laboratory classes) for the course.
Course Classification(s)	TransitionalTransitional courses are designed for students from a broad range of backgrounds and learning achievements, which provide for the acquisition of generic skills; or an informed understanding of contemporary issues; or fundamental knowledge for transition to Advanced or Specialist courses.
Areas of Interest	Business Information Systems
Eligibility	At least an average of 65% (or equivalent) in the final two years of an Australian undergraduate degree
Assumed Knowledge and Required Skills	It will be assumed that students have undertaken a first year course in information systems and are familiar with computerised systems in general as well as the use of the Windows PC operating system and standard office automation software.
Requisite Statement	There are no specified prerequisites for this course.
Prescribed Texts	See Course Website: http://ecocomm.anu.edu.au/courses/course.asp?code=INFS7003
Preliminary Reading	See Course Website: http://ecocomm.anu.edu.au/courses/course.asp?code=INFS7003
Indicative Reading List	See Course Website: http://ecocomm.anu.edu.au/courses/course.asp?code=INFS7003
Programs	Graduate Certificate in Business Information Management, Graduate Certificate in Business Information Management, Master of Business, Master of Business Information Systems, Master of Commerce, Master of Business, Master of Commerce, Master of Information Systems Studies, Master of Information Systems Studies, and Master of Business Information Systems
Other Information	For further information please refer to http://ecocomm.anu.edu.au/courses/course.asp?code=INFS7003
Academic Contact	See http://ecocomm.anu.edu.au/courses/course.asp?code=INFS7003

The information published on the Study at ANU 2011 website applies to the 2011 academic year only. All information provided on this website replaces the information contained in the Study at ANU 2010 website.