Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Database, Database Management System, Study notes of Database Management Systems (DBMS)

This is helpful for your study purpose and you will learn good things.

Typology: Study notes

2022/2023

Available from 05/23/2024

devjyoti-roy
devjyoti-roy 🇮🇳

5 documents

1 / 11

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
(tine)wth 6they
ottfon Ihip y8s.
-uttvaluce atähctey
medel
in -he view ob- togica schent
weing symbolukituatd in DEMS, uknp
as CR Aiagg am .
.
Eectanqle- They te
Poesent in the
tepreyenti he eniny
CR Moclet,
Dacs a€e
hoving ib
Ctudent
Name
aiagu am for aétudent
totoorn ion.
Ctcdent
Td card
Card
Boan ch
(Name) rd card)
BOOK
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

Download Database, Database Management System and more Study notes Database Management Systems (DBMS) in PDF only on Docsity!

(tine)^

wth 6they

ottfon

Ihip y8s

-uttvaluce

atähctey

medel

in -he view^ o^ b-^ togica^ schent

weing symbolukituatd^

in DEMS,^ u^ knp

as CR Aiagg am.

.Eectanqle- They te

Poesent in^ the

tepreyenti he eniny

CR (^) Moclet,

Dacs a €e

hoving

ib

Ctudent

Name

aiagu am^ for^ a^ étudent

totoorn ion.

Ctcdent

Td card

Card

Boan ch

(Name) rd card)

BOOK

-CR mode) (^) Con cists c (^) hoee (^) cornponor

(D attbib^

ules

G Rslalion^ amon2^ eotities^ in^ DeMS.

D- 24/^ o3|^24

eR (^) Modcl|

Weak

-Atibute,^

letationshp.

  • compo site attibute

DeiveA

one-tu many

attoibut

  • Mutti valueg

Hany

attoi bute^

  • may
  • key^ ati

butet

1. Entityhn

be

Physical eríst^

an te,

an objech^

uitth

ba an^ Obect^ uitth^ a

-An enthy^ tyre^ hat

attihtt that^ tuique

Ret

pach ortiny

gome ontih^ yre^ eiM^ or^ uhih

Ky at^ titutes^ Cannot^

be (^) deftreA, (^) hc

enty yeas,

A comrany may^ stored^ -^ tntuomation

an (payentu ,chüda cn ,ec).

ut the^ detendent^ Aont^

have

dafen dA^ ent^

u u

entity tyee,^

and2mploye

ot be

t4enthy entity^

ype too^ det^ end

ent uckicy

  • the^ oe^ latio^ n^ chip^

hetwecn Weak

eri+y type^

an d^ tbeng enity^ yre

i4ent(y

delati onship^

and

by.dloubu.

diamohe)

comgan

Hempleye

eihbhedc(en^ den

t

d. Ataibutes.^ prapperHes h

at

-they entéty

yPe

.

deb lnes^

-he

eq- Name)^

age ,addoest

,ozl

no.

atbilh^ t es^

-that ezine^

etity

ype "Stuqont"

ne

-Tn

ocfoeiented"

the

the (^) Rmbol .oval^ (aih

os D-24|03]

Types o^ attoibutes.

attibte

the attibuti has^ unique^ idertificata

Known key attoibut

huntque tdentífleation^ oo^ each^ tudant

entty -yee.

  • In cR dieqram -e ey

attibute u oeopsentel

by an^ oval^

with

tun der^ üne^ RON^ Do.

a) composte attibute.

many

The

ttoibuts

attbibute

that Compose

ot

Compoeite

afbibut

for eq-^ 4ge at bibte^ (^

deiveq fom^

Dor)

teived

Tn ce^ diago^

am

dashe d^

oval.

Doaw a

entity type^ wsing

-types ot^

at tibutu.

foo student

ertities and^ 14ees

|9udent Infomaf

Add)

Phone nt

PonND

Gecle

LorCJ

company

CLsomer uho

ci) (State)

tcnfany |Customer

name)i

An(TAno

fA

Relatonehip palo4le

Retalien (hip (^) oepoes ents (^) e

as. (^) beucen

1eaien type -nat

between enkty yre taudent and

Tn eR^ Ataq^ am^ he^ eaion

ooescent by^

a (^) tiamond (^) and (^) cooneeti

the

LLith

students cowtse

Cntity getation^

Skip set

A Set^ ob^

oelation^

-the Same

Knoeon

octation ship^

Set,

or eg.^ the^

qiaq ram^ oefoesert^

the

Seta S,^ iu^

enooiled tn

eno|lec) in^

Ci &

(2 an^ d

Deqree

Dalation Ship^

set

The n0. ob^ dibb^ erent^

etites

faotcipating

relation thip set

hn there arc

fasticirattng in^ a^

etallon then^

t is

Called

etationthip.

Car din^ alihy^ The^

no. of^ timss^

an ertity

nity ket^

aotcipastng^

th a^ gataton

Ship ce^

& Kncwn (^) cartinatiy

retation thip^ cat

tuhen cach^ s^

in ea ch

t can taC^ part

olatins hi^ p^ hen^ -he-^ cat^ din atithy

ont tu^

and that retationship^

u na

Dne retalionuhip.

Aer Cre^

Per son^ can^ mar^ rq

lemalt person^

sViCe

verSa,

the cardtnalty

t (^) Che and the

nativn

hip

tation

Male

1 female

(one-to. Che^

catdinati^ y)

M M My (^) oelationhip

many

nelatOn Ship.

when Cngle^ enity

numbe

then -the^ candin^ atity

tha rel alion^

ship

kneh

octation8hip. Cheedert

asoáata

many

Stedent

errclein

Onetu

ceurse

candinalihy

tu -many relationhin

one gelation^ ship.

uhen multíple^ entíes^

are asoiate¢

with 21a tly^ One^ ctbe^ erihy^

set then^ the

cardinatithy^ u^ many^

one el^ ati

on

One tetationship.

Ctudent

Stucerrts (^) Can emoil^ tU^

one Gubjek

ceese

to

Onc

(art

(manyt

nali

Cmond

-to- one^

ralationship).