Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
An in-depth analysis of data normalization techniques and join operations in databases. It explains the three types of normalization forms (1nf, 2nf, and 3nf), their purposes, and how they improve database design. The document also discusses the different types of join operations, their uses, and the conditions under which they are applied. It further delves into the concept of dependent attributes and transitive dependencies, providing examples to clarify these concepts.
Typology: Study notes
1 / 8
This page cannot be seen from the preview
Don't miss anything!
-jein (^) u (^) an (^) opevetton Lombfnes he w Bn telated main (^) Purpese
D-22|bul D0MSthat
ot join^ o
takes fecos^ d foem tuo^ more^ lables^ in a^ datahase and eombines^ H^ tehar I, Tnner^ join
fenl 1, Tono^ join join opnatíon in D0s th at^ tombihos mere tables^ baed
have (^) matching vatuer ameng^ tables i) equi (^) join Ti) (^) Natu'bal (^) tot
i) equi^ foin
tuhich fn join^ condFion
equital^ on e^
('=") Conditton
abte-A
Vaus C
The genera)^ epottention^ o^
2re )Natur (^) a) joih
tohich
inner (^) foin (^) in wA nee d not to do any comparisi on
LThere (^) ehold be tIécst^ one Common (^) cttibut bo-tueen Stud.)Shud. Nan (^) cou (^) NOnd ad d, (^) Name Ad4. Gta^ |Pam pICD^ Lam^ Cse MecH (^) it PLA qita^ ita^ mech PLA
-h tyre^ ot^ cute^ join^ eive^ aut
NAmteen.
NamEA4d.
Pay ML
Name hym pitu O
PrD
Tn (^) but (^) butet (^) joih
hom both tabtey denot
al' thR in certed^4
rouy &
Name Ram
Add PKD O
PLA
Noomalization
Module G
Neomatigation ua^ Protes^ that^ imprevDs katabase destgn by qeneraing otelation. tha^ are^ Ot^ hiqh^ en^ nurmal^
Objecdive ; main (^) oljachive in^ norm^ alízalon Tel alion^ which
in the^ (zm^ ot^ highen^
deqrae Sequane ob^
u coniden^ as^
a weak^ normal
PCNE BOycee^ codetrNOrmal^ rurm)
ail er rips
cbnsider (^) aribute (^) a,bc (^) whore ab,bC then the un cion al dependen are transitvie, which mcans th^ at^ a c haatesthe buncional^ dopon^ deney^. hat tanitive^ y^ dependond^ on^ 'a^ through^ b. Cmp. ho^ pert^ no CXpnoS-mail peno.^ pet^ nang Detno.Dep4Name eminb4 Cmil^ bept^ no^ negt^ name
2 Patf^ a)^ aeeucenee A patial^ dependeney^
attoibwte be^
i (^) tunctfonalty^ depend^ et^
on an
cttibute when^
y a^ omponrt^ o5^ a
|ST no^ al^ (rm relation ei^ be^ a^ ist^ normay^ u it it^ contajn^ dtonitic^ value tates that^ n^ an^ attribute^ on^ an tabte Ronnot hotd mutti ple raluer and ?tmust^ hold^ enty^ on^ Cinq^ le^ Value attribuleo
-H(t noma^ orm tuhere attih ute^ on4^ mutt^
atbmic vall fus cUmpoi^ te altibute (^) and
-their eombin aton^ era^ le^ Yomoved Not INE
Ame PkD,PLA^ 41. GNE -fntit LA,^ BAM38. Keran BAM
Nam add
Aman Anicit AnxHBAm
Vatulte
norma jom -4 relation^ in^ 2hd^ normal^ or
attibute u^ fuy^ defen^ dent^ on^ cach candidte Key (te^ we^ dow^ t^ have^ any^ patial Aeen42nyt attibute
jormal, in^ the^ presenta^ o^ ony^
hansitive
bunctional 4e(en^ qen^ te
