An examination of the issues required to design and maintain large and complex databases is important for those who wish to pursue a career as a database administrator, data architect or research advanced issues in the database area. Knowledge of physical file structures,their relationship to transaction loadings and to design decisons are vital. Issues of integrity, security,concurrency and recovery/backup are key areas of knowledge for those working in or researching database management.

2005: Existing unit CSE3000 Database Design and Implementation being updated to fit into the new BITS degree structure with new FIT unit code.

FIT2041 Database Design and Administration is an elective 2nd level unit in the Caulfied BITS major in Systems Development.

There is no comparable unit in the faculty.

Students undertaking a Systems Development major need an advanced understanding of database design and administration issues.

On the successful completion of this subject students will be able to:

• understand client/server database management;
• understand query optimisation and its impact on programming;
• understand the database management systems recovery, concurrency, security, benchmarking, performance measurement and transaction management mechanisms;
• understand the database management systems use of procedural features for ensuring data integrity;
• understand Oracle DBMS architecture and database management issues;
• understand database trends and current research directions in database management.

On the successful completion of this subject students will be able to:

• use a procedural programming language to access a relational database system

ASCED Discipline Group classification: 020303 Database management

This unit looks at the design and implementation issues of database management systems. Record, file and index structures are dealt with at the basic level. Higher level details of consistency, atomicity and durability are introduced along with modern trends in databases

This unit looks at the design and implementation issues of database management systems. Record, file and index structures are dealt with at the basic level. Higher level details of consistency, atomicity and durability are introduced along with modern trends in databases.

• Database Systems- An Application-Oriented Approach 2nd Ed., Addison-Wesley 2006
• Database Systems, Connolly and Begg 3rd edition, Addison-Wesley.
• Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke 2nd edition, McGraw-Hill
• Databases Illuminated, Ricardo C.M.,Elsevier Australia 2004

On campus

• Lectures
• Tutorials
• Laboratory
• Homework Assignments
• Midterm test
• Final exam

Knowledge and understanding objectives are achieved mainly through lectures and tutorial exercises.

Attitudes and beliefs objectives are achieved mainly through laboratory exercises and assignment work.

Practical skills objectives are achieved mainly through laboratory exercises and assignment work.

Relationships, communication and team work objectives are achieved mainly through laboratory exercises and assignment work.

Examination (2 hours) 50%: Assignment Work 50%

Knowledge and understanding objectives are assessed mainly through the examination.

Attitudes, values and belief objectives are assessed mainly through the examination and assignment work.

Practical skills objectives are assessed mainly through assignment work.

Relationships, communication and team work objectives are assessed mainly through assignment work.

12 hours per week including lectures, laboratory sessions and private study.

High-tech lecture theatre with data display and internet connection, with a PC and facility to plug in a laptop, for two hours per week throughout the semester.

A laboratory with access to UNIX machine

One lecturer per semester. One tutor per laboratory session per semester.

Adequate copies of at least the recommended texts listed above.

FIT

Nil

Nil

Nil

Nil

FIT1004 or CSE2132 or equivalent