Future Students - Courses

Database Programming

Unit Code: HIT8304

Duration	Contact Hours	Campus	Prerequisite	Corequisite
1 Semester or equivalent	48 hours	Hawthorn	HIT6402 Database Analysis and Design AND at least one of the following: - 65% in HIT6037 Software Development in Java, or - HIT6302 Object-Oriented Programming, or - HIT7037 Programming in Java

Duration

Contact Hours

Campus

Prerequisite

Corequisite

1 Semester or equivalent

48 hours

Hawthorn

HIT6402 Database Analysis and Design AND at least one of the following:
- 65% in HIT6037 Software Development in Java, or

- HIT6302 Object-Oriented Programming, or

- HIT7037 Programming in Java

Credit Points: 12.5 Credit Points

Related Course/s:

A unit of study in the Master of Information Technology, Master of Information Technology (Professional Computing) and Master of Technology (Information Technology).

Aims & Objectives:

Learning Outcomes
At the completion of this unit, students should be able to:

produce a component based design to address the problem, expressed using diagrams and text on a given problem description for a database application
implement a solution for a given component based design expressed in diagrams and text,using the subject's programming languages
compare and evaluate different component based designs from multiple perspectives, including: Client perspectives. Architectural issues. Implementation issues
implement event driven graphical user interfaces for web and rich clients
implement authentication schemes for web and rich client database applications
identify and describe potential security issues and suggest mechanisms to ensure the safety of the application and its data for agiven architectural diagram and description for a two tier database application
develop database applications that are used by multiple concurrent users
Design a simple two-tier architecture with a web and/or rich client application that addresses a problem description for a multi-user database program, Configure the solution components to ensure that the system runs smoothly. Setup and store information in a database. Implement the solution using the subject's programming languages
work cooperatively in small teams to develop software solutions
use tools to help them build software cooperatively, including: Automated build environments. Automatic unit testing of source code in nightly builds. Concurrent versioning source code repositories. Task allocation and bug tracking software

Teaching Methods:

Lecture (24 hrs), Tutorial (labs) (24 hrs)

Assessment:

Assignments, Tests, Examination

Generic Skills Outcomes:

Students will be provided with feedback on their progress in attaining the following generic skills:
· problem solving skills
· communications skills

Content:

Two tier applications: Processes and security contexts. Communication technologies. Database programming. Program to database interaction with SQL and stored procedures. Concurrency, transactions and managing concurrent access to the database.
Application programming: Developing web applications. Developing rich client applications. Rendering information from the database.
Security: Authentication and Authorization. Database security and roles

References:

Templeman, et.al., Fast Track C#, Peer Information Inc., 2002.

Drayton, Albahari & Neward, C# Language Pocket Reference, O'Reilly, 2002.

Mojica, C# & VB.NET Conversion Pocket Reference, O'Reilly, 2002.

Thomsen, Database Programming with C#, APress, 2002.

MSDN, http://msdn.microsoft.com