100%(1)100% found this document useful (1 vote) 4K views21 pagesUnit 1 DBMS Aktu Notes
AKTU Dbms notes for unit 1
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
FT] Sep \2022 / ;
ite J pA Atlion who voxipus : ata Independence «
es dogqueot
€ tt “duel. | LOGreok Schema! Pryscol Dota Independomce.
sagttos Dosa, Independance = She extounoe schemes Or Vers)
asa nok sofpuctid by changes mode sin Conceptiar
Morel as Lo qicor Dater ivdeperdamce .
Physical Data Independawrer * Ability do chamge the
( schema wsithed -chongng dhs concefives,
ahema us called phyecod dota ancdependance .
when schema oat ww Lowey Leer % chonged, only
the tnahfings befioeen dis theme: ome higher
= duel seh muds ‘to be chomgedl a. DBMS
Sos fy suhhosdts Mota _smolependoner:
;
Model i nis fing fs
ne word Comaials
The -cuevubhuew mush Saath
+ Sbuivu of dhe dete
© Opurdliew en the date
© Comat stains dota .
Platina Wola Model Js based, ory abt.
Sriliday ~ Rulalioms Mod ACE-R Model). Leahrnak dovel Mutu)
Abo Vdur ef database .
-usodbes ithocent port of dhe Aatabose subvort fo cach user .
+ Comvinumcr:
» Seawdy
Conathtual dowel (Logical dsvet)
N atvadiou” the ontiow ottorbose us seen by O6A-
OvA- Dota base Adininiscatliion
Describe wshat deta is slosed in database and suldtidonshib
amerg du dota, comsbicins ow the data -
Phuysicod ox Smtomal lavel,.
How the deter ts Achuatly Abosud im she dalobase.
The Love dumeto dimplemed.ctlion detail of Reus thw cata
Js stoseds dacitbe data dbo, Ail. Shuctwrus 5
mde ond vacciuas methools used. Ay the datalose .
Relational Model
Medel swan fousposed. by €-F Codd (1940) 18M).
Ruletionot Model io based on sound mathunabical Lencfts
¢ beh thoy 5 ulations (table), & furat onder predicate Llogde, .
Koch sullotion hoy 0, nome amd set 4 atbiibuts . “och
satbioub com Lorlain only oni value. -
eg. Artist Cmamey s4car, cssunrdbuy)
Schema, af te sthoticoe CK) Aretiat
Deed
trurchow
“youd romed ov uit imve»
| Cotint ry
Tong Con | 1992 | USA,
Tee Cube | (492 | USA
india YR. tan arty [2010 | Sri sulation ¢ No toh i
Snilana A. Satine: dontint, of the salohion! dat ]
vad 0. potiontan fait fins
Ri Catlos ) aths, , as. ¥5)
Ra Cobbs 5 otttrig 5 otha)
Ra Cosby , Atlee, atbhiry )
Foumal Relotionad modu touns Sepormal. Sqpinvalyar
Ruabion
Toble i
ian Rau ov Rucord
a Column ox Fild
Magee Arity) No. f-Calunsns
Covrelimadi Nod ous
Gowan Cait) si! yal vo
Rilodien is umordeired set , thot contain tre
sufalionshil> 4 attribute that represents entitiys j
Posty. | Nome | Branch | COPA
folol x CSE [OS |? dL ahuolat Antabare domnguogy ¢
qty Systm RK prayect .
EQVEL - BAuctwad i ,
oe “onglah Gum domguags
1986 ANSI — dtamdornel fer SOL
shanclard. Js puro divatty dua
DDL (eater Uifinition demguog: | Lomguoge wae dor
Alafininng burl / schema, 2 condhoiinds .
OmL Clots. Moni furlahin donguage )
Gol erably ser to aces or
wetter s
aN
Porepolurvel Now Prrocadlunas domguac/
clamguoge Derlavafire clanguagr
Cocchi rthed you wort)
Ralionar Stgedro
SOL
Rulodhinod Cokebus.
Peocodlusvo e
sow apecfy rthot cata dy reqwud ond how
diy get dhat lata .
Non- Proceduxot domgu @ '
Maou . what dada ia oequuvud methout
shucying Roux do get dhe data. “4a *Sep 2022 tyr + eee Sues} frocuung | qa
Momanger- a
tes
Noive Moor, .
~ AMilication t
c anna ee dat | Student 5 Calms,
Phoee- Starts ;
OCkeck- Machinn 5 Car 5 Product.
event - Salk 5 Rnrwal.
Conaht - Arcoumt . :
Snbiy Sk Set fa erditis of som. Spe > that
damn Pubodis .
Attridutis Coch Cwitity ip sabreented by a oct
thew yon
oS lc) “D.0:B
| nae F< t
5 bet
Say ace a
toch mernber the det. Cann? re |
(ns fe
Altihty 7
aS
“Ovtied Mi ‘the rohae| welur Combe derived from
L Meatral shi ~youuiel,
Asrpiolion bélween one or Maye Untitin .
Dep 4 a rebateonshih, |
No. + erin fonticipasing Yin a. sulobionshif «
man RLotionshdp ,
Rela
Teynary RedMehip
Combin RU*sheb Rlakionship sofourentsd, by a, uonnnd dyimiah
Lalohiomahip Ch Cotlidlimn, of Ainmilar sulabsorshi:
erilition hone -Aiffount sob, dm dom, set.
YP Gon ep
Employee
PAu " ShhesBionath
Notation fox ER diognam
Oty
Ato
felationabips
bivks chemerts
Mutlivolued Atbubut.
Douived ftleibude
“QI OO | Surnome| D-0°8 ia)
| pal fy
| Sujor Kays Sek af atch tat aly tein ft
Lwithyn a selaton
tandote by 6 A Saf ay
Zev ex mou, atidbuty, aoncolomabe gov 2 supor Rey « {Ratt No.5 ftacthar No}
{Rall No.» dachor WoF
{ Ratt Vo. , Poul Moms} { Rall no., Suman}
Su fee beg,
Canvciolote kaxy
Svrolled Tn CRM Vo- 5 Cowrn tYo.3 Morks', sepa)
eK
Sthuntem ( Rot? Moy - — - + ---)
i
Couue Course No.5- - - 2
Course
faut Ne rete
Ro
Rs BA ‘foreign key wD a Colurnn or bmb* of Columm fr a tebe
wuxuoe vol mutt anode vatuss {a collann! anv
anothes able « :
caiapation af ony
if wey elit din. entity oe sfanbilfota al dost
Lane sWlaticonahip at » stat fstichation
|
x 8 done entities aw entity ork poorbicePecte
we ovubip the pordicipedlcon~ of culty (employ f—s Works. ory yt
oe Toto fasdiod 1
festiohation — Paxtiifcbion «
ay natok ends foie 4 Pourany
ty 4 Shing 4iidy « dacrirmindtor)
Weak owchity at a evcloby bel hat
Beiquaity sduvliby it's entifgs.
APeumany day daw ret exist fos 2 wook att.
Weak udity sd foveey conta
eee b vofrrosertid bya — Dine,
iS i i Na at | he dgmbinodon a dicmmi notes amd primary Key ie
| Ldewlihia oll enhibis qf week ends hay
| acl:
Werk entity set is olusays din Dalat fordinfabiw with
ees FP Rducdion of 6: Aegan do oulhions ( tabla) 27 CO0%n, ©
Fobb. ¢ the Table)
enclag Toble (cha Table) .
—armary Ke i |
Gefarlmnemt ( en Kontnant tal > wiasctment name) efoon 4
-K, Fk a
tng (Safle id_, rayne 5 Ohio dool Xx lol
Gog y 103
© ounctng Tle. ‘Reg Reg
Soh ausith, ~ actu, - { rotation
\ win G-
RL Studi (Retna. 5 DoB,Name)
R2 Stu Phorin CRatlno, Mabileno. )
Lamp oat
WwW
eok Weak “nitty Seb (Grirnaaykey ¢ on enlity)
Payment Cfayent. no. Sloane No.5 ate dont m ev amount )
Posthiot.
Colis orimminoctos )
3 S8_ay fe”
(b) ARCH sa)
BRC, be» a)
Pe
fx,
Ga) ARC AyQ2, be
BRC bly b2) B ~E1 Sep. 2022. q
*Germalidetion ty a purus | . sm aciabiighaon ent, |
Cxbiact vi is broken coon sty |
‘acting Lomumon, {fe Sub- enbitin base on |
ia a set 4 entitiv. and, thin, ea ‘
voi, ery /
fom,
edt bo " batten ” cule
ehich tun ot ap ihe
“neti 4am be combi dh
bo om ighes evel
Salt 4 they hove common
atbiihats!
geroralisction.
min + arround oes Tablas
Account Cacc > (nome, name, Belomee)
Sowing ( ae 5 min. O.Nourt.)
Current Cace- fe, over done daienidh) ,
Aggregation.
Bapigetian ws ued. whn we uvsomt do exfouss,
sulodionalip oumong subetiionahip -
egotkon ds om absbuodlign ushiich, sulldcerahip
ree Od po Lene
Aggugaition Ss va pouseuss ushon a sulaloeah’p
below, sn entdia condnad os 0 single
warn Shs ig iy hag alata
Sorat ohity \aeb \ ce Cemp-id > emb- name )
“Teb ea a
Borameh,(Beomeh.. id » b- nam, 4
a ;
Momogot (mgs. Ley namo.) ‘
Manages Coan. Lol. empty tit > bromehial 5
Peformance) D Everyone thos tw werOran lagiyp and Wstall Oracle datetea22.
D Toke intntlatie Rle fram loptech MrefoWan
5 wats cours at) srudents neve to Create a frejeeh Wing ‘lotional dotabar
Gnd subbriuk at with woking moder.
4 bon AprM og Acom of MOximMLM % members.
Rentify your tiple ond lacus Oct with feather.
© When yourinatailing, the defautt vacrid es Sytem ond par ured (a Syolon
Ds WW thange Hem Keop Lb a Lt w.
© Orde 10Gq tome wilh o Soinple dosolonse called TAR, To uae tha dota bow,
Wwe home to unlkck the porsiord ond st 7
@) Steps te Unlok, (Asuming asipbose ty twutoLled)
@ Shen 'o commond winslow, enter sqlplus
© tive the wmorid ord posword oo system.
You wut ge a mag ANC! connedted ts orocle .
@ SQbooller ures HA ldentified by HR account unlock
Is sal prompt enter tht Lommond))
wes Obie d i
Now We shousd tonnect to Hp dodolcase ond we ek»
3) SQ 7 connect
username? HR,
yanword 1 AR,
B® Connected
aoocaton ernpleye>
f4o seo Wy we ON conneded) i
“ypu Wu got the ShudUte g tho ’
it
eve to Ceote & 6 Hi
usmle ANE AMERY OHA Jefe whe pode,
fy Ow atigee NSE gO va
caw esfo Mag, out ule
Bw dou hs
lo. Brwd be o UO procs toby.
panenhnnnononoogonasaonprreoraenraeeraanagns
