
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

IGNOU UNIVERSITY MCA - I (SEM 2) JUN 2009 : Database Management Systems

6 pages, 28 questions, 0 questions with responses, 0 total responses,

	mca_india	+Fave Message
	Profile Timeline Uploads Q & A

Home > mca_india >

Formatting page ...

M CA ( Revised) Term-End E xamination rl |une, 2A09 sf cf) C\I MCS-023: D ATABASE M ANAGEMENT s{ SYSTEMS Time : 3 h ours Note : Maximum M arks : 1-00 (VVeightage5%) 7 n Q uestion umber1 i s c ompulsory.A ttempta ny t hree n"* fu ,rtt. 'I,,. ( u) _ E xplain t he a nomaliest hat m ay o ccur w hen 4 the t wo i ntegrity r ules a re v iolated. (b) F or e acho f t he f ollowing r ows, s tatew hich if a ny, o f t he i ntegrity r ules a re v iolated 5 when t hey a re a dded t o t he s ales-order relation g iven b elow : (i) < 0 14,1 /1/91, C 45 > (it < 0 L5,1 ,/4/90, n ull > (iir) < 0 '16,2 /4/92, C SZ> (i") < 0 17,n ull, n ull > (") < n ull, l /1,/9I, C 45 > . Customer CNo c45 c46 MCS.O23 Name Address Delhi Boys Gtuls Faridabad P.T.O. Sales- O rder Date Order_No C_No 011 1 / 7/ 8 s c45 01,2 013 r / 8/ Be Null 2 / 5/ 8 8 7/ 7 / 8 e c46 c45 014 ( .) Consider t he f ollowing d atabases cheme EMPLOYEE ( EMP_NO, N AME, A CE, DcPT_No) DEPARTMENT Designation) ( DEPT_NO, N AME, EMPLOYEE_TELEPHONE( EMP_NO, DEPT_NO, E XTENSION) Specify t he f ollowing q ueries u sing t he relational a lgebra o perators. (i) R etrieve d etails o f e mployees w ho share t he t elephone e xtension 1 23. (iil R etrieve t he n ames o f e mployee w ho are w orking a s R eadersi n m echanical engineering d epartment h aving a ge above 4 0. (iii) (i") (d) MCS-023 R etrievet he d etailso f e mployeesw ho are o f t he s amea ge a s e mployeeE L. R etrieved etailso f d epartmentw ithout a p rofessor. Expresst he a boveq ueriesu sing S QL f or t he same d atabases chemeg iven i n Q .1 ( c) . ( b) What a re t he p roblems e ncountered w ith concurrent t ransactions ? E xplain t hrough examples. (.) W hen i s i t u seful t o h ave r eplication o r fragmentation o f d ata i n d istributed database? E xplain. c. (u) Identify t he f unctional d ependencies hich w hold f or t he f ollowing r elation : Brand Size Price Manufacturer S1 S2 S1 S3 S4 P1 P2 P3 P4 P5 P6 M1 M1 M1 M1 M2 }/L2 name B1 B1 B2 82 B3 B3 S5 (b) E xplain h ow B -Tree i ndexes a re d ifferent from B inary s earcht ree i ndexes. (.) D efine p rimary k ey, s uper k ey, c andidate key and foreign kuy. (d) E xplain t he i mportant c omponents o f database m anager w ith t he h elp o f a diagram. -oOo- MCS-023 6 ( ") Define 3 NF, e xplain w hy t he f ollowing EMPLOYEEr elation d oes n ot s atisfy 3 NFDecompose r elation E MPLOYEE i nto relations w hich s atisfi es 3 NF. I s t he ? decompositionl ossless | ustify. 1 +3+3+2-9 EMPLOYEE EMP-NO NAME ADDRESSDEPARTMENT DEPART_MANAGER E1 D1 A1 N1 Ei E1 D1 A2 N2 E2 Ei D1 A2 N1 E3 E9 D2 A3 N3 E4 E9 D2 A4 N4 E9 (f) Answer t he f ollowing q uestions: (0 (ii) MCS-023 What are the purposesof multi-key file organisation ? (ir) (u) W hat i s d ata i ndependence? (iit) 2. W hat e ffect d oes a R OLLBACK instruction h ave ? G ive t wo r easonsf or n ot d istributing a d atabase. F or t he r elation, E mployee,D epartmenta nd p Employee-Extension erform t he f ollowing operation a nd s how t he r esulting r elation. (r) (i0 (iit) (tD Projectemployee Extension ON office, Extension E mployee l Jnion < E 4, 2 22, N 4, D 4 > loin Employee and Department P roject E mptoyee-Extension O N Emp- No) ( Intersect ProiectemployeeON Emp No) Employee Emp-No ename NL E1 N1 E2 N2 E3 N3 E5 Dept-Nc D1. DL D2 D3 Employee - Extension Ext. Office Emp-No E1 E1 E2 E3 E5 01 02 03 04 04 EXT 1 EXT 2 EXT 3 EXT 4 EXT 4 Department Dept-No dname Manager D1 D2 D3 MCS-023 DN1 DN2 DN3 E1 E2 E5 P.T.O. (b) (.) 3. E xplain t he t wo s chemes o a void d eadlock t through e xamples. E xplain t he A CID p roperties w ith t he h elp of a n e xample. Differentiate between the followings : (a) S erial S chedulea nd s erializables chedule (b) P hysicald ata i ndependence nd l ogical d ata a 2A independence (.) (d) (") 4. (u) G lobal a nd l ocal t ransaction R elational A lgebra a nd S QL G eneralizationand S pecialization. C onsider t he f ollowing s tatement : "CustomerN o C 1 R am N arayan h as p laced order number N1 for seven pairs of shoes, product N o P rat R s 1 000/- e ach.T he o rder was p laced t hrough S hyam N arayan, S ales person 51 through the Delhi office, on IS/ 5/200A.E acho rder m ay o nly b e f or a s ingle product t ype a nd t he p rice i s n egotiableo n an o rder b y o rder b asis. A s alesp erson m ay be a ssignedt o a s pecifics aleso ffice, b ut n ot to s pecific c ustomers. A lso, s ome salespersons ork i ndependently a nd d eal w directly w ith h eadoffice, r ather t han through a s aleso ffice". Identify the following : (i) Entities with their attributes (i0 Relationships among entitles MCS-023 4 4 P.T.O.

Formatting page ...

Additional Info : Mca - I (sem 2) June 2009 Question Paper - Database Management Systems (Revised Course)
Tags : mca exam papers, mca question papers, ignou mca question papers, ptu mca question papers, mca sample question paper, mca mumbai university question papers, mca exam syllabus, mca exam question paper, online mca exam papers, online mca exam preparation, mumbai university mca question papers, ignou university mca question papers

mca_india chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: