Set 47- DATABASE MANAGEMENT SYSTEM

DBMS is the acronym of Data Base Management System. DBMS is a collection of interrelated data and a set of programs to access this data in a convenient and efficient way. It controls the organization, storage, retrieval, security and integrity of data in a database.

Architecture of DBMS-The generalized architecture of DBMS is called ANSI/ SPARC model. The architecture is divided into three levels:

External view or user view/View Level- It is the highest level of data abstraction. This includes only those portions of database of concern to a user or Application program. Each user has a different
external view and it is described by means of a scheme called external schema.

Conceptual view/Logical Level- All the database entities and the relationship among them are included. One conceptual view represents the entire database called conceptual schema.

Internal view/Physical Level- It is the lowest level of abstraction, closest to the physical storage method. It describes how the data is stored, what is the structure of data storage and the method of accessing these data. It is represented by internal schema.

Data model:A data model is a plan for building a database. The model represents data conceptually, the way the user sees it, rather than how computers store it. Data models focus on required data elements and associations.
Entity – Relationship Model
Relational Model

Entity:A thing (animate or inanimate) of independent physical or conceptual existence and distinguishable. In the University database context, an individual student, faculty member, a class room, a course are entities.

 Attributes
Each entity is described by a set of attributes/properties.
Types of Attributes

Simple Attributes: having atomic or indivisible values: Dept – a string Phone Number – an eight digit number.

Composite Attributes: having several components in the value. Example: Qualification with components (Degree Name, Year, University Name)

Derived Attributes: Attribute value is dependent on some other attribute. Example: Age depends on Date of Birth. So age is a derived attribute.

Single-valued: having only one value rather than a set of values. For instance, Place of Birth-
single string value.

Multi-valued: having a set of values rather than a single value, for instance, Courses Enrolled attribute for student Email Address attribute for student Previous Degree attribute for student. Attributes can be: simple single-valued, simple multi-valued, composite single-valued or composite multi-valued.