Database Management systems(PCC-206- COM)

📘 Introduction to Database Management Systems

Introduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, Enterprise Constraints.

📗 Data Models

Data Models describe how data is structured, stored, and manipulated in a database.

📙 Database Design and ER Model

  • Entity
  • Attributes
  • Relationships
  • Constraints
  • Keys
  • Design Process
  • Entity Relationship Model
  • ER Diagram
  • Design Issues
  • Extended E-R Features
  • Converting ER & EER Diagrams into Tables

📕 Case Study

Study of Architecture of any DBMS like Oracle or MySQL.

📝 Practical Task

Design a database schema for any problem given in previous question papers.