16-10-2012, 03:36 PM
DATABASE MANAGEMENT SYSTEM
MBA 758 Database Management System.pdf (Size: 988.76 KB / Downloads: 208)
Introduction
This course, Database Management System (DBMS), is a course
designed in the pursuit of a degree in Masters Degrees in business,
finance, marketing and related fields of study. It is also a course that
can be studied by Postgraduate Diploma students in business, sciences
and education.
This course is relevant to students studying business because
information/data form the foundation of any business enterprise. Thus a
thorough understanding of how to manipulate, design and manage
databases.
This course is primarily to be studied by students who are already
graduates or post graduates in any field of study. Students who had not
had exposure to computer science in their first degrees need to put in
extra effort to grasp this course properly.
This course guide takes you through the nature of the course, the
materials you are going to use and how you are to use materials to your
maximum benefit. It is expected that at least two hours should be
devoted to the study of each course unit. For each unit there
assessments in the form of tutor-marked assignment. You are advised
carry out the exercises immediately after studying the unit.
There will be tutorial lectures to organized for this course. This serves
as an avenue to interact with course instructors who will communicate
more clearly with you regarding the course. You are advised to attend
the tutorial lectures because it will enhance your understanding of the
course. Note that it is also through these tutorial lectures that you will
submit your tutor-marked assignment and be assessed accordingly.
Course Aim
Behind the development and design of this course is to know how to
design, manipulate and manage databases. The course participants are
exposed to the various forms, types and models of database systems to
enable them make viable choices. Supportive and complimentary
concepts of managing data and documents are thoroughly examined to
give a wholesome view of data/information management. The ultimate
aim is to encourage the usage of database management systems for
effective data management.
i
MBA 758 DATABASE MANAGEMENT SYSTEM
Course Objectives
The following are the major objectives of this course:
· define a Database Management System
· give a description of the Database Management structure
· define a Database
· define basic foundational terms of Database
· understand the applications of Databases
· know the advantages and disadvantages of the different models
· compare relational model with the Structured Query Language
(SQL)
· know the constraints and controversies associated with relational
database model.
· know the rules guiding transaction ACID
· identify the major types of relational management systems
· compare and contrast the types of RDBMS based on several criteria
· understand the concept of data planning and Database design
· know the steps in the development of Databases
· trace the history and development process of SQL
· know the scope and extension of SQL
· differentiate Discretionary and. Mandatory Access Control Policies
· know the Proposed OODBMS Security Models
· identify the various functions of Database Administrator
· trace the history and development process of datawarehouse
· list various benefits of datawarehouse
· compare and contrast document management system and content
management systems
· know the basic components of document management systems
Course Materials
1. Course Guide
2. Study Units
3. Textbooks
4. Assignment File
5. Tutorials