What is SQL?
Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in the
Read moreAuthor: Krishna
Developing the Basic Schema
Once entities and relationships have been identified and defined, the first draft of the entity relationship diagram can be created.
Read moreData Modeling As Part of Database Design
The data model is one part of the conceptual design process. The other is the function model. The data model
Read moreThe Entity-Relationship Model
The Entity-Relationship (ER) model was originally proposed by Peter in 1976 as a way to unify the network and relational
Read moreData Modeling In the Context of Database Design
Database design is defined as: “design the logical and physical structure of one or more databases to accommodate the information
Read moreData Modeling
A data model is a conceptual representation of the data structures that are required by a database. The data structures
Read moreTypes of Database System
Several criteria are normally used to classify DBMSs. The first is the data model on which the DBMS is based.
Read moreDBMS Architecture and Data Independence
Three important characteristics of the database approach are (1) insulation of programs and data (program-data and program-operation independence); (2) support
Read moreDatabase Administrators and Database Users
A primary goal of a database system is to retrieve information from and store new information in the database. People
Read moreData Dictionary
We can define a data dictionary as a DBMS component that stores the definition of data characteristics and relationships. You
Read more