ICT200 Database Design and Development

Overview

B IT                             Core

This subject will provide the student with an overall understanding of database development, concepts and theory. Students will learn to design and build a database from data analysis, normalisation, mapping a specific database model. The relational model is emphasised and introduced using structured queried language (SQL) for creating and manipulating databases in both MS Access and SQL Server environments. Assignment work includes the analysis, design, and implementation of a database using SQL queries in SQL Server environment.

Prerequisites

ICT103 Systems Analysis and Design