Scribd
Upload
6 views97 pages

Computer Science Solution GradeXII

The document is a solution manual for Grade XII Computer Science, containing model questions and answers from the year 2078. It covers various topics including software process models, data manipulation language (DML) commands, object-oriented programming (OOP) principles, and database normalization. Additionally, it discusses recent trends in technology and provides examples and explanations for key concepts in computer science.

Uploaded by

samratdark64
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
6 views97 pages

Computer Science Solution GradeXII

The document is a solution manual for Grade XII Computer Science, containing model questions and answers from the year 2078. It covers various topics including software process models, data manipulation language (DML) commands, object-oriented programming (OOP) principles, and database normalization. Additionally, it discusses recent trends in technology and provides examples and explanations for key concepts in computer science.

Uploaded by

samratdark64
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
Gram | ek eda ee) DS SOLUTION MANUAL COMPUTER SCIENCE Grade XII AO ate ey Contents 1 Model Questons-Aniwers (2078) Si NN ued “AN a? ee ‘outa 6 Software Process Model A COMPLETE NEB SOLUTION MANUAL COMPUTER SCIENCE cor Recent Tendsin Technology © Physics Prodigy teddy ASTHANIONE PTAC. “16 ui 18 ” Model Questions-Answers (2078) eee tae compre at Casa 2 Sean pgnmes Tee RAN ar TS Samal peor Se mimes § BE saumameeemmane © Eatecsnamentmemens ‘Tt tte he erect eye pay "Say Saw a we BO insert Ese sy 1 eeeaysin 2 ns i Se Whats eum of rT wie ‘Sau crawars any fra ae, pete ody iersearauonae “TW thee iecoredaawcme SOT fan ein Oy eraser sa un Teng ern 9 f tteewen ary ose See aim Why cout cenpun popu eras? 2 Renin osace i tonnes re ee oe Hasan a SP so wet lean Satna be poe of acanpe = ee ee SORENESS 10 Sees wi pres Ce Stel yaar aneroe ssn era form 2M ‘nasi em rm 8 ‘het eer apt ee p07 ‘Reperonol 2M ie cipro Tovape ease nyo fom ad ig ch atetein thy ene ue [ae = Ran xt__| Math = ee 2 es nae fl [tt | as LS a Waar In he above tte 1 he pinay hay te combination of RILN® + Ch, The depron tar tnt on iru ‘Name depen on Rll No apd Case Subj depen an Clas Yoon RL NO Maa dap on Sabetard Nene. Sete above acne dacopaned in he allowing Be “bled Sadek Rolle Ta ‘Sabi Sor co Sabet co Ram Tog a Te oy = am Tia @ Ti gis aa aa) Tid Conpuier = ‘rd Normal Form ON ‘Alton ad bein he hd nem farm iti thes nn frm and does ot coin ay rave dependency om the pear hey. A atts tat a8 ot eendetupn h prtay hay, be inne. A site depenny te oe int ang 3 atin A Band CAB, Bo then CA, wlan the SNF ‘should at conan tae depen or abn ve ‘Thesbove table canbe pst BNF abel Table Sede Tae Rai Tie See Dene si ML stmt ih a ape “De DML command in DML ie an stievaton of Dit Maplaton Lange ngs th ate pe inte SO tn Ts lngnge 8 espns ol fr sin eietcr nate te mec re oa ep dd ‘Stings om te dase wang comma The DAL ectone/SOL eit olloningaset ofconmands INSERT Command. + UPDATE Command. DELETE Command INSERT sans inpvat dla maipalion come n SOL, which lows ‘vet dats in cate en ‘Sha INSERT Coma INSERT INTO TABLE NAME (colunn_Nane, luna cums Name, ctu NaneN) VALUES (ravers 2 vale 3, ale N) ‘sample INSERT INTO Suet Sa Name SMa, Su Age) VALUES 04, Anna 89 2 SHLECT DMI Command SELECT mat inn mripion cman i SL. The SLE ‘emma the eas of th pc eae shows he para eet rc clun by sng th WHERE dase Syncaf SELECT DML comma. SELECT [Link]}, column Name, How colarn Nane J, coun Nan 2c Name Nate a ‘plein wie date wane fon eae Me name ITE eee the dats mall he clus of he il, we have to we ‘ohume. Name N ROM ramp SELECT" FROM Stdene Ie he aes fn clu om the ie "ample SELECT Emp np. Suey FROM Emo ade alte vas ofp Sy and Emp clump at ‘ample SELECT FROM Stent WHERESa. Mars “20, eee athe ead of thst who mark irom he ale Stade LUPDATEis anther ipo in maniuitioncmaand in SOL whic allows wero ‘pln or moe ting dtnin dane Sj of UPDATE Command UPDATE Tile SET (clumn_paeel= noe "ere" UPDATE, SET, an WHERE we he SOL eon and Toe name' the nase ft ate whore yl ou want opdne ‘ample: UPDATE Pet SE Prac re = 8 WHERE Produc M=PI02 plates the Prot Pea the profit whove Profuc Jd PIZ 8) clue. sae = valve NI DELETE es DML command which allows OL se toremor single male exising ‘This command of Data Manipulation Langue dow not dete the store ate permed om he tte, We oe the WHERE ns with ha DELETE comand 9 acters rom th ble Syst DELETE Comnund DELETE FROM Tate Name WHERE condor, ‘sample: DELETE FROM Prodct WHERE Product 4= Ft? delat the prada he ible adc whe Pot iat ‘Wit fincono a any wo umes ner Suma mo uber sing etn sft Phen Sly ape funtion fi seems ‘err vr {sda nantes utopian at te sto umd-parseltpremp tr te seo ae smn nun // py he a acute The sans} , 200. 1/tnton Spang > wid ming ( Iota 0) isc _eetiaiss) ( rite te ember an Anan: 1 ser oroagit) i © erpayan) cccaean tne ( oun) ‘eapeneh sero un se ny The sre in_ seeding ordre Foret ati) C pn tld , eh: eS ee sot cert om ay ade, oF Wie prog ret hema ny Satan ee eps ant vest mi nite he masafatden ean ac 1 fords) t ‘oakG>aedons=20) 1 "1 ri Ttal umber of pte dene hand fl eee , cHaeTeR Pee ee) V ERERRTERIN Wachee ace cess? ‘TRIMER Wr $0, tow co you sett me wen Fam a ene VE ‘rete vae eh curate a-COC7 1 Seen eben thE ‘T MNRRRNR Aca eo ny en pre neve aod ER ety Frac Gate Soot da yp oe ame DBI, noe! Ouse Noes Sitar yg tg Remar det cena neti ee 1 Ere any toring at HP RUMEN oiine cea nd avoaed amen ————* ‘costed dats yee «typ of datos ta sre snd inne ao 2 singleton nd its oti and managed ram ht aon ley hares he sited tbe yt can soe inn dt oly and marae om tient SN | Concnned aioe Dineiaed aaaooe sig ncn (08) may be ale w conte © Provide he seins Tigh kof bat taing Ths aaubwe vey High =< Soak oe ae Ska rate for storing mxultianedia and tval OE eee «EET ep ens SS See ee eee Sas Tea Saar an leet oe eee ae oe son = a fe fT 7 ais cane aan | Bags oT ane Einpcoeee |e ee oe wl pero eto Se nt 2 a of DENS ee Fontes) sas Oe fen eae er abe nec communist oltre or oy he ben E SS aS iy Nectar case ime seg = a _F 1 ok eee ata tm Syne yra daca oan esting te SS eS SS IESE Sch i ule we wat aw coum fF COPA. The {ROR thiscommar suse ord an eg te song wih is Sym satan ample the allege Anhcy wan As change hie Date by etig a atin te papas rem oe STE Puposs of Nomaiaton| The pps ct data narmaaaton spac pr athe na nema ew soit unstable tang: such a potion of hioruton, tab npoet ormaon. and awe iomation I inprver pecsomance by mo ‘lunliny ealageeveet lepton dan tein mir ie and mae eRe Ame aeRO Second Newmal Form NP, aa Atal sin 2NF nly Xf son i NE "Now, the relation isn 2nd Normal form of Database Normalization . ‘Nab ay pene pr a a ‘leperesces oh primary ays El Pa Siento oecancone- aml) = = sees 1 ie Poe = a a See 1D SCID] Se Rame [PO = Fat ‘eet — [aaa a Des = SS = Ba et com atom = Bap Se Taran cond om es =e a Aree ae epoca mos ore Don ot 1a ne pee webu ie Stdet Name and Poe Name soni SARS Se clint Necronomicron ai ap a seein Name can be deta by Project, which mic te wlio Fall Data Model Depend atid a enn ae csi te acta of» dale Dat mal coacton fconean Therlre, the + Raa mel ana ierarcial Made Wisteria ig dash med ie eda pt se inca act Basel nde A uc dn ae er et smote child nodes, However, a child node can have only one oneet ‘represent many to many rulatorships. re 1 Daca ater a ‘sence es - oe {hiner se loveoncor mre rs male oteishnown Jest. vente Sn 1 than ets ny catioship ding many many + ttecompen ta dsgn eo mule poiter + theamot reper compe dat elation Database Mel Pre dupa (ty-elatosip dram) doing er dering ELSir SOO tc wanna res ati, tt SeepSin nay tts ues penal oy Ditecr yao sed a ER copa : Petco pny die, Any canbe pen Spee aa ana 2 onal epee tue ofa ty. An ae te opr SorecED Sey. cat ancy reson va wth died ts, sans pry ace (parry bey mary al yc dor doa Dano reper even te ene 5 —— ee wd ome te gl ey ly ad “6 DNR an safes Kania athe Adminstrator ‘A Daa Ans (084 pon pon fi making tp potey acne rearing dts td the ets el cing a ope ‘the, D8A prvi neces eg na spp fore peace sdeoneling aoe oan Aoleand Reporter of» Database Adinitator Thee ad rsp deb wns ae Deni he nal ihe DAA i pone or ding hw the dt sw te scram in he meno, the pan oan eps ro = Deg tb he dng a anya > Monti he peromane ofthe ahs D8A must mane eoman he dct th teen ropa ay pcan be ea ‘+ Ungaig the dae and oven DAA Sad wppae he ia tv tononms ured) ergata a Dining cup and over ped DEA ms eis soy poe fe ef ely on ma eee rene grees ee eee Titties cut orate 5 Denn scythe as nthe date: DB rap i fing cen bc fr ono te pt aed Ca BBN eee Ferment tr searing ery eo >, Leming cont: DBA must pgrde n/t etany api new sate Sout dae, BUS, scutes ce ‘7 AREER esi, ad NF eran ene dbs aR Norman he poe of baking dwn omple a arg ble lation to athe ut le sed Yee pon of at sy fede 1 Rec data addr an watg tre + Remove inns tate + Simpy the sutras nd math date operon ee. veld ef dt mh tase co item fit Nel oe) 1 Sond Neo em NF {Th Noma! arm BNA = {hmm om acai A ‘et Normal Ferm a utero 08 a sca aon ol 2 Pe ou ot conan ett pl cn _ Tale Noma orm BN Atte oa ition ss ob in 3, in 2NF and sive dependency dou ‘est Evry non hy aie sol note tart depen one pinay Te Convert teen 2NFns INF, the on heya wich ne ely depend nthe rimay kay mint bedecompond ns apa tle i ‘ait =a seen at na tom : pa to cmv he tle no IN, ers Hi occa = z eee : = Eee ae te So) | cams iv apaene toma ons eee A ene Seen aoe eee oth tomen > Terps na om nl many nd ng soi orate in 2NE, i a XN and ech om yaa iy pen ihe pura of INF Is i ae ea Te tomer teen INF nn ANF. hen ey a para eden To ers ble NF IS aca dependent pray hey ae desompone n 4+ hspim inline fhe and th datas + nape proe the pomanc athe dre + sipping ination "eb nding the dbz at anette wi’ agement or acing requiem 7 nah EA copa IE a eer aA SeICGN 20 RSNESEREIREORS ose araieaion moans? Relerb a7 SHON » aia eae OORT Egan a erin ASC ONO 10 as (Data a fn opating sabe, 9 Sect SQL eve My SL ASA Frenette Tens ater ee a soe a ger geet Tinea Tages [ERIN cm seep ose OS, unter sa cons daar. fs lt na Gam ats est can be msn] ST onesies and vais er cecing meh, ‘edcngeses wing cation SQ Din prof Data ney in DBMS ile ype of ta neg Engine 4 Doin itgty ‘Retr egy ying ents at ld ed ws pinay Key dost ave NULL nie Spy ya ty ig at ore one Dem nya a i pov i ft wt he we url egy ese tah veo ely shold hae hig si pie Seen ay sew at wa als SL Des DIL wih ow wae sat 15Q) sands for Susur Quay Languge ta dais langue wad forcing ‘Seoging and peg daar Was nd ely m DM: bt a rent Cool fn DDL and DML. SQL allows the wr To retove dats rom the ease “bout herng ised norman abot he Sucre of the data bat ‘DML (Data Manion Languagy i data languge wel for database operons Pakoninuring mesg updating let dt DML art te pes Prcedaral DhfLand Dasaratee DML. DML inde start elec to tee eg ta 1 apt lomo te cxting at 1 ctr remove he opie Seon SLECTSt st anes. FROM tino Fis as mode Baha sel Database Mode Tele 20SACONo.S Slaton Mode lero 208 GIES ALND 10 Eine tage Doone napa Sam a Database ans eth clacton read da. he aon a fr toring at Brame Slant nd scouting rere IMS ued for crevtng managing Abd PSN Abe leased for dan operation nd aplaons Adsotage of Daabse Mangement Sten ‘vantage of Dts nanapemert ten ae 4. Redundancy con bred Th uf DBM ees redundancy. Redundancy {othe depo dna dat sree thane latan The reduce ena ee 1 Maine waste of stonge 1 Eaceree an nip oft 1 Gonfingemescan beavoel 2 Imanaeny cam be weed Reduced fanny resin voting ncn tat ‘ants ensures tha he ae aay increta tate yaaa ance nin Oy 2 Sundar ca be nore DS TE ee ete sy ace) > ey oe ering pst een 4 ep conte mini OS cee =e coo + Sinan wae eppee

You might also like