Database Management System

UNIT 1

RELATIONAL DATABASES





    What is a Relational Database (RDBMS)?

  • A relational database is a type of database that stores and provides access to data points that are related to one another.
  • Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

    Watch the below video to know more!

    Start to code your first SQL query!

Purpose of Database System

  • The purpose of DBMS is to transform the following Data into information.Data into information.
  1. Data into information.
  2. Information into knowledge.
  3. Knowledge to the action.

    Watch the below video to know more!

Full notes link 👇

click here

Views of Database

  • It refers that how database is actually stored in database, what data and structure of data used by database for data. So describe all this database provides user with views and these are
  1. Data abstraction.
    • DBMS hides some information's which is not of user interest, a this is called data abstraction
    • So developer hides complexity from user and store abstract view of data.
    • Data abstraction has three level of abstractions:
      1. Level / internal level
      2. Logical level / Conceptual level
      3. View level / External level

  2. Instances and schemas.
    • Design of database is called the Schema.
    • It is basically skeleton structure that represent the logical view of entire database.
    • Database system has various schemas.
      1. Physical database schema
      2. Logical database schema
      3. View Schema

    Watch the below video to know more!

Full notes link 👇

click here

Data Models