- Database
Management System : Interrelated data and a sets of
program by which we can access and manipulate those data is called Data
Management System.
- Data: Data
is sequence of digit. data is those elements which will be information
after processed.
such as i) Numeric
ii) Textual
iii) Graphical
- Information
: information is processed data.
- Data
structure : Organized Collection of data and a set of operation
on them is called data structure.
- File
: If we think a unit of interrelated information or records is
called file.
- Database
: All structured data of a organization store in a computer
system is called database.
I) Hierarchical
DBMS
II) Network
DBMS
III) Relational
DBMS
IV) Inverted
DBMS
- Database
Integrity: if data are interconnected with each other in the database
is called data integrity.
- Database
redundancy : If homologues data are stayed in defferent place in
the database is called database redundancy.
- Data
Model : Data Model is a collection of same conceptual tools which
describe data, data relationship, data semantics, and data constraints.
data Model is main base of data structured.
I) Object
based logical model
II) record
base Logical Model.
III) Physical
Model
- Relational
Data Model: the Data Model which use some table to express
relation among data of record base logical model
- Data
Schema : Overall design of database is called database schema
- Data
Dictionary: After Compilation of data definition language we get a set
of table. Those are stored in a file. This file is called data dictionary.
- Data
Entity : Data Entity is some objects which has existence ad we
can distinguish them form each other.
- Entity
set : a Group of similar object which has similar properties.
- Primary
key : An unique identifier which identify the entity
differently is called primary key.
- Formal
Query Language : Formal Query Language is a language by which we
can get procedural or non procedural benefit.
- Commercial
Query Language: Commercial Query Language is a language by
which we can get procedural and non procedural benifit.
- Most
Popular Query Language are:
I) SQL
( Structured Query Language)
II) QBE
( Query By Example)
III) Quel
( ( Query Language)
IV) Datalog.
- Several
Parts of SQL
I) DDL
(Data definition Language)
II) DML
( Data Manipulation Language)
III) Embeded
DML
IV) View
Definition
V) Authorization
VI) Integrity
VII) Transaction
Control
- There
are three clause of SQL
I) select
II) from
III) where
- Aggregate
function of SQL
I) average
: avg
II) minimum
: min
III) Maximum:
Max
IV) Total
: SUM
V) Count
: Count
- Parallel
Database system
- Distributed
Database System
