University home »
Faculty of Science »
Department of Computer Science »
Courses » COMPSCI 280 S1 C »
Computer Science
Enterprise Software Development: COMPSCI 280 Semester 1, City Campus
Course Information
The course information sheet is here. Download it and familiarize yourself with it.
Students will develop a distributed application using an Enterprise technology.
The application will involve a database, and in developing the application, students will demonstrate skills in data modelling, manipulating and querying; and accessing a remote database server.
Students will also learn how to model the system's requirements and design using established notations, to leverage a component based Enterprise technology, and to use tools to support their activities.
By the end of the course students who succeed will be competent C# Programmers.
Time and Venue for Lectures
Top
- Tue 3pm-4pm, PLT1/303-G20
- Wed 3pm-4pm, MLT1/303-G23
- Fri 3pm-4pm, Eng1439/401-439
Schedule
Top
| Week | Tue | Wed | Fri | Note |
|---|---|---|---|---|
| 1 | 1 March: Course intro. DB server, DB tables, CREATE TABLE and SELECT queries | 2 March: Finding records in tables, WHERE clause, keys | 4 March: DELETE, UPDATE, ALTER TABLE, DROP TABLE, design considerations | |
| 2 | 8 March: More complex where clauses, table aliases | 9 March: Working with multiple tables | 11 March: Updating and deleting multiple tables, mapping tables and entity relationships in UML | |
| 3 | 15 March: DB normalisation | 16 March: joins, HAVING clause | 18 March: views, computed fields | Quiz 1 |
| 4 | 22 March: working with constraints | 23 March: dirty reads, transactions, locking | 25 March: functions, stored procedures | Quiz 2 |
| 5 | 29 March: insert and update triggers | 30 March: overflow | 1 April: review, AFD | |
| 6 | 5 April: Intro to C# | 6 April: Data types and operators | 8 April: Classes, objects and methods | A1 due |
-
Related Programmes
