Trending ▼   ResFinder  

PUNJAB TECHNICAL UNIVERSITY MCA - II (SEM 3) SEP 2010 : Relational Database Management Systems - I

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

Formatting page ...

Roll No. ...................... Total No. of Questions : 13] [Total No. of Pages : 02 Paper ID [A0514] (Please fill this Paper ID in OMR Sheet) MCA (304) (S05) (O) (LE) (Sem. - 3rd) RELATIONAL DATABASE MANAGEMENT SYSTEM - I Time : 03 Hours Maximum Marks : 75 Instruction to Candidates: 1) Section - A is Compulsory. 2) Attempt any Nine questions from Section - B. Section - A Q1) (15 2 = 30) a) Briefly explain the structure the distributed database. b) Write short note on the hierarchical model. c) Explain the main components of the E-R model. d) Compare OOD and ORD. e) Write down main objectives of DBMS. f) What do you mean by functional dependency? Discuss types. g) Explain the 3NF. h) Differentiate between Relational Algebra and Relational Calculus. i) Discuss the JOIN operation of relational algebra. j) What are the problems arising out of un-normalized data? k) Distinguish between DDL and DML. l) What is a foreign key? What is its role? m) How database recovery is done? n) o) A-532 What is database integrity? Discuss its rules. Explain client/server architecture. P.T.O.

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - II (sem 3) September 2010 Question Paper - Relational Database Management Systems - I
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