The 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 moreRDBMS
Data 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 moreDatabase Languages
A database system provides a data definition language to specify the database schema and a data manipulation language to express
Read moreData Models
Underlying the structure of a database is the data model: a collection of conceptual tools for describing data, data relationships,
Read moreInstances and Schemas
Databases change over time as information is inserted and deleted. The collection of information stored in the database at a
Read more