Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page

Was this helpful?

  1. Database

View of Data

PreviousQuery LanguageNextData Abstraction

Last updated 1 year ago

Was this helpful?

A database system is a collection of interrelated data and a set of programs that allow users to access and modify these data. A major purpose of a database system is to provide users with an abstract view of the data. That is, the system hides certain details of how the data are stored and maintained.

Data Abstraction
Schemas and Instances
Data Models