Group B

2. What is database? Discuss the importance of DBMS.

3. Explain the database designing process.

4. Highlight the difference between ORDER BY and GROUP BY. Write about DISTINCT operator with an example.

5. What are different types of functional dependencies? When is a relation said to be in BCNF?

6. Explain how the cost of query is measured? Suppose a relation with 3 fields A, B and C. Write relational algebra for the given criteria: Select rows where A = 3 and (B = 2 or C = 4), then project columns A and C.

7. What are the operations of a transaction? Also explain shortly on states of a transaction.

8. Write the measures to secure a database. What is the difference between Mandatory Access Control (MAC) and Discretionary Access Control (DAC)?

Group C

9. Given the schema as below, write relational algebra and SQL queries for the following: Sailors(sid, sname, rating, age), Boats(bid, bname, colour), Reserves(sid, bid, reservedate). a) Find name, rating, and age of all the sailors. b) Find the name and color of boats having color blue. c) Find name of the boats reserved on date 2021/07/20. d) Find the names of boats and sailors who have reserved boats having color green. e) Use Left and Right Outer Join between Sailors and Reserves.

10. Design an ER diagram for School/University. Use your assumption for the selection of attributes, entities and relationships. Show the use of the appropriate cardinalities.

11. Explain stored procedures, triggers, indexes with proper example and syntax for creation, update and deletion of each.

2081 Pre-Board Question Set 1

2081 Pre-Board Question Set 1