VI Semester B.E. (CSE/ISE) Degree Examination, January/February 2014 (Y2K6 Scheme) CI – 6.2 : DATABASE MANAGEMENT SYSTEM Time : 3 Hours
Max. Marks : 100
Instruction : Answer any five questions, selecting atleast two from each Part. PART – A 1. a) Explain the architecture of DBMS with a neat diagram.
8
b) Bring out the advantages and disadvantages of DBMS over conventional file system.
7
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 algorithm with an example.
10
3. a) Write a note on the DML operations that can be performed on a relational model, along with the constraints that are violated with examples.
8
b) Discuss the relational algebra aggregate functions with example.
6
c) Explain SET theoretic operations.
6
4. a) Explain the following relational operations with example for each. i) SELECT ii) PROJECT iii) JOIN. b) What is a view in SQL, how is it defined ? Discuss the problems that may arise when one attempts to update a view.
10
10 P.T.O.
*JU897*
JU – 897 PART – B
5. a) State the informal design guidelines for relational schema design. Illustrate how violation of these guidelines may be harmful. 12 b) Define FD, explain 2NF and 3NF with an example. 6. a) State and prove Armstrong’s Inference rules. b) Define multivalued dependencies and join dependencies with examples.
8 10 10
7. a) With a diagram explain the oracle architecture.
10
b) Discuss the various features of Ms-Access.
5
c) Write a note on embedded SQL.
5
8. Write notes on any four of the following : i) Data warehousing ii) Spatial databases iii) Association rules iv) Mobile databases v) Digital libraries. ———————
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 ...
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 ...
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.