COMP6240 Relational Databases

COMP6240 is only available under certain award programs.

Offered By	School of Computer Science
Academic Career	Graduate Coursework
Course Subject	Computer Science
Offered in	Second Semester, 2010 and Second Semester, 2011
Unit Value	6 units
Course Description	Introduction to the basic goals, functions, models, components, applications and social impact of database systems applications. The course introduces the relational model and the database query language SQL. Entity-Relationship Diagrams are introduced as a tool for conceptual modelling. Consideration is given to the role of integrity constraints as well as to the impact of DBMS access schemes and query optimisation.
Learning Outcomes	Upon completion of this course, the student will be able to do the following. Describe the features of the relational data model and understand the relevance of the model to database systems. Describe the reasons for normalisation; analyse given relations for normal form; design normalysed relations. Use a database maniplation language (SQL) Use a database definition language (SQL) Appreciate integrity and security issues for database systems Implement a small database having regard to integrity and security requirements.
Indicative Assessment	Continuous Assessment (30%); Mid Semester Exam (20%); Final Exam (50%)
Workload	Thirty one-hour lectures and six two-hour tutorial/laboratory sessions
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	Information Technology
Prescribed Texts	Elmasri & Navathe Fundamentals of Database Systems, 5th edition, Addison-Wesley, 2007. (Fourth edition is OK, and earlier ones too.)
Programs	Graduate Certificate in Business Information Management and Master of Information Systems Studies

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