[go: up one dir, main page]
Scribd
Upload
22 views6 pages

RDBMS Unit 1 Class Notes

The document discusses the advantages and disadvantages of Entity-Relationship (ER) models in database design, highlighting their ease of understanding and data organization benefits. It also addresses potential issues such as data loss during modeling and the complexity and costs associated with implementation. Additionally, it outlines key components of ER diagrams, including entities, attributes, and constraints that ensure data integrity and consistency.

Uploaded by

simonriley2711
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views6 pages

RDBMS Unit 1 Class Notes

The document discusses the advantages and disadvantages of Entity-Relationship (ER) models in database design, highlighting their ease of understanding and data organization benefits. It also addresses potential issues such as data loss during modeling and the complexity and costs associated with implementation. Additionally, it outlines key components of ER diagrams, including entities, attributes, and constraints that ensure data integrity and consistency.

Uploaded by

simonriley2711
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

) goect roh Product Mast

2) Select mx te) srom Product nast


s) Select Sum (ate) Tom Prodict at
Solet ouvg (rate) rom Prodct hat

* SIMPLE : Sihple to Araw ah ER diajrn


* EASY To UNDERI TAND: Tt 0s Very otical
easy to desion and
underStord
* DATA BASE TROUBLE SHop TaNG:
To sid ond resewe the key
lo9ic or) deployinent.
issue in
* VISUAL RE PR£ SENTA TToN;
Visual reptesentatjon of datbase Structur
making t easier sor Gtote holders to
wrdorStl
DsadvoNtages:
Loss os Ih
SornatiohS
While Araring an £R Mode Sohe af
the insor hnatiion Con be hid
hidden or Jost
Liited Relbtienshp:
ER nadel Can te'resent t
relatioh Shis oy Cooared to other mode,
Adatoges
* Jata orgai2atioh Orgohize and
Stormge of dato in Strutured
Mother
*Data inteority; Doto
integrity Consttt,
udh oy Coltrant oh the Valuey of data
ovd acey ContTey thot estrct who
Can
CCey the data

Concrret acen Ensure that hatiple


WsRrs Coh aceN the data without
con 6ic tig h ach other
* Jata Security : Mataihg the Secutty
of the databs

Backing up
ond re covering te data in the elent as
n6ysten Gailure.
Data Sharing: Allow
to rultiple USers
a cces an Share the data
the daba at
Sohne
X Comple xity Complex to Set up ohd

+ persorman e oerhead

offli cation.
D Cost ! The Cost af
ond aparaaing a 6Ms Con be hian

* ENterprise intathatlon
Sales, aCohting,
Hunah resour cey, ('aufoturing,onlihe rhie
University : /Moitanins the insot hation
about Stadent.

Toe coin
(tA tlCotion;
mantance Prepad,Polt Poia
COvpohents os ER D'agan
ER obl Consikt as Enti ties, Attri luby,

Databasee oystum
ER Model

ENtity Atertbutes Relationship


>Strohg Ertitykey Attlfte ohe to Ohe
bweak Ertity Pcomposite >Ohe to Mony
Attr'bute SMohy to Ohe
nlti Volued Moy to Many
Attri bute

Attrbute
what is Entity
2h
An Entity nat be on ojet with a
physica exis tenCe a
partialar
howseor enploye ~ or it nay beRrsoh an
, Cor
oljet with a Con Cep tual
existence
or oa
Uiversity CouTe
hhot is Entity Set 2.

entitles is called oh nbity Seb,


Student

Etiby TYPe

E3
Entity set
What is Attrlbute2
Attribute are the Profer bie that
o nAttributed
desthe the entity tle. Eg, Rell No ,
Nahe
Attn'bute
Canstraihts
x Cohstrants in DOMS eh omfass
rues or Corditton ogied to database dota
ansurihg dato hteIr'ty, cohsstenCy,
* Tthey desihe linitat lony ond regucteens
that data ust neet, PreVetlng the entry

ruwes 9aTNAg thebehoor od relation shp


os data n a databasey CoNthbutihg to
the matenance of accwracy ohd aey
TH of Cohstraint ih DBMs
I Jomain Constrant
* Check Constrant
Not l Cons traints
2. key Cohs tratnts

x Uniue/Cohstraiht
* forelgh tey
3. Entity INtegrity
cohstradh
CohStrants
e, Reserential INtegnty
S, Coveraint
5 Tuplo, Uhineey Coitraints

You might also like