PANSKURA BANAMAL| COLLEGE (AUTONOMOUS) INTERNAL ASSESSMENT-2021, Cover Page of the A [a Name of the Examinations 2. | Candidato’s Name: (3. | Candidate's ClassRollNo: | 7) ¢ je femamnes 1 OL ay 00 204 Pelee Compubnr.. Sctenee eee Dababase Managem ea 7. | Paper Code: Ccloyt Unit: @.__| Bate of amination: $o/ 06] 203-1 as 2. Reg nowy 2O19PBL 00349 For Examiner's Use: Question No. Marks Obtained. Instructions to the students:- ‘students use this cover Page forall the papers and units preferably. Use separate cover page for separate paper. ‘The above required detalls should be filed in hand written. Put the page number In each sheet properly. For uploading the answer seript (Contalning all the pages n proper order) should be scanned In Pdf format and the sizeof the scanned copy must be kept minimum with good clarity as there willbe a limit of upload sie, Student should get the print out of this blank cover page (In Ad size only) and can make the required number of photocopies ofthe page's. Start writing your answer from below the dotted line, hey > A foreign bey t5 a column om group 4. Columns An a, Aelakion al dakabase beable thab providles o bink bebureen doko dn bow hables, SE achs as a crag: @)_ Nefotence ~ bebaten tables because it Dedfecherces be PMrromy key of onabhen— foble , bhoeby ebablishing Uses * (F) Linking bbe attrilide of bute a 7 beg dha. wich ehe hrelp ofp primary bey Exempl e* Sn the blow fq yeu Can vateer bbe —— 7 ng Dk ruebude of pdeblanshep 0 Wu real: Primary ley : Depatmet? fom Che tone 08] a 4114 LAD {t/ RL AQ (b) Nomelizabion 27 Normalizabion Ysa process | of ongoing data indobebase Le avail aba redundancy» jnsabion. anomaly, up dake Grom al yee duction anomaly + o bb divides the lang a fable nko the Smalhy, Fable and Links ee ye Adahvonahin, Gh is proces of Hy aing data ifs Gs famed as Conant cod Sybheary by He expats.: z2 Hare Gb ow disk f- af tlh f~ Kn 7 S @ INF @rwF ti 3KF (7 BOWE O4 VE ) snr Gi) SyF © Mews cs Morr EE no of volucd o chity y Conneded f, no of Values a Thac ore 4 Lype af- netng i, DBAS ) One ke o One C44) 2 th one anath. aA Coty. on Thy is connedhed Fe one SF ; | pluded hes one thrid Connecbed lew many Er: & Po bee pryve be dex ic Mery Fe 078 one (N: i: 4) > /ag- y necerd 5 aed to One Recess an i phudet ae per Same Wag Bx. ren (2 many to! pranl Min): wang Decade Toone bed 1 bg 17-977 ewsdS - custome Can purl tte Vee ong dn3 (Oia SES Whaat jen isan jandd Jain bhal- nck urna hhe valuca dp Lhe date Lables bhe batts a a Common. ab-Di-b ube. bal hes the ome name. and dam aly , oo Sa any Compas on. aporabeh. + Sb abso Jemoves bhe duplicate att ribube prom Lhe hes » SF Can be an Inndid ain Leff cuba. ee ee Adpault US Annirn goin. a |. ta Sek prom emplyce Vaboal Sein dpe Ro _| Nene 1 kab an 5 |shle Scledt # Prom Shidet S Notwtal goin Marks 1; ofp- Poll Name | Mod keobuy | 20 an§, bhis Con cephual Schema Can nal be changed (uibhouk Hanging ik Abrudode | aE q © Physical doko Lo gical daha Andyprderea In o £ se cr Conceptual Schema Can pecan ged Wt the uf- changing ibs Shruckube. dence an gptuch and cutonel be cone GE onl prddes peechin Teeny pots © indipend J prebslin| Fo application. Phagran. Scher a) Modificabien ane done to Jmprave Pafermert [rodpolion one one | haage Shu chire , ib JS caby fo pebnieve Fis dijpeuh Jo jrebwe ve G Exon . change An. Compson Hechnig ueay parking algoribbnebe Ex- Add / Modif. ah delete (weety att Mbube :| a 5 b DBMS RDBMS b ji | SF afd p> Dob SE sfonde EX 780 | Management System | Pebalian af ate M 4 / 7 Manag emer Sy-shem | pala | Pola ts AP ured at | Data id Atored as Sforaye a [ite- Kabls. [ota echdabe clomeds | rultile debe hook hee | as bo be ACCMedA| Con be decesye of oF individually ee Raoheol There iS no dcladin- | Duka ls PresaF in Shp Ahip between daha [muthiole fables which. Con be Ndaked te dn DBMS on a Noma-| Nermalizalion Can Nahmaleabio Can he Lzobion| gf be. atverrd ahveed. ae DBMS has no 3 DBMS Supports bube stall isbrib ute polabasy f-™ dishribuked dobsbase| Uirtubuted abrboases poka | DBMS deals wibkh. RDBMS ‘heals wikh lige gporth| sm alk ag rantily of-dake quantity of- daha.DBms DBMS aa clledion of Kaka «$0 PBMS, phe ws IS nak Peguthed Leo wathe bhe precede @ File Syabem Fille System ee of- datr . in the System bhe ws has to write atedwr4 be Necyt @ Data Tapornabien 7 Defi | Dake is wrrdfineel inform ation. 15 bhe notien| Lacks and figured ubp uf ocesse ree 7 Jape ee af pr css Ad Chada-| Dota 13 0 dndivilual | Anfpermebion 45 the predea choise unit Wide Conbaias an upp of, data uni nau matdial anddosnal Calle. rily COMY a daghcal cay meaning Mending. Deped- Sh hoes nat deper Sf pelies on Aoka, ce | inpamabon. reall \/ag ue Apeupic ny d M cas uyi Measured dn bits Meosubed dn meaningful agit] nid bytes wits dike bimes guackity Lad | SF is fowkod | SFB tad lenowded ae. devil of leng whde decision Dada does nat . bn cdmohion. de bby fnalang dideeHy dps 40 A helps in deen malig8 8@ Frag mertabien 2s | fee ae of 7 be deblosc ide Bmore mualbaple pos iA Called as Progr Li, These pragnets may be Ahaled atdilferd Lecabions. cabatlon. process Medel i a a Ph a thay Kab the 6 On i Jragments w ponible, frdvastag : ow) effi dency ot, eye DU aie ease ol 7 (ip Security and piveey Con be Rees taht alee Disadvatag a (0) The job af Aecombrucklon. TiitKneed cupensive technic. ip) When date Prom bf] rf pragmet che Peguthed, Access Apeeds may bhigh o St can be of Pree types () hXizerd al doned (i) vakicah a () 4H yb dl (heveenbed Vocal | an2 @) 0) Condibion Fa pvp sy Mv D. Atands por Muh valucd deprdes, Sn DBMS & foble is defined to breled When the below malthivalu cd Depen deaucs Conditions ae Aohisfical ; > fp the i) Fon a depardery XY only Value af x5 pany valucd PB ocews fen the babe my ald m uthivadrcod dhependen cy: pesids a table should Jnolacle ob) Column fr tf te have je Gin) Finally Poa Pebe ROX YY. a mya bebween- Xard ¥. So Y and Z shovld have +e be ind pede cade abba. Ths When ath these abive Condidi are Aabisficd fo ary Peloton ing abl * a Meee are aro Ti aed dpa dency . bhae ewAbs 4bbe Locking prohecals are wed dr database management byatems as a mean of Concumenty Combet, Mulhiple Prardackions may nrequcab a Lok on a data bem Kimble Bude & mechanism is Called as Loch -Manag d Gp pecs on bhe proces df-MewBoge poring hon. ond L& manag crchan be eee ; messaged bo pardle Ges lodeing and halo dermg of, defer ikem Ladoceck Sequential fie Fe> Indesed "acl 15 Tcaph opie Halon ino file can be organized ¢ pabhr> than Ce ingle dened file Bhhuctene, SE hos many i mplemetebion u A pecor dd ae Ahered ra) dequerbl of rv dn. Ndvackags 9=> ae aa: . C) Vay djadiv Sample od clear Shrabeg y Gir) Lib. Sepbde Suppo Deguadeda \@ Mabe rage BpAle Dedoudles Disadvalsgs () pypieut Fe adhat, medif y od updohe () Due + nabwre of be formal oe the Command 2 Deguibe eo Dewrihing alk ples afr ve one. (i) § Can not acces Darden, [les