Basic concepts
Integrity constraints
Database models
E-R diagrams
Mapping cardinality
Participation Constraints
Weak entity set
Specialization
Generalization
Aggregation
E-R Diagram Example
, Database design involves understanding opera
and business needs of an organization, modelin
specified requirements, and realizing the require
using a database.
The overall database design process has to foll
Basic series of steps. The systematic process of design
Concepts database is known as design methodology.
The goal of designing a database is to produce effi
high quality, and minimum cost database.
In large organizations, database administrator (DB
responsible for designing an efficient database sys
, Integrity constraints are the set of rules impo
database to maintain quality of data.
Integrity constraints ensures that any manipulat
data does not affect the data integrity.
Integrity It secures the data management.
Constraint
Various Integrity Constraints are:
1. Check
2. Not null
3. Unique Key
4. Primary key
5. Foreign key
, 1. Check
✔ This constraint is defined on a column of the ta
✔ Limits the data values of variables to a specific
values based on condition.
✔ The constraint can be applied for a single colum
Integrity group of columns.
Constraint ✔ E.g. amount must be greater than 500.
2. Not null
✔ This constraint ensures that each column of
rows in the table has some value (data).
✔ Any column value cannot be NULL (empty).
Integrity constraints
Database models
E-R diagrams
Mapping cardinality
Participation Constraints
Weak entity set
Specialization
Generalization
Aggregation
E-R Diagram Example
, Database design involves understanding opera
and business needs of an organization, modelin
specified requirements, and realizing the require
using a database.
The overall database design process has to foll
Basic series of steps. The systematic process of design
Concepts database is known as design methodology.
The goal of designing a database is to produce effi
high quality, and minimum cost database.
In large organizations, database administrator (DB
responsible for designing an efficient database sys
, Integrity constraints are the set of rules impo
database to maintain quality of data.
Integrity constraints ensures that any manipulat
data does not affect the data integrity.
Integrity It secures the data management.
Constraint
Various Integrity Constraints are:
1. Check
2. Not null
3. Unique Key
4. Primary key
5. Foreign key
, 1. Check
✔ This constraint is defined on a column of the ta
✔ Limits the data values of variables to a specific
values based on condition.
✔ The constraint can be applied for a single colum
Integrity group of columns.
Constraint ✔ E.g. amount must be greater than 500.
2. Not null
✔ This constraint ensures that each column of
rows in the table has some value (data).
✔ Any column value cannot be NULL (empty).
