Database Management Application System
- Management Sciences
- 800 level
- 3 credit units
- 194 pages
- 11 units
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.
About this course
- Difficulty
- Intermediate
- Study hours
- 40 hours
- Maths
- Basic
- Content
- Theoretical, practical, case study
- Practical work
- Yes
- Basic computer literacy
- Introductory programming concepts
- Assignments
- Tutor marked assessments
- Final examination
What you'll read
The real module and unit structure of MBA859, taken from the course material NOUN publishes.
One paragraph, so you can see how it reads
MBA859 · UNIT 1 OVERVIEW
This constitutes the scheduled dates and venue for tutorial classes, as well as how and when to submit the tutorials. All this wil bcoemmunicated to you in due course.
What you should be able to do
- Design and implement relational databases
- Apply SQL for data manipulation and querying
- Understand data modeling principles
- Implement data security measures
- Design and manage data warehouses
- Apply document management systems
What it prepares you for
- Database Administrator
- Data Analyst
- Data Architect
- Database Developer
- Information Security Analyst
- Finance
- Healthcare
- Retail
- Government
- Education
- SQL
- DBMS software (e.g., MySQL, Oracle)
- Data modeling tools
Where it gets hard
The units students slow down on, and what makes each one heavy.
- Module 1:
Unit 5: Database Models: Relational Model
Advanced calculus integration techniques require strong mathematical foundation.
- Module 2:
Unit 3: Database and Information Systems Security
Database normalization concepts involve complex logical reasoning.
A suggested way through it
13 weeks, about 26 hours in total. Yours will differ.
- Week 1Module 1:
Unit 1: Overview · 2 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 2Module 1:
Unit 2: Database · 2 hours
Define a database.. Understand basic database terms.. Learn about the history of database development.. Differentiate database types.. Understand database structure..
- Week 3Module 1:
Unit 3: Database Concepts · 2 hours
Understand CRUD operations.. Learn about ACID properties.. Identify different types of database keys..
- Week 4Module 1:
Unit 4: Database Models 1 · 2 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 5Module 1:
Unit 5: Database Models: Relational Model · 2 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 6Module 1:
Unit 6: Basic Components of DBMS · 2 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 7Module 2:
Unit 1: Development and Design-Of Database · 2 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 8Module 2:
Unit 2: Structured Query Languages (SQL) · 2 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 9Module 2:
Unit 3: Database and Information Systems Security · 2 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 10Module 2:
Unit 4: Database Administrator and Administration · 2 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 11Module 3:
Unit 1: Relational DATABASE MANAGEMENT APPLICATION SYSTEMs · 2 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 12Module 3:
Unit 2: Datawarehouse · 2 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 13Module 3:
Unit 3: Document Management System · 2 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..
Preparing for the exam
- Create concept maps linking Units 3-5 database concepts
- Practice SQL queries from Units 7-9 weekly
- Review database normalization examples from Unit 10
- Study security protocols from Units 11-12
- Focus on data warehousing concepts in Unit 13
Questions students ask about this course
What is MBA859 about?
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.
How many units does MBA859 have?
MBA859, Database Management Application System, has 11 units across 3 modules, over 194 pages of course material. You can read it one unit at a time.
How many credit units is MBA859?
MBA859 carries 3 credit units, at 800 level in Management Sciences.
Is MBA859 hard?
MBA859 is rated intermediate level, with basic mathematical content. It is mostly theoretical, practical and case study work, and it has a practical component.
How long does MBA859 take to study?
About 40 hours of study, spread across its 11 units.
How is MBA859 assessed?
MBA859 is assessed by assignments, tutor marked assessments and final examination.
What do I need before starting MBA859?
Basic computer literacy Introductory programming concepts
What can I do with MBA859?
Database Administrator, Data Analyst, Data Architect, Database Developer and Information Security Analyst.