Name chancho). Clags'> Ac. Rolinn'¢ 2102915 Sechion A 4 ond Fosteign ke VS O CdlurM OA WS foreign ke pe n me Hor Saga a. Rhine Dames Column & clata KV One ue Unique data vadue » oFRo » the Potion osny key data in hey tabe Fastelgn k “ie Adgeinet fad Or rene table in selation date: st isa type of ot Pines ke v contain hee On S Mum wn table UNiquely VdentiPies gach Sok ww adhe table. Conatsroant- ny *K votue Can naebe | Qa. Explain Ent) Trego Ons Fr states anit per NUL. Q3- Wher ose DOL command? fins. DDL BS subset of SEL And a Post of DBMS DBL consists oF commands to Commands Mike CREATE, ALTER TRUNCATE and DROP. These commends ORL UXed to modify “Une table ‘ho SOL. Section’: B - G4 Explain the sin Renee in EER model oan suitable dl Ms. We think oF a se oes Farocass of Obst gmackion. Tr which Wwe Suppress the di Cod Sonne: Seek soe te identhy AHAN corntmon Leotuses” On ed Sant Ano & Single Super close % a the erignnod emting tHe end Shecio& Gulbclages Praic = Cris)Os: abate &he concept oF steFointiad Constants Gish Suitable example, Ao mms A seferantio’ integst Materia _fms- conatsaints fs also Known Osa faseiqn Constant. A Faseelgn key Ts & ke whose value ane desiived farom “the BUMcmy Re ky Ancthe table. The table Fsiom ahich the voluds cote Aestived Ty Known master @1 Tefesentiod table in Lohich Vadue ane IWSerted, According T% knousn ad child, aH Sufouncng table in other wahds, we can Soy Rhot the tale constsaining dhe Faxelgn key ts Cadted She child table, andthd table vonanaand brim oy Icey | condiotte key fs cabted the vaferanced GH Parent *tOble. Og. Whot fs DBA in DBMS ® Sxplain dhe vasiaus le of DAA. ms. Th chetrbrore envisionmant the asimon HWUSULC€ is dhe dotabaxg Waelf and the geeond Ts dhe DMG and suloted & Sranousce Oftware, admintsteiny, | cthese sissoumeas Gn dhe seaPonailal sine oh dhe 1 chotabaye odministroten . Role of a ditolore adminishrector'é 1, Databooe Back pr Fr database adninigtrocdor has ALIN to Ack eves, data to Sine abeecess oe cm is nlcasan » Xo *hok Sete con be Soe d WIR saab! Mei ty OF Ahe cota bake adrniwmisrsodanr. %, Database avaisolsi ity - A dottatoaxe admministsroca hod she ssaponsibi ai of ansusting data bare Omeedsii ity to US91 Rayon ay Ho time. %. Dotarbaie swastane’s A database adminigrrates has he RaWpONEIElTiAy GF swstasting O Hie Frog O toatkulp wrecke , Goran’ Ahete IS a Sneed Fas tk. ®: Derttike the sule of tooling: an ER-model he aksics - frs- Mobping eae | on ER AV Hagrosr convastte: model. ona « Tra ER yato toble 9 chen nalodionRute ae A ststong entity wrth only Simple oMtepuses oad SoQuised Baily one table in “Sahakions model, ¥ mire entity the Grima wey ef Aable sisi be the Y Oteute of envy set. Secton'sc - : X. Llotorotle she Struckuse of DBMS Lith Ce re ANA alto eRPladH TS Aheront componsnis. AWS. Dang ts GracuRe cathot ablows accersto doko Started Gy a Aatalooge and Pwovidas And On e054 and oPeckive murcthod Define the Wfommosion. > SMoring WAhe ivomedsion, cn Moripdtosin She ‘roform ation. > Pscrecting ie Thorn adion tom CyStemn. So Py ean posing AWARE POIMiscion Krom differedr user . DBA ee A\ pplication Paogea.m L Quarries | aptiads | ML com Filet = Dortobore Manager tr a anaget ; = Dotto A Ete] “| 6 Managed Manager : a Dots Ale + Data Bictionan eeRuled A Stovong entity ith only Simple Attitudes, WIA S1aqui sag only © @ table in” Stalation model, ottmbute 6s column of the table oid) be otto of he anvity: Tre eros Kary of the table wiih be the key Os uk aN set. employe Gettin) nome G08) [Sudenty ) Va ott bude Rule 2ir Fat Stang entity edith compost . \ odie, oF *e Cormposi te TR eae tagan Ye Aes rot of the Cownipo st he axtabute i Relf - Garand & { a GD Rod) otreetS | [Estee] fro Trare] Rowen | | “Street [oy i |eee eee. EO Q. Whar BR diagram? ERP LOIN Ai MOUMT Symbols used along ust) Suitable example ? s&s. an at swlodion ship muatiod (ER madel) descabed the. Shructubte of databoxe. Gath the help of Sragnom. which ic known axa ER Hiagqran:- Notation of €8 diagram + Symbol - Meoning: —Syrovel eee eosihy _] weak entity oe Retodionship © Tdowveh Rang Ralocionxigs =a een) Fittapusres —G> key octtdloutes Mudtivalue Atte bude Composite -Ar i bude Pevived astitute