0% found this document useful (0 votes)
7 views6 pagesDBMS Assignment 1
DBMS ASSIGNMENT
Uploaded by
Krishna's Study VideosCopyright
© © 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
0% found this document useful (0 votes)
7 views6 pagesDBMS Assignment 1
DBMS ASSIGNMENT
Uploaded by
Krishna's Study VideosCopyright
© © 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
®
Assignment Ap
OW4 hot on neimel forms Lh ode!
obese Me ige Ciae on scmbll a
Arai Nownol foonts im _dolabese moragemodt art rules used to
Houckve sutlo\tonot sulotorol daksboses to yuduiee stad rdoncy
4 lars data miepuly + They emu? dole o legicolly
Boud 2 avetd oncmalia dwwomg cpwotions o Libr inh,
updole £ doble- ; ,
> Tripeitan of Nowa fom
4) Reducss doke Redurrdiarcy ~ Preven
im mullipe plow .
2) Bevests Arorolis — Avsids updale, impuion 2 dilaton anamoliss
3) Teproves dale intepaly. ~ Erause dala bs accusale and toxsistert
3) EPinige Ouvey fodoruranct Moles ‘datdese Abuickwee mor
cient « ia? '
—> Types of Nowmal foots. 0.
dD) Eoul Normal fons CiN€)
© A toby mw mm ANE AE Te
= AM cba “contain | emly atomic Vodur
>No oH auiays Ve “
Example CBsforo Ree “hd paws’
Student CID , Nome , Cowese) ue
4, Raj, (Math , Science)
4 Her Cows Contain multiple
( 4N0) :
Student CID, Nome , Cowee)
4, Ro » Math
4, Ray, dena
ts btourg Hu bono dota
a ' D econ Normal fox (2Ne)
A table isin 2ne gq :
- th ib in ANE 5
mM non Keay atbuilete one fully deperdont er . the parroy
4
Example CBefexa an phivrat
Student Cowes CID, Cowes , Tnsbuicte)
AF Tf Sratsmoter depends only on Cowse , net or D1 Gwe
Loutallly deperdoney exisd
Afi INF:
+ Bput inks *
student CID, Comm)
Course Tasburetor CCowee jTasburctoO
3B) Trind Newmot foun (SND
<0 debe win BNE 4
Th pm 2NF
‘Thea ono Ayransitve deberdancy : } =
example (Before SNE) )
Bludent CID , Nome, Dept, Depl— HOD)
He debt HOD. deberds on Dept not dinectty entD
Aifjter SNF ’
Student CLD , Nome, Det
‘Department CDept , Dept _ oD)
E)Boyce- dd Newrol form ceenf)
A Stren Veaion of ONF
An pin Bene A”
+ fer every functen debendoney A~ ¢ Roya
Dojo Rey - ®
OW2 Updle 0 Shot
a) 30, ty patie” ios MyS8L Go) SOL Sewer (©) oracle
Bns2 (0) MySOL Tis mm a Vey pobulax , oben ~ Sowior datobese
Ayslem «TB Commonly used pc Whabstle Qnd online cation
Many Jilee i beara“ Lecause it fpr to, use om
Nexy rubtoble .94 2 rointained by oxacle -
) S0L sous This DP dotebao dyskm fucked 'by Mioiescft «St 4
tuidely Used tyr lage Companies foot managng Yousteass data. 44. i
Rnewn fox Laing Very Awe £ frouunfle > | $
© Grade paw b. poumpull and very dxpensite dotelase
Aaglem Tk Wed by the Ulorid’s biggn Com aan fer
Arondling huge amount of, dada: 34 Rroun for Us hgh
beifonmane & ubobibly :
WWDBe + “Thos pa, dalabade byplem of om. Tt b oplen
Used tm lange scale business “abplicatiors andor ratmporanae
Compute Sh is colic, Renuin for vs sbieng poffomana
& raliabibity - ie 7 o
3) Abimastiengs_ Arion = Poamabion’s frien oe a Sed of rule used in dafebade
design . They Aulp w figuee od nou satationshi belupm data Whom *
We abwody Jenoun Barre . Wer odes used +0. pirol ol the
pprctionad dsberdonelss dn Adaleabose. | ° js
5 Raploaively > Th you Fave hk of atbebules , then Hot
Ack doletmins any of th dubadd «
aliudele dred dcbomne
3) Roig mentation 2 th you Irauo a det of
avotwe ; then Bae atbéluds -b loot Aida doan't Chango DBrovutvify : Tf, one of olbsibubs, detsvonme 9 Ateond Jet & ths
otond ot dahammnes a toad , dh the foo! bat dleloimi no
a Mwud » don to fost od daterwninas the doucl -
Ou Exbbin in dela about Ihe Cones of Gun
briocwasiicg a 4 optimygation . i , a
ned — Ounry Joioenstrg ib ous a dolalase managment Ayslem
(DBM) rtanalloles Q Udo. OUBIY trio a Apu of
avalon trod Can be execttecl to agh re darirod
puosth - Ousry @blimzation & a Curtal part of Hus
Prowsd , Uthow tho, DBMS Choose tho most efficiert Hoy to
sun Mo qysey qumty to yoduced d4me ZL, exoutend -
> Ousry Jroaxing iSlages
Ouory frccaring tnvolus Hue main Ateges
“Paring, £ aviation, The pb the bust Ble Udtune the
DBMS ‘analyze the Oury Sung Bubmy Hed ey the Uwe +
Th Cheda fo Ayrrtox LIOS 2 Aonanic wus —”
. plimzation + THD 2 Pe Core of Miclerd Query execution
The ple tele Woe GURY tou2 2 Cansidye multiple
ar arible way ot “execution plans’, to cor ne
Foul ole ay ot exon tl ebb
“tyolualien’ Ln feta fino! Hage; tre chataboue 2gihe wcsoitlto
He Cheosen oplimged plan, 4 pexporm the Wy aical
apurotion Ao ratoaved, he dota, from He Alorge,
Bevicis Gnd Wk Bro reduth “to co Ubr. if ®
UY What jp te Yorn What Qe Ha main type Jorn
@ lawn With example
A JOIN “Ba fandamentat afouta Hom mm SOL thot
red = xoULd om wo ot moa table bared on O°
lated
