Rr420104 Data Base Management Systems

Set No. 1

Code No: RR420104

IV B.Tech II Semester Supplimentary Examinations, May 2008 DATA BASE MANAGEMENT SYSTEMS (Civil Engineering) Time: 3 hours Max Marks: 80 Answer any FIVE Questions All Questions carry equal marks ⋆⋆⋆⋆⋆ 1. Discuss the disadvantages of file processing system, and explain how these disadvantages are avoided in DBMS [16] 2. (a) State and explain the mapping constraints which an E-R enterprise schema defines give suitable examples. (b) What is meant by a key of an entity? Discuss various types of keys

[10+6]

3. (a) Explain with an example, the division ooperation is relational algebra (b) Explain with an example, the Set - Union and set - Intersection operation is relational algebra. [8+8] 4. (a) What is meant by SQL? Discuss various parts in the SQL language. (b) Discuss how string operations are done in SQL.

[8+8]

5. (a) What is meant by QBE? Explain with an example. (b) What are the aggregate operators that are there in QBE? Discuss their usage. [6+10] 6. Explain the problem of “Loss Of Information” in Relational Database Design? [16] 7. Explain the recovery procedure that needs to take place after a disk crash?

[16]

8. (a) Write a note on Security Specification in SQL? (b) Write about Security in statistical Databases? ⋆⋆⋆⋆⋆

1 of 1

[10+6]

Set No. 2

Code No: RR420104

IV B.Tech II Semester Supplimentary Examinations, May 2008 DATA BASE MANAGEMENT SYSTEMS (Civil Engineering) Time: 3 hours Max Marks: 80 Answer any FIVE Questions All Questions carry equal marks ⋆⋆⋆⋆⋆ 1. Write short notes on the following: (a) Instances and sechemas (b) Data independence (c) Data abstraction.

[5+5+6]

2. Write short notes on the followin: (a) Entity sets (b) Relationship sets (c) Mapping constranits.

[5+5+6]

3. Discus indetail the structure of reational database

[16]

4. Discuss indetail the interactive DML and the basic DDL features of SQL.

[16]

5. Discuss with suitable exmples, the joined relations in SQL

[16]

6. Write a short note on the following: (a) Relation(R) & Schema (b) Decomposition of R (c) Normal Forms (d) Loss-Less Join Decomposition. 7. Write a detail note on ‘Log based Recovery’ mechanism in DBMS?

[4×4=16] [16]

8. (a) Describe a scenario in which discretionary access controls are required to enforce a security policy that cannot be enforced using only mandatory controls? (b) Explain the need for the limits of A maximum on the number of touples involved in answering a query in a statistical database system? [10+6] ⋆⋆⋆⋆⋆

1 of 1

Set No. 3

Code No: RR420104

IV B.Tech II Semester Supplimentary Examinations, May 2008 DATA BASE MANAGEMENT SYSTEMS (Civil Engineering) Time: 3 hours Max Marks: 80 Answer any FIVE Questions All Questions carry equal marks ⋆⋆⋆⋆⋆ 1. (a) Compare the Entity - Relationship model, and object - oriented model (b) State and explain various record based logical models, and give an example to each type of model. [8+8] 2. Discuss the process of reduction of an E-R schema to tables. Give suitable exmple. [16] 3. Discuss the following relational algebra operations. (a) The Natural - Join operation (b) The Division operation (c) The set intersection operation (d) The project operation.

[4 × 4 = 16]

4. Discuss indetail the interactive DML and the basic DDL features of SQL.

[16]

5. Discuss with suitable examples, the following uses of nested subqueries in SQL (a) Test for the absence of Duplicate tuples (b) Test for empty relations (c) Set comparision

[6+5+5]

6. Write a detailed note on “Pitfalls” in Relational Database Design?

[16]

7. Explain the recovery procedure that needs to take place after a disk crash?

[16]

8. Explain the following features in “d-base”? (a) Recovery (b) Security (c) Integrity.

[16] ⋆⋆⋆⋆⋆

1 of 1

Set No. 4

Code No: RR420104

IV B.Tech II Semester Supplimentary Examinations, May 2008 DATA BASE MANAGEMENT SYSTEMS (Civil Engineering) Time: 3 hours Max Marks: 80 Answer any FIVE Questions All Questions carry equal marks ⋆⋆⋆⋆⋆ 1. (a) Explain the differnce between physical data independence and logical data independence. (b) Discuss the functions of a database administrator. [8+8] 2. Draw the E-R diagram for a banking enterprise. Explain various entities and relationship in it. [16] 3. Write brief notes on the following: (a) Database schema (b) Relational algebra (c) Query languages

[4+8+4]

4. Discuss indetail the interactive DML and the basic DDL features of SQL.

[16]

5. (a) What is meant by a null value? Does SQL allows null values? Why? (b) Discuss the “Test for empty relation” nested query in SQL with an example. [10+6] 6. Explain the problem of “Inability To Represent Certain Information” in Relational Database Design? [16] 7. Explain the techniques for using the Log to ensure transaction atomicity despite Failures? [16] 8. Observe the following Schema and answer the following question. SCHEMA : Emp (eid :integer,ename:string,age:integer,salary:real) Works(eid :integer,did:integer,pct time:integer) Dept(did:integer,budget:real,managerid:integer) Suppose you have a view Senior Emp defined as follows : CREATE VIEW SeniorEmp (sname, sage, salary) AS SELECT E.name,E.age,E.salary FROM Emp E WHERE E.age > 50 Explain what the system will do to process the following query : SELECT S.name FROM Senior Emp S WHERE S.salary > 100,000.

[16] 1 of 2

Set No. 4

Code No: RR420104 ⋆⋆⋆⋆⋆

2 of 2