I Semester M.Sc. Degree Examination, January/February 2014 (Y2K5 Scheme) COMPUTER SCIENCE MCS-103 : Database Management System Time : 3 Hours
Max. Marks : 80
Instruction : Answer any five questions, choosing atleast two from each Part. PART – A 1. a) Define DBMS. Explain the various applications of DBMS.
8
b) Explain the differences between File Processing System and Database System.
8
2. a) Explain different indexing techniques.
8
b) Draw an E-R diagram for Employee Management System.
8
3. a) Explain the basic relational algebra with examples.
8
b) Explain different types of views in SQL with suitable illustrations.
8
4. a) Consider the following relational schema and briefly answer the questions that follow : Emp (eid : integer, ename : string, age : integer, salary : real) Work (eid : integer, did : integer, pct-time : integer) i) Define a table constraint on employee that will ensure that every employee makes atleast 10,000/-. ii) Define a table constraint on department that will ensure that all managers have age > 30. iii) Write SQL statement to delete all information about employees whose salaries exceed that of manager one or more department that they work in. b) Explain the Object Oriented Data Model.
8 8
P.T.O.
*PG532*
PG – 532 PART – B
5. a) What is normalization ? Explain 2NF and 4NF with an example for each. b) Explain DDL and DML commands with examples.
8
6. a) Why database failure occurs ? How to recover the data from such failures ? Explain the various recovery techniques in detail. b) Define concurrency control. Explain multi version concurrency control techniques.
b) What is Database Security ? Explain the role of DBA in Database Security.
issue no. and name. Any member can only. read the journal/magazine in library itself. i.e Journal/Magazine cannot be issued. CS-06 1 P.T.O.. Page 1 of 4 ...
1. What are the responsibilities of the DBA ? 3. 2. Explain program â data Independence. 3. 3. What do you mean by domain of an attribute ? Give one example.
2. a) Give an ER diagram for student database, with all essential ER concepts. 12. b) Write the ... b) Explain the ORACLE languages and interfaces briefly. 10. 8.
We might choose to identify a dependent by name alone in this situation, since it is ..... Each song is performed by one or more musicians, and a musician may ...
c) Discuss the classification of DBMS. 5. 2. a) What are the different types of attributes ? Explain with examples. 10. b) Explain the ER-to-relational mapping ...
5.9 Distributed Serializability. 5.10 Classification of Concurrency Control Techniques ... 7.5 Global Query Optimization Algorithms. 7.6 Distributed Database Security. 7.7 View Management ... Laboratory Work with oracle latest version: Page 3 of 6. I
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.
database objects. A DBMS allows different user application programs to concurrently access the same ... Page 3 of 9. 1.8.1 Database Management Systems.pdf.
site has the following database management systems 3rd edition available for free PDF download. You may find database management systems 3rd edition ...
The management of data in telecommunications system has many aspects whereof some, but .... initialize a database schema, start Mnesia, and create tables.
