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

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

5 pages, 27 questions, 0 questions with responses, 0 total responses,

	mca_india	+Fave Message
	Profile Timeline Uploads Q & 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. Qality s# Name Address (c) Given the relational schemes : Enroll (S#, C#, Section) - S# represents Student number Teach (Prof, C#, Section) - C# represent course number Advise (Prof, S#) - Prof is theirs advisor of S# Prereg (C#, Pre, C#) Pre - C# is a prerequisites course Grades (S#, C#, Grade, year) Student (S#, Sname) MCS-023 2 Write the following queries using SQL. List all students taxing courses with student Ram. List all students taxing at least one course then their advisor teaches. List those professors who teach atleast one course. List the courses that student Anil has enrolled. What is normalization ? What is its purpose ? Discuss the effect of a commit operation with the help of an example. Identify a major weakness of a client/server architecture and suggest a way to deal with this problem. Define Data Fragmentalism. Identify three objectives of data fragmentation in Distributed Databases. Express the queries listed in Q 1 (iii) using Relational Algebra. For the relations R 1 and R 2 given below, perform the following operation and their the resulting relations : (i) Find the projection of R 2 on the attributes 0 (B,C). Find the natural join of R 1 and R2 on the common attributes. MCS-023 3 4 4 4 8 6 Divide R 1 by the relation that is obtained by first selecting those tuples of R2 where the value of B is either b1 or b 2 and then projecting R2 on the attributes (C,D). A al a2 al a2 al a2 al BCD b2 b1 c2 d2 c1 d2 bi. c2 d1 b1 c2 d2 b2 b1 b2 c1 c1 c2 d2 d2 d2 R2 B b1 b2 C c1 D d1 c1 d2 b3 c2 d1 b1 c1 d2 b2 C2 d2 (c) Explain database recovery using system log with the help of an example. MCS-023 4 6 P.T.O. 3. 4. 5. Differentiate between the following with examples : Candidate Key, Primary Key and Foreign Key. DDL and DML Weak entity and strong entity Wait die and wound wait protocols. (e) Sequential and Indexed Sequential file organization. 20 (a) Explain any two integrity constraints with 6 the help of an example. Discuss two phase locking protocol. 4+4 Differentiate between basic and strict two phase locking. Under what situations B-trees indexes are 6 preferable over Binary Search Tree Indexes. (a) What are the advantages and disadvantages of distributed databases ? Define Third normal form. How does it differ from Second Normal Form ? What is a 'view' in databases ? What an its advantages ? (d) What are the three levels of database architecture ? How are they related to the concept of data independence ? -o0o- MCS-023 5 6 4 5 5

Formatting page ...

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

mca_india chat

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