Advanced Database Management System
- Sciences
- 900 level
- 372 pages
- 17 units
This course introduces students to advanced concepts in Database Management Systems. It covers relational database design, SQL, and database system catalogs. Students will explore query processing, transaction management, security, and distributed databases. The course also examines emerging trends like XML, data warehousing, and data mining, along with examples of DBMS architectures and modern database applications.
About this course
- Difficulty
- Intermediate
- Study hours
- 90 hours
- Maths
- Basic
- Content
- Theoretical, practical, case study
- Practical work
- Yes
- Assignments
- Tutor marked assessments
- Final examination
What you'll read
The real module and unit structure of CIT905, taken from the course material NOUN publishes.
One paragraph, so you can see how it reads
CIT905 · UNIT 1: RELATIONAL DATABASE DESIGN AND IMPLEMENTATION
For example above, the relationship between employee and project in one database is represented as a relationship between employee, department and project in another database.
What you should be able to do
- Describe the basic concepts of Relational Database Design
- Explain Database implementation and tools
- Describe SQL and Database System catalog
- Describe the process of DB Query processing and evaluation
- Discuss the concepts of transaction management
- Explain the Database Security and Authorization
- Describe the design of Distributed Databases
- Know how to design a Database and XML
- Describe the basic concept of Data warehousing and Data mining
- Discuss the emerging Database Models, Technologies and Applications
What it prepares you for
- Database Administrator
- Data Analyst
- Database Developer
- Data Scientist
- Business Intelligence Analyst
- Finance
- Healthcare
- E-commerce
- Government
- Education
- ORACLE
- PostgreSQL
- MySQL
- MongoDB
- SQL Server
Where it gets hard
The units students slow down on, and what makes each one heavy.
- Module 2: DBMS Advance Features
Unit 2: Transaction Management and Recovery
Locking techniques for concurrency control based on time stamp ordering require deep understanding of time-based algorithms and their impact on data consistency.
- Module 3: Distributed Databases
Unit 2: Enhanced Database Models
The concepts of Network Data Modeling and the use of sets to represent M:N relationships require a strong understanding of data structures and relationships.
A suggested way through it
13 weeks, about 51 hours in total. Yours will differ.
- Week 1Module 1: Database Design and Implemental
Unit 1: Relational Database Design and Implementation · 3 hours
Read Unit 1: Understand relational data model concepts.. Study database schema, integration, and design.. Review the Entity Relationship Diagram (ERD).. Complete Tutor-Marked Assignment (TMA)..
- Week 2Module 1: Database Design and Implemental
Unit 2: Advance SQL · 3 hours
Study SQL syntax and statements.. Practice Data Manipulation Language (DML) commands.. Learn to view table structures.. Complete SQL SELECT statements and exercises.. Complete Tutor-Marked Assignment (TMA)..
- Week 3Module 1: Database Design and Implemental
Unit 3: Database System Catalog · 3 hours
Understand the purpose and functions of a database system catalog.. Explore the features of system catalogs.. Learn about views with the prefix ALL.. Complete Tutor-Marked Assignment (TMA)..
- Week 4Module 2: DBMS Advance Features
Unit 1: Query Processing & Evaluation · 3 hours
Study query processing and evaluation techniques.. Learn about catalog information for cost estimation.. Explore measures of query cost.. Complete Tutor-Marked Assignment (TMA)..
- Week 5Module 2: DBMS Advance Features
Unit 2: Transaction Management and Recovery · 4 hours
Understand transaction properties and states.. Study concurrent execution of transactions.. Learn about concurrency control and locking techniques.. Explore database recovery management and ARIES.. Complete Tutor-Marked Assignment (TMA)..
- Week 6Module 2: DBMS Advance Features
Unit 3: Database Security & Authorization · 3 hours
Study database security and authorization concepts.. Learn about security breaches and threats.. Explore counter measures and security implementation.. Complete Tutor-Marked Assignment (TMA)..
- Week 7Module 3: Distributed Databases
Unit 1: Distributed database System · 3 hours
Understand distributed database system concepts.. Study types of distributed database systems.. Learn about advantages and disadvantages of distributed databases.. Explore components and trends in distributed databases.. Complete Tutor-Marked Assignment (TMA)..
- Week 8Module 3: Distributed Databases
Unit 2: Enhanced Database Models · 3 hours
Study concepts of network data modeling.. Learn about records, record types, and data items.. Explore stored representations of set instances.. Understand constraints in the network model.. Complete Tutor-Marked Assignment (TMA)..
- Week 9Module 3: Distributed Databases
Unit 3: Object Oriented Database · 3 hours
Study basic concepts of OO Programming.. Understand object oriented databases models.. Complete Tutor-Marked Assignment (TMA)..
- Week 10Module 3: Distributed Databases
Unit 4: Database and XML · 3 hours
Learn about XML elements and attributes.. Complete Tutor-Marked Assignment (TMA)..
- Week 11Module 3: Distributed Databases
Unit 5: Introduction to Data Warehousing · 3 hours
Study components of a data warehouse.. Learn about warehouse schemas.. Complete Tutor-Marked Assignment (TMA)..
Unit 6: Introduction to Data Mining · 3 hours
Understand datamining concepts and KDD stages.. Learn about mining systems and types of mined data.. Explore DM tasks and techniques.. Complete Tutor-Marked Assignment (TMA)..
- Week 12Module 4: Emerging Trends and Example of DBMS Architecture
Unit 1: Relational and Non-Relational databases · 3 hours
Study SQL-based and Non-Relational database systems.. Learn about advantages and disadvantages of each.. Explore types of NoSQL Database engines.. Complete Tutor-Marked Assignment (TMA)..
Unit 2: Conventional Database Management Systems · 3 hours
Study Oracle Database Management System.. Learn about Programming Language Support by Oracle.. Explore MySQL Database and its features.. Complete Tutor-Marked Assignment (TMA)..
- Week 13Module 4: Emerging Trends and Example of DBMS Architecture
UNIT 3: Emerging Database Systems · 4 hours
Study Internet Databases and Digital Libraries.. Learn about Multimedia and Mobile Databases.. Explore Spatial Databases and Emerging databases in support of scientific data.. Complete Tutor-Marked Assignment (TMA)..
Unit 4. Database Services and Service Providers · 4 hours
Study Database as a Service (DBaas).. Learn about Developer agility and IT productivity.. Explore Big Data Processing and Distribution Software.. Complete Tutor-Marked Assignment (TMA)..
Preparing for the exam
- Review all tutor-marked assignments (TMAs) and their solutions to understand key concepts and problem-solving techniques.
- Create concept maps linking modules and units to visualize relationships between different database concepts.
- Practice writing SQL queries for different scenarios, focusing on SELECT, INSERT, UPDATE, and DELETE statements.
- Study transaction management concepts, including ACID properties, concurrency control, and recovery techniques.
- Focus on understanding the differences between relational and non-relational databases, their advantages, and disadvantages.
- Review the different database models and their applications, including distributed, object-oriented, and XML databases.
- Practice identifying and mitigating database security threats, including access control, inference control, and flow control.
- Create a study schedule that allocates sufficient time for each module and unit, ensuring comprehensive coverage of the course material.
Questions students ask about this course
What is CIT905 about?
This course introduces students to advanced concepts in Database Management Systems. It covers relational database design, SQL, and database system catalogs. Students will explore query processing, transaction management, security, and distributed databases. The course also examines emerging trends like XML, data warehousing, and data mining, along with examples of DBMS architectures and modern database applications.
How many units does CIT905 have?
CIT905, Advanced Database Management System, has 17 units across 4 modules, over 372 pages of course material. You can read it one unit at a time.
Is CIT905 hard?
CIT905 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 CIT905 take to study?
About 90 hours of study, spread across its 17 units.
How is CIT905 assessed?
CIT905 is assessed by assignments, tutor marked assessments and final examination.
What can I do with CIT905?
Database Administrator, Data Analyst, Database Developer, Data Scientist and Business Intelligence Analyst.