Database Management System — Summer 2024

Define Super key, Candidate Key and Primary Key.

Explain ACID Properties.

Write a detail note on Three levels ANSI SPARC database s ystem

Describe Grant and Revoke commands with suitable example.

Write short note on query processing.

Write Relational Algebra syntax for the following queries. Employee(eno, ename, salary, designation) Customer(cno, cname, address, city) 1) List out name of employees who are ‘Manager’. 2) Retrieve Employee records whose salary is less than 20,000. 3) Find out name of employees who are also customers. 4) Find out name of person who are employees but not customers

Assume that following table is Already Created. Dept_no Dept_name Location 10 Account Mumbai 20 HR Ahmedabad 30 Production Vadodara 40 Sales Delhi 50 EDP Delhi 60 TRG Mumbai 110 RND Patna Write SQL queries for the following.

Display all records of Department table

List all department names starting with 'A'

List all departments whose number is between 1 and100

Display all department belonging to location ' Mumbai '

Delate the department whose location is ‘patna’.

Delete 'TRG' department

Change department name 'EDP' to 'IT'.1

List and explain TCL with suitable example.

Explain String functions with suitable example

Explain in details Three level architecture of database system.

Define following terms.

Tuple

Relation

Schema.

What is view? Explain different type of view with an example.

What is Difference between Drop and Delete Command in sql.

Explain Selection and Projection relational algebra operation with Example.

List and explain DML statements with suitable examples.

What is Difference between Alter and Update Command in sql.

Explain cursor and its type with suitable example.

What is Constraint?List out various types of SQL Constraint.

Explain B-trees database storage strategies.

What is Normalization?Explain any one type of Normal form.

List and explain DDL statements with suitable examples.

Explain PL/SQL block Structure.

List and Explain aggregate functions in SQL.

What is join? List and explain various types of joins. -------2