Skip to main content
NounStudy
Back to Course Catalog
MBA859Management Sciences3 Unitsintermediate

Database Management Application System

This course, Database Management System (DBMS), is designed for students pursuing Masters Degrees in business, finance, marketing, and related fields. It is also suitable for Postgraduate Diploma students in business, sciences, and education. The course aims to equip students with the knowledge of how to design, manipulate, and manage databases, covering various database systems, models, and data/information management concepts. It encourages the effective use of database management systems for data management.

Generate AI Study Notes

Transform this course into personalized study materials with AI

40h
Study Time
13
Weeks
3h
Per Week
basic
Math Level
Course Keywords
Database ManagementRelational ModelSQLData WarehouseData Security

Course Overview

Everything you need to know about this course

Course Difficulty

Intermediate Level
Builds on foundational knowledge
65%
intermediate
➕
Math Level
Basic Math
🔬
Learning Type
Hands-on Practice

Course Topics

Key areas covered in this course

1

Database Systems

2

Relational Model

3

SQL

4

Data Modeling

5

Data Security

6

Data Warehousing

7

Document Management

Total Topics7 topics

Requirements

Knowledge and skills recommended for success

Basic computer literacy

Introductory programming concepts

💡 Don't have all requirements? Don't worry! Many students successfully complete this course with basic preparation and dedication.

Assessment Methods

How your progress will be evaluated (3 methods)

assignments

Comprehensive evaluation of course material understanding

Written Assessment

tutor-marked assessments

Comprehensive evaluation of course material understanding

Written Assessment

final examination

Comprehensive evaluation of course material understanding

Written Assessment

Career Opportunities

Explore the career paths this course opens up for you

Database Administrator

Apply your skills in this growing field

Data Analyst

Apply your skills in this growing field

Data Architect

Apply your skills in this growing field

Database Developer

Apply your skills in this growing field

Information Security Analyst

Apply your skills in this growing field

Industry Applications

Real-world sectors where you can apply your knowledge

FinanceHealthcareRetailGovernmentEducation

Study Schedule Beta

A structured 13-week journey through the course content

Week
1

Module 1:

2h

Unit 1: Overview

2 study hours
  • •Read the introduction and objectives.
  • •Understand the description of DBMS.
  • •Identify the benefits, features, and capabilities of DBMS.
  • •Differentiate the types and models of DBMS.
Week
2

Module 1:

2h

Unit 2: Database

2 study hours
  • •Define a database.
  • •Understand basic database terms.
  • •Learn about the history of database development.
  • •Differentiate database types.
  • •Understand database structure.
Week
3

Module 1:

2h

Unit 3: Database Concepts

2 study hours
  • •Understand CRUD operations.
  • •Learn about ACID properties.
  • •Identify different types of database keys.
Week
4

Module 1:

2h

Unit 4: Database Models 1

2 study hours
  • •Define and differentiate database models.
  • •Sketch hierarchical and network models.
  • •Understand concepts behind the models.
  • •Know the advantages and disadvantages of different models.
Week
5

Module 1:

2h

Unit 5: Database Models: Relational Model

2 study hours
  • •Define relational model.
  • •Understand the concept behind relational models.
  • •Interpret a relational database model.
  • •Know applications of relational databases.
  • •Compare relational model with SQL.
  • •Know constraints and controversies.
Week
6

Module 1:

2h

Unit 6: Basic Components of DBMS

2 study hours
  • •Understand ACID rules.
  • •Learn about concurrency control.
  • •Mention concurrency control methods.
  • •Define and interpret JDBC.
  • •Know JDBC types and drivers.
  • •Define query optimizer, applications, and cost estimation.
Week
7

Module 2:

2h

Unit 1: Development and Design-Of Database

2 study hours
  • •Understand data planning and database design.
  • •Know steps in database development.
  • •Identify functions of each step.
  • •Define database normalization.
  • •Know problems addressed by normalization.
Week
8

Module 2:

2h

Unit 2: Structured Query Languages (SQL)

2 study hours
  • •Define SQL.
  • •Trace history and development of SQL.
  • •Know scope and extension of SQL.
  • •Identify vital indices of SQL.
  • •Know language elements.
  • •Know criticisms of SQL.
  • •Answer question of alternatives to SQL.
Week
9

Module 2:

2h

Unit 3: Database and Information Systems Security

2 study hours
  • •Understand CIA Trade in information systems security.
  • •Know Donn Parker model for classic Triad.
  • •Identify information access control types.
  • •Differentiate Discretionary and Mandatory Access Control Policies.
  • •Know Proposed OODBMS Security Models.
  • •Differentiate OODBMS models.
  • •Define procedures and protection for information security.
  • •Define cryptography and know its applications.
Week
10

Module 2:

2h

Unit 4: Database Administrator and Administration

2 study hours
  • •Answer question of who is a database administrator.
  • •Identify functions of database administrator.
  • •Know different types of database administration.
  • •Understand nature of database administration.
  • •Know tools used in database administration.
Week
11

Module 3:

2h

Unit 1: Relational DATABASE MANAGEMENT APPLICATION SYSTEMs

2 study hours
  • •Define relational DATABASE MANAGEMENT APPLICATION SYSTEM.
  • •Trace origin and development of RDBMS.
  • •Identify market structure of RDBMS.
  • •Identify major types of relational management systems.
  • •Compare and contrast types of RDBMS based on several criteria.
Week
12

Module 3:

2h

Unit 2: Datawarehouse

2 study hours
  • •Define data warehouse.
  • •Trace history and development of data warehouse.
  • •List benefits of data warehouse.
  • •Define architecture of a data warehouse.
  • •Compare and contrast Data Warehouses and Operational Systems.
  • •Know what is a data warehouse appliance, and disadvantages of data warehouse.
  • •Have idea of what the future holds for data warehouse concept.
Week
13

Module 3:

2h

Unit 3: Document Management System

2 study hours
  • •Define document management system.
  • •Trace history and development of document management system.
  • •Compare and contrast document management system and content management systems.
  • •Know basic components of document management systems.
  • •Answer question of issues addressed by document management systems.
  • •Know types of document management systems available off the shelf.

This study schedule is in beta and may not be accurate. Please use it as a guide and consult the course outline for the most accurate information.

Course PDF Material

Read the complete course material as provided by NOUN.

Access PDF Material

Study Tips & Exam Preparation

Expert tips to help you succeed in this course

1

Create concept maps linking Units 3-5 database concepts

2

Practice SQL queries from Units 7-9 weekly

3

Review database normalization examples from Unit 10

4

Study security protocols from Units 11-12

5

Focus on data warehousing concepts in Unit 13

Related Courses

Other courses in Management Sciences that complement your learning

MKT825

International Marketing

3 Units
PAD813

Quantitative Methods for Public Administration

3 Units
MBF845

International Banking

3 Units
View All Management Sciences Courses