The aim of this module is to: - Provide learners with a basic grounding in relational database technology. - Provide learners with a knowledge of good database design. - Provide learners with a knowledge of the basic functions of a DBMS, transaction processing and SQL query processing.
Database Architecture
Introduction to Database Management Systems; Three tier architecture, database objects and the processes that manage them; Client/Server; Distributed Databases, Data warehouse.
Relational DB Management
Entity-Relationship modelling, The Relational Model, Normalisation
Database tools
Using Form and Report generation tools
Introduction to Database Administration
(Using a multi-user database such as: DB2, Oracle or Microsoft SQL Server);Role of a database administrator; Evaluating database products with respect to pricing, features, licensing issues; DB start up and shut down; Managing DB users. DB control and privileges
SQL Language
Data definition: CREATE, ALTER, DROP, TABLE and VIEW; data types; Data manipulation: SELECT, INSERT, UPDATE, DELETE; expressions; Select clauses – JOIN, WHERE, GROUPBY, HAVING, ORDERBY; subquery; functions; set operators.Enforcing business rules: keys, referential integrity, constraints, defaults, auto increment.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 50 |
| Formal Examination | 50 |