INFT2040
Database Management Systems
10 Units
Available in 2013
| Callaghan Campus | Semester 1 |
|---|---|
| Ourimbah | Semester 1 |
| UoN Singapore | Trimester 1, Trimester 3 |
Previously offered in 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004
Provides students with theoretical knowledge and practical skills in the use of databases and database management systems in information technology applications. The logical design, physical design and implementation of relational databases are covered.
| Objectives | On completion of this course students will have the ability to: 1. Understand and evaluate the role of database management systems in information technology applications within organisations; 2. Recognise and use contemporary logical design methods and tools for databases; 3. Derive a physical design for a database from its logical design; 4. Implement a database solution to an information technology problem; 5. Understand the SQL data definition and SQL query languages; 6. Utilise modern ‘windows’ based virtual interfaces to generate complex SQL statements; 7. Develop sophisticated queries to extract information from large datasets. |
||||||
|---|---|---|---|---|---|---|---|
| Content | Topics will generally include: 1. The role of databases and database management systems. 2. Algebra and the relational database. 3. Logical design of databases. 4. Physical design of databases. 5. The SQL Data Definition (DDL) and Data Manipulation (DML) language. |
||||||
| Replacing Course(s) | N/A | ||||||
| Transition | N/A | ||||||
| Industrial Experience | 0 | ||||||
| Assumed Knowledge | SENG1110 or INFT1004 or INFT1001 or equivalent. | ||||||
| Modes of Delivery | Internal Mode | ||||||
| Teaching Methods | Lecture
Computer Lab |
||||||
| Assessment Items |
|
||||||
| Contact Hours | Computer Lab: for 2 hour(s) per Week for Full Term Lecture: for 2 hour(s) per Week for Full Term |
||||||
| Timetables | 2013 Course Timetables for INFT2040 |