Trending ▼   ResFinder  

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

5 pages, 27 questions, 0 questions with responses, 0 total responses,    0    0
mca_india
   		+Fave Message
ProfileTimelineUploadsQ & A
 Home > mca_india >

Formatting page ...

I MCS-023I MCA (Revised) Term-End Examination December, 2009 O MCS-023 : DATABASE MANAGEMENT SYSTEMS Maximum Marks :100 Time : 3 hours (Weightage 75%) Note : Question number 1 is compulsory. Attempt any three from the rest. 1. (a) State BCNF what are the anomalies associated with a relation that is not in BCNF ? Given a relation R (Supplier, City, Part) with functional dependencies supplier > city and. City, Part > Supplier. Is R in BCNF ? If not decompose R into BCNF relations. 1+3+4 (b) Map the following E-R diagram the most suitable relational database scheme. For each relation, choose an appropriate name and list corresponding attributes, undertaking the primary key. For each 4+2+2 relation, also identify the foreign keys. MCS-023 1 P.T.O.

Formatting page ...

Formatting page ...

Formatting page ...

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - I (sem 2) December 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  

© 2010 - 2024 ResPaper. Terms of ServiceContact Us Advertise with us

 

mca_india chat