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

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

4 pages, 30 questions, 0 questions with responses, 0 total responses,

	mca_india	+Fave Message
	Profile Timeline Uploads Q & A

Home > mca_india >

Formatting page ...

No. of Printed Pages : 4 MCS-023I MCA (Revised) Term-End Examination June, 2010 0 MCS-023 : DATABASE MANAGEMENT SYSTEMS Time : 3 hours Maximum Marks :100 (Weightage 75%) Note : Question number 1 is compulsory. Attempt any three questions from the rest. 1. (a) Define 3 NF. Justify whether the following relation satisfies 3 NF or not ? In case it does not, decompose it into relations which do satisfy 3 NF. What advantages are 2+5+1=8 gained by this decomposition ? Roll No. Name Department Year Hostel Name D1 1 H1 R1 N1 R2 1 H1 N3 D1 N4 D2 R5 N5 Di R6 N6 D3 2 2 3 4 H2 R4 D2 R3 MCS-023 N2 1 H2 H3 H4 P.T.O. (b) Consider the following tables : 15 Working (P_name, C_name, Salary) Living (P_name, Street, City) Located (C_name, city) When P_name = Professor name, C-name = College name. Write the SQL Queries for the following. List the names and cities they live in, of the professors who are working for the college C1 Find the name, street and city of the professors who are working for the college C 2 and are having a salary more than 60000/-. Find the names of professors who live and work in the same city. Find the names of the professors who do not work for college C3. Find the professors whose salaries are less than that of all of the college C4 employees. Display college wise total salary. Explain the concept of data independence. 3 List and explain all the types of constraints 6 which can be violated while modifying database values. What is a weak entity ? Explain with the 1+2 help of an example. Explain the hash file - organisation with the 5 help of a suitable diagram. What are its shortcomings. MCS-023 2 2. 3. (a) For the following statement, draw an E-R 8 diagram. Make and state any reasonable assumptions. "A machine shop produces many parts which it takes on contract. It employs many operators who operate any of the machines. A part is produced using only one machine. A record is kept on the quantity of material needed for producing each part. The production of each part is tracked by giving a job number, start time and end time and operator's identification". What is a transaction ? Describe the ACID 1+4 properties of transaction. What is a deadlock. Explain the schemes of 1+4 deadlock prevention. (d) Define the term DML precompiler 2 (a) Differentiate between the followings : 2 Tier and 3 Tier architecture Equi join and Natural join Global and local transaction Procedural and Non Procedural DMLs. What is Cartesian product. Explain using an example. How Cartesian product operation is related to the join operation. Consider the relations student (d name, address) marks (id, course, marks) Create an authorization matrix for two users Viz. Student and Administrator. Make and state suitable assumptions. MCS-023 3 12 4 4 P.T.O. 4. Explain the following with the help of an 20 example / diagram wherever needed : Conditions of occurence of deadlocks Primary and Secondary indexes BCNF Two phase locking (e) Conversion of relationships (in ER-Diagram) into relations. What is log based recovery ? Explain by taking an example of concurrent transactions. What are its drawbacks. 2+5+1 Why do we need to fragment a relation ? What are the rules to be followed during fragmentation. 6 Explain the following relational algebraic operations with the help of an example. 6 Division operator Set Difference operator

Formatting page ...

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