DBMS — UT1

Study notes

  • What is the purpose of a Database System?
  • Explain the different types of Relationships with a neat diagram.
  • Explain the roles of different types of DBMS Users.
  • Differentiate between Logical View and Physical View.
  • Draw the ER Diagram of a Bank Management System (BMS).
  • Explain different types of Attributes with examples.
  • What is meant by Data Model and its types?
  • What is meant by Constraint? Explain constraints.
  • Explain Relational Algebra with examples.
  • Draw the ER Diagram of Hospital Management System.
  • Explain Join Operation in Relational Algebra.