Back to Top
Close Menu
 

Centre for Professional Development and Lifelong Learning

CAVE HILL HOME > Lifelong Learning > Courses > Postgraduate Modules > Database Design and Management

Postgraduate Modules


Management Studies

Database Design and Management

Overview

Database design and management skills are vital to enable efficient storage and extraction of large volumes of digital data.  This course will enable delegates to develop a good understanding of the basic concepts, principles and techniques of database design and management, and equip them with the skills necessary to analyse, design, and develop well-structured relational databases. In particular, delegates will learn data modelling using entity-relationship diagrams and will use database management systems (DBMS) to gain an appreciation of the concepts and practical applications of database management.

​​Mode of Delivery: Face-to-Face

What will I Learn?

On successful completion of this course delegates will be able to:
  • Define basic database concepts and terminology;
  • Describe the purpose and function of a database management system;
  • Apply database concepts to an information systems problem;
  • Critically evaluate  the practices and techniques of relational database analysis and design;
  • Analyse and design well-structured relational databases;
  • Use effectively the tools and techniques of database design and management to develop and manage a well-structured relational database;
  • Design and implement operational databases that help organisations successfully manage their business processes.

Who Should do this Course

Individuals who meet the entry requirements for postgraduate level training, including database engineers, developers, or persons without any prior knowledge of databases who want to develop the practical skills necessary for the analysis and design of relational databases, and the technical skills necessary for the development and management of relational databases; those who want to design and implement operational databases that help organizations successfully manage their business processes. 

Important Information

  • Applicants must bring all required documentation to the Department of Management Studies, Graduate Section, for their application to be processed.
  • Individuals applying for postgraduate modules, whose native language is not English, must take tests,  to demonstrate English Language proficiency prior to registration, as identified in the Manual of Procedures re: Regulations for Graduate Diplomas and Degrees (Sec. 1, Para. 5).

At a Glance

  • Admissions Term: 2018/2019 Summer
  • Date: Summer Semester (May to July)
  • Time: TBA
  • Duration: 6 weeks (36 hours)
  • Certificate Awarded: Postgraduate Professional Development Certificate of Competence
  • Course Code: BUSA 6005
  • Capacity: 5
  • Cost: BDS $2,385 (US $1,192.50) {with assessment} ; BDS $2,030 (US $1,015) {without assessment}

The following topics will be addressed:
  • Overview of database design and management
  • File Systems and Databases
  • E-R Modelling Concepts
  • E-R Modelling Methodology and Application
  • The Structured Query Language (SQL)
  • Transforming Conceptual Data Models to SQL
  • Normalisation
  • Database Management
  • Database warehousing
  • XML and Web Databases

For entry into this course, applicants must have at least an undergraduate degree, or five (5) years relevant work experience. Applicants may also be asked to provide an up-to-date Curriculum Vitae.

The teaching methods to be used in this course include the interactive lecture, in-class and online discussion (via eLearning), and practical exercises (lab sessions). Much emphasis will be placed on providing delegates with hands-on experience in applying concepts, principles, and techniques learned through participatory classroom demonstrations, practical exercises, and individual/group assignments. The use of various technological media such as PowerPoint and video illustrations of step-by-step procedures will also be incorporated in each session to aid in the teaching of complex concepts.

Glenda Gay, PhD