SBCS Ltd approved single module course: Database Design and Implementation
This course is available to anyone wanting to have a foundation in Database Design & Implementation as defined in the “Entry Requirements” below. Students will be assessed and issued a certificate by the School of Business and Computer Science. This qualification can be earned in six (6) months part-time.
Aims and Objectives
- To explain the need for a database system and its role in a business and other types of organisation.
- To provide a detailed understanding of the principles of database processing.
- To enable students to acquire and apply skills and techniques for the design and implementation of database using a suitable relational database package.
- To discuss future DB applications and their requirements.
By the end of the course students will be able to:
- A: Develop a sound understanding and knowledge of database technology, its importance, its architectures, user's roles, and the central role that database technology plays in information systems.
- B: Critically evaluate various database design options at conceptual, logical and implementation levels.
- C: Evaluate various file organisation methods, distribution strategies, concurrency mechanisms, query optimisation techniques, and database recovery and security procedures.
- D: Critically examine and reflect on the theoretical aspect of the process of normalisation and its practical implementation.
- E: Evaluate and use various modern database management systems tools in building a small but realistic database system.
- F: Describe advances in trends and emerging standards in database technology; understand the comparative features and crucial aspects of data and knowledge management technology and the impact of the Internet on database technology.
- Database Architecture and Environment: Three-level schema architecture; Data Independence; Database languages and interfaces; The differences between Conceptual, Logical and Physical data models; Functions of a DBMS; Data and Database Administration.
- Conceptual Database Modelling: Entity-Relationship Model concepts; Problems with ER Models; The Enhanced Entity-Relationship Model and various notations.
- Relational Database Design: Representing Data Model; Mapping EERD into a Relational Schema; Functional Dependency and Normalisation
- The Relational Database Languages: Relational Algebra; Relational calculus; Structured Query Language; Relational DB Application Development tools.
- Database Administration: Physical DB organisation; Transaction Management and Concurrency Control; Database Recovery; Database Security; Query Evaluation, Processing and Optimisation.
- Distributed Databases: Client/ Database Server Architecture; Homogeneous, Heterogeneous and Federated Distributed Database Management Systems; Schema Architecture for Distributed DBMS; Design Issues: Data Fragmentation, Allocation and Replication;
- Object-Oriented Databases: Object Modelling Concepts and Object-Oriented DBMSs: Weaknesses of Relational DBMSs; Architecture of OODBMS; The OODBS manifesto; Object-Relational Database management system; Comparison of ORDBMS and OODBMS; The ODMG Standards; SQL extensions.
- Advances in Databases: Data Warehousing; OLAP vs. OLTP; Multidimensional Modelling; Data Mining techniques and knowledge discovery; Database and the Internet Technology; Web enabled Databases and XML technology.
In order to register, you must first proceed to the Greenwich Department to complete the following forms
1. SBCS Registration Form (for registration with SBCS)
After payment of the application fee to SBCS, you are required to present the receipt at the Greenwich Department for recording of the receipt number. If you need an acceptance letter after registration, kindly note that such requests usually takes three (3) working days to process.
Students must be at least 18 years old and have experience in any programming language, knowledge of data and files structure. Knowledge of Entity Relationship Modelling is also recommended.
Kindly email the Centre for University of Greenwich Programmes Unit at firstname.lastname@example.org to contact the following persons for further Information :
Mr. Micaiah Wilson - Senior Course Administrator
Ms. Cherisse Anderson - Assistant Course Adminstrator
The deadline for registration for July 2012 intake is Saturday 30th June, 2012.