0 ratings0% found this document useful (0 votes) 44 views9 pagesDBMS Assignment-1
Dbms
Gkggjjjj
Ddddddddd
6ft6
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
1 DMs isa sdtuone fo
| ‘he database .
ae provides hackep and Hecour—
Sey dato even ip Ht is lost.
2. Dems is eHicenk Lo Use as
thane ane @ Wide yack ot
methods Lo sleme and nd
doto.
nieuwe,
By odean eos yoy dota ha
databae on the SQL Lor page
5. DBMS Syheo provides a
a facility.Lesser Seanthy: affou kigh ses
tees COA |g. Cody ulrakion to car, bo
4s hond W File Manas emonk Meee tn. oem
Syston. |
GQ. Doka inaniskercy is Bos We emvaiak
Keel iw the Sle Systen ee dcltse wonnnensnt
1. Ertl ATES] Nos Techacboyy (Gia
Plesk ea] as
2 AT Eherad File Spier]
Biplais detabese spen Mrchibectones
| Database Usew :-
SF Replication preqpawnes:
Pepdication preqrernss or compter prsfeniorsts whownits
ogi don Prego --Pepication Preaptanmes Con choose
mors) Keely ko deolog vse Intec
Sopkislicaked Vsens f+
| Sofisheked seu Wnkenock with the sastem withook Griti
pepien -Tatlaad thoy fewn theta nequatsinadats bose
\ey-3e
| okie Useu +:
Nakwe sew anc Hinsoplisicoked tse Pe ecko e sth lta
suyten bey ‘rwoldng one 4 the application prospranys thet have been
© amiten previous .
eerDekabese. Diirictistrston ¢
woke aM bu aching the detebose suple
= Hegieaton | Sphichiates
us calaeelll \ Useu
aa
oe) Canemidy Hie defied Ho.
Ake DML Staten to Very La 9
consis lou Leal trokmwc bow that the quency
ete fel Wkwelion complied by the DML Cong!
the stemage Sees
and cTakeqnity, Moanasant
Ankers, Conskmaitts ord checks the authorisation 4
ene <
dine Weird of Charge will tbe bnew ht: tothe database
F byis bean Completed Lotely .
allocation 4 space Bester. and tei dak:
agree information
{sin Metemd Geed ko be Cachad Ia mol
VU op main wrmemy Th is ven
he. Seok fn which -the databare can be weLose,
abo the shewrlone Are datat
a:
wags paweboay) Irons “op ucoborc
OF
rape Genean
JysIAAY | Rayna as wou —uuwpe
Soca
Monaeee gcolinn doer not bold
s
provide value fone parcticulor col
enforces 0 Coloma om set of Columns bo have
telomn Was a Unique comvbmaink Ho meany
Nomn connst have duplicate vabvas ino toble
LE STUDENT (ROULNo Cnt yor Nou
SS) Norma unl We ys STU. He, Tai
VARCHOR 135) On gue ,PRimacy Kk EY
He provide a defatk cater to 9
ucla: Provided Uhile eas &Necond
a i‘FEE WT HEFALLT to00%);
Jon specityng mons J
flodetle :Ushan this comtmaint |
ednmees Aone the Specified colenn
Ne the specified Monge.
LE stubs
Sy SpReve (ROUL-NS sen sntor NUL
ia
1s00));
wchfien each ecard I 0 Lathe 4
Be ( erok contain ott
(Rore-no)
le do. bate Wal poids Lo the
Hepee Key a ono Astle They act oyBlizns
obeah oo
Readies Sk 4 Coleen
the G
Aah ype + Goidnatcks (Nor Nutt fursia
Prine ie if Fotercm ke
we |
41 Creceal Derwa
ff entities te which anata
Mae a mi Vadton tio. Fon boinon nel Sa
Be WOPONS Airtialek sith, cl cock «
and an POM SYS cuccinted with «1
My Je PWamociahet with o,
Mi dheakyd sth ot
a
moth one
Po erbiby a Beeora be Hh od onal
: tality PAG Watetabed with an Y
snbity
one
Fun an £
wn PER ONE Gadcicted with
a
Cn orien.
ooMA ani gakion, Madi fication +
yin schema ond Phupcal = maa. sFaplion
Nhe accom bo dato ty aporting 4 av
Tnfanmation is Kept under specia
toonlted whew Someone «
ea yobs awning om the datstae |
ce is not Aeapededt by someone’