What is a Relational Database | Database Management System | CS403P DBMS Labs | Lab No. 5 Explained

CS403P Database Management System Lab No. 5: Introduction to Relational Database In this session, we take a structured step forward by understanding the big picture of database modeling — where we started, where we are now, and what is coming next in the course. This lab connects the dots between Conceptual, Logical, and Physical models, helping students clearly understand the transition from ERD to relations and toward implementation. 🎯 What This Lab Covers 🔹 Database Models Overview Conceptual Model (ERD and related concepts) Logical Model (Relations and structure) Physical Model (Implementation in DBMS) 🔹 Core Concepts Introduced ✔ What is a Database? ✔ What is a Relational Database? ✔ What is a Relation? ✔ Properties of a Relation ✔ Difference between schema and table instance 🔹 Practical Activity 📝 Database Activity: Given a relation schema (scheme) Creating records based on that schema Converting those records into a proper 2-dimensional table This activity helps students practically understand: How structure (schema) differs from data How relations are formed How relational databases organize data in tabular form 📚 Why This Lab is Important This lab builds the foundation for: Understanding relational database systems Preparing for SQL implementation Learning normalization Moving toward physical database creation It ensures students clearly understand: Conceptual → Logical → Physical Meaning → Structure → Implementation #CS403 #DatabaseManagementSystem #CS403FinalExamPreparation #CS403PFinalExamPreparation #RelationalDatabase #Relation #Tuple #Database #VirtualUniversity #MKK