InsideEdgeInsideEdge
Semester 3ECM4302E-Commerce

Database Management Systems (ECM4302) crash course, Online MBA, Semester 3:

This subject covers how database management systems are structured, how relational databases and ER models are designed, the integrity rules and relational…

  • 18 video lessons
  • 4h
  • Study notes
  • 90 quiz questions
  • Assignment
Enroll nowSee the lessons
Database Management Systems crash course

18 lessons in Database Management Systems

Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.

About this subject

This subject covers how database management systems are structured, how relational databases and ER models are designed, the integrity rules and relational algebra behind them, and how to write SQL in MS Access and SQL Server. After it, you will be able to design a simple database with ER diagrams and keys, query and update it with SQL, and judge where distributed, object-oriented, multimedia and data warehouse systems fit in business use.

  1. 1

    What is a DBMS: File System vs DBMS

    Module I, Introduction to DBMS: Definition of DBMS, Concept and Goals of DBMS, File System Approach Vs DBMS Approach, Advantages of Using a DBMS

    File System vs. Database Management System· Neso Academy· 23 min

    Study notes 5 quiz questionsWatch lesson
  2. 2

    DBMS Architecture, Levels and Data Independence

    Module I, Introduction to DBMS: Data Independence, DBMS Architecture, Levels, Database Abstraction

    Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System· Gate Smashers· 15 min

    Study notes 5 quiz questionsWatch lesson
  3. 3

    Data Models, Schemas and Instances

    Module I, Introduction to DBMS: Data Models, Schemas, and Instances, Database Languages

    Introduction to Data Models· Neso Academy· 16 min

    Study notes 5 quiz questionsWatch lesson
  4. 4

    Database Users and the Database Administrator

    Module I, Introduction to DBMS: Database Administrator, Database Users

    Database Users· Neso Academy· 11 min

    Study notes 5 quiz questionsWatch lesson
  5. 5

    Relational Model and Codd's Rules

    Module II, Relational Database & ER Model: Relational Database: Relational System, Codd's Rule, Relational Model

    Lec-131: Codd’s 12 Rules of RDBMS with examples· Gate Smashers· 14 min

    Study notes 5 quiz questionsWatch lesson
  6. 6

    Query Optimization, Tables and Views

    Module II, Relational Database & ER Model: Optimization, Tables and Views

    Lec-125: View in Database | Oracle, SQL Server Views | Types of Views· Gate Smashers· 13 min

    Study notes 5 quiz questionsWatch lesson
  7. 7

    ER Model: Entities and Relationships

    Module II, Relational Database & ER Model: ER Model: Entity Type, Entity Set, Relationship type, Relationship sets

    ER Model in DBMS || Entity || Attribute || Entity Set || Types of Attributes || Relationship || Degr· Sudhakar Atchala· 19 min

    Study notes 5 quiz questionsWatch lesson
  8. 8

    Cardinality, Participation Constraints and Keys

    Module II, Relational Database & ER Model: Constraints: Cardinality Ratio and Participation Constraint, Keys

    ER Model in DBMS || Entity || Attribute || Entity Set || Types of Attributes || Relationship || Degr· Sudhakar Atchala· 11 min

    Study notes 5 quiz questionsWatch lesson
  9. 9

    Designing ER Diagrams and Mapping to Tables

    Module II, Relational Database & ER Model: Mapping, Design of ER diagrams

    Entity Relationship Diagrams· Decomplexify· 19 min

    Study notes 5 quiz questionsWatch lesson
  10. 10

    Domains, Relations and Predicates

    Module III, Relational Model Objects: Domains and Relations, Relations and predicates

    Relation, Predicate, Domain in DBMS | Hindi | BCA· Exam BCA· 7 min

    Study notes 5 quiz questionsWatch lesson
  11. 11

    Relational Integrity: Primary, Candidate and Foreign Keys

    Module III, Relational Model Objects: Relational Data Integrity, Primary Key, Candidate Key, Foreign Key and their rules

    Keys in RDBMS· Neso Academy· 19 min

    Study notes 5 quiz questionsWatch lesson
  12. 12

    Relational Algebra Operators

    Module III, Relational Model Objects: Relational operators, Relational Algebra

    relational algebra complete topic in dbms, various operations, various operators, relational algebra· NS lectures· 28 min

    Study notes 5 quiz questionsWatch lesson
  13. 13

    SQL Basics: DDL, DML and DCL Commands

    Module IV, SQL: SQL Language, DDL, DML and DCL commands

    Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS· Gate Smashers· 11 min

    Study notes 5 quiz questionsWatch lesson
  14. 14

    Creating Tables in MS Access and SQL Server

    Module IV, SQL: Data definition

    Creating tables and adding data in Microsoft SQL Server - using GUI and T-SQL code· SQL Server 101· 5 min

    Study notes 5 quiz questionsWatch lesson
  15. 15

    SQL Queries and Updates in MS Access and SQL Server

    Module IV, SQL: Data retrieval and update operations on MS ACCESS and SQL Server DBMS

    sql query in ms access | create table, select, insert, update, delete using sql query in ms access· Vision Infotech· 8 min

    Study notes 5 quiz questionsWatch lesson
  16. 16

    Distributed and Object-Oriented Databases

    Module V, Database Applications and Types: Distributed Database, Object Oriented Database

    Distributed Database in DBMS | Learn Coding· Learn Coding· 6 min

    Study notes 5 quiz questionsWatch lesson
  17. 17

    Multimedia Databases and Digital Libraries

    Module V, Database Applications and Types: Multimedia Database, Digital Libraries

    Digital Library in Information Retrieval system | Data warehouse | CS Simplified Amit Sagu· CSE Simplified (Sagu Amit)· 6 min

    Study notes 5 quiz questionsWatch lesson
  18. 18

    Data Warehouse and Data Mining

    Module V, Database Applications and Types: Data Mining, Data Warehouse

    Data Warehouse and Data Mining, Information management· DWIVEDI GUIDANCE· 9 min

    Study notes 5 quiz questionsWatch lesson

Assignment

Design and Build a Small Business Database: From File System to SQL

Free login to open
What you get

Less scrolling. More passing.

  • Free

    Hand-picked video lessons

    18 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.

  • Free login

    Study notes

    18 lessons come with a summary, key points, key terms and takeaways for quick revision.

  • Free login

    Quizzes

    90 questions across the course, with the right answer and why, the moment you pick.

  • Free login

    Assignments

    1 subject assignments with clear tasks, so you practise what each subject actually asks of you.

  • Free login

    Notebook

    Write notes beside the video, stamped with the exact time, and jump back to that moment later.

  • Free login

    Progress that follows you

    Completed lessons, quiz scores and where you stopped, saved to your account on every device.

  • Live chat pass

    Live chat

    A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.

Members only

The Online MBA live chat. Study together, live.

A live chat right beside the video, shared by everyone studying Online MBA. Ask a Database Management Systems doubt mid-lesson, share a shortcut, celebrate a finished semester.

  • Live chat beside every lesson
  • One live chat for all of Online MBA
  • Members-only stickers & GIFs
  • One ₹19 pass opens every live chat
Open the live chat
Pass₹19

More from Online MBA Semester 3

All subjects

Database Management Systems: common questions

This subject covers how database management systems are structured, how relational databases and ER models are designed, the integrity rules and relational algebra behind them, and how to write SQL in MS Access and SQL Server. After it, you will be able to design a simple database with ER diagrams and keys, query and update it with SQL, and judge where distributed, object-oriented, multimedia and data warehouse systems fit in business use. It's the Database Management Systems subject of Online MBA, Semester 3, in 18 lessons: What is a DBMS: File System vs DBMS; DBMS Architecture, Levels and Data Independence; Data Models, Schemas and Instances; Database Users and the Database Administrator; Relational Model and Codd's Rules; Query Optimization, Tables and Views; ER Model: Entities and Relationships; Cardinality, Participation Constraints and Keys; Designing ER Diagrams and Mapping to Tables; Domains, Relations and Predicates; Relational Integrity: Primary, Candidate and Foreign Keys; Relational Algebra Operators; SQL Basics: DDL, DML and DCL Commands; Creating Tables in MS Access and SQL Server; SQL Queries and Updates in MS Access and SQL Server; Distributed and Object-Oriented Databases; Multimedia Databases and Digital Libraries; Data Warehouse and Data Mining.

Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.

About 4h of video across 18 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.

Yes: “Design and Build a Small Business Database: From File System to SQL”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.

A members-only live chat beside the video, shared by everyone studying Online MBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.

No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.

Enroll now