Constraints are rules which are enforced on data that is being entered
and prevents the user from entering invalid data into tables
The different types of constraints are:
INTRODUCTION TO DATABASE SYSTEM
INTRODUCTION TO DATABASE
(DATABASE- An organized collection of related information.)
DATABASE MANAGMENT SYSTEM is a collection of interrelated data and a set
of programs to access tho
1.) Name the main steps in database design. What is the goal of
each step? In which step is the ER model mainly used?
Following six steps are main steps in database design.
1.) Requirements Analysis: The very first step in designing a databas
The Relation Algebra and calculus
3. The RELATIONAL Algebra and Calculus
Relational databases are the most widely used databases in commercial applications like as
banking system, railway-reservation system, etc.
Relational databases are b
Security and Authorization
Database Management Systems, 3ed, R. Ramakrishnan and J. Gehrke
Introduction to DB Security
Secrecy: Users should not be able to see
things they are not supposed to.
Integrity: Users should not be able to
4.1 Tools Of Oracle
Structured Query Language(SQL): It has 9 commands which are common to
CREATE, DROP, ALTER for Tables
INSERT,UPDATE,DELETE for Records
GRANT, REVOKE for Permission
SELECT for Query
SQL*PLUS: It is extension to
Enhanced Entity Relationship (EER) Model
7. Enhanced Entity Relationship (EER) Model
The Enhanced Entity Relationship (EER) model provides certain extensions to the basic E-R
model to overcome the problems of E-R model.
The EER model inclu
Entity Relationship (ER) Model
6. Entity Relationship (ER) Model
To design and develop database for any organization, it is necessary to understand data
requirements of that organization.
The E-R model is the most widely used high-level con
Database System Architecture
2. DATABASE SYSTEM ARCHITECTURE
(The architecture of a database system is greatly influenced by the underlying
computer system on which it runs, in particular by such aspects of computer
architecture as networ