Course Title: Implementation of Database Applications

Part A: Course Overview

Course Title: Implementation of Database Applications

Credit Points: 12.00


Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

ISYS1101

City Campus

Postgraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 2 2006,
Sem 2 2010,
Sem 2 2011,
Sem 2 2012

ISYS1102

City Campus

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 2 2006,
Sem 2 2010,
Sem 2 2011,
Sem 2 2012

ISYS2034

Bundoora Campus

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2006

ISYS2105

Bundoora Campus

Postgraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2006

Course Coordinator: Audrey Tam

Course Coordinator Phone: +61 3 9925 3202

Course Coordinator Email: audrey.tam@rmit.edu.au


Pre-requisite Courses and Assumed Knowledge and Capabilities

Fundamental knowledge in relational database concepts, including relational modelling & design, relational algebra & SQL, conceptual modelling, and transactions & concurrency, equivalent to ISYS1055/1057 Database Concepts.
Ability to write programs in an object-oriented programming language, equivalent to COSC1295 Java for Programmers OR COSC1076/2207 Programming 2 OR COSC1252/1254 Object Oriented Programming in C++.


Course Description

This course aims to introduce general principles and strategies of developing business database applications using the Visual Studio 2010 development environment, the VB.NET 10.0 (.NET Framework 4.0) programming language, and Microsoft SQL Server 2008. The course aims at learning design and development techniques applicable to most Visual Development Environments rather than concentrating just on product-specific features. The course focusses on latest topics such as: Microsoft’s WPC and WCF frameworks for desktop development.  There will be special emphasis on the database-side where SQL Server 2008 will be covered in-depth along with SQL Azure platform, dynamic and OO databases.


Objectives/Learning Outcomes/Capability Development

Capability Development
This course contributes to the development of the following capabilities: Enabling Knowledge, Problem Solving, and Critical Analysis.


On completion of this course you should have gained a good understanding of developing database applications using visual development environments and develop skills to address implementation issues. Specifically, you should be able to:

  • Design and implement database applications using VB.Net 10.0, MS SQL 2008 server and SQL Azure
  • Optimize underlying database systems
  • Identify and resolve performance issues in database applications.
  • Use Reporting Tools.


Overview of Learning Activities

Syllabus material will be presented, explained and illustrated with demonstrations and examples in lectures, classes, or online. Completion of tutorial questions and laboratory programming exercises and projects, are designed to give further practice in the application of theory and procedures, and to give feedback on your progress and understanding. Private study will consolidate your understanding of the theory and practice.


Overview of Learning Resources

• Students will make extensive use of computer laboratories and relevant software provided by the School.
• Lists of relevant textbooks, reference texts, resources in the Library and relevant internet sites will be provided.


Overview of Assessment

The assessment for this course comprises practical work involving the development of medium-sized database applications and a final exam.

For standard assessment details, including deadlines, weightings, and hurdle requirements relating to Computer Science and IT courses see: http://www.rmit.edu.au/compsci/cgi