Scribd
Upload
46 views

DBMS 2 3

The document contains questions about relational database concepts like entity integrity, referential integrity, relational algebra operations, SQL queries, database constraints, triggers, stored procedures, JDBC, and more. It asks to define key terms, explain concepts, write SQL queries, and provide examples related to relational databases, SQL, and application programming interfaces for databases.

Uploaded by

harsharajbsy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
46 views

DBMS 2 3

The document contains questions about relational database concepts like entity integrity, referential integrity, relational algebra operations, SQL queries, database constraints, triggers, stored procedures, JDBC, and more. It asks to define key terms, explain concepts, write SQL queries, and provide examples related to relational databases, SQL, and application programming interfaces for databases.

Uploaded by

harsharajbsy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Module -2

1. Explain the entity integrity and referential integrity constraints. Why is each considered
important. Give examples.
2. Discuss equijoin and natural join with suitable examples using relational algebra notation.
3. Given the schema
Passenger (pid. pname, pgender. peity)
Agency (aid, anme, acity)
Flight (fid, fdate, time, src, dest)
Booking (pid, aid, fid, fdate)
Give relation algebra expression for the following:
I. Get the complete details of all flights to new Delhi
II. Find only the flight numbers for passenger with paid 123 for flights to Chennai before
06/11/2020
III. Find the passenger names for those who do not have any bookings in any flights
IV. Get the details of flights that are scheduled on both dates 01/12/2020 and 02/12/2020 at
16:00 hours
V. Find the details of all male passengers who are associated with jet agency.

4. Briefly discuss different type of update operations on relational database


5. Explain the different Relational Model constraints
6. List and explain the characteristics of relations
7. What are the basic operation that can change the states of relations in the database? Explain
how the basic operations deal with constraints violations
8. Describe the steps of an algorithm for ER to Rational mapping with example
9. Write command that is used for table creation. Explain how constraints are specified in SQL
during table creation with suitable example.
10. Consider the two tables show the result of the following:
T1 T2

A B C P Q R
10 a 5 10 b 6
15 b 8 25 C 3
25 a 6 10 B 5
1) T1 ⟕ T2 2) T1 ⟖ T2 3) T1 ⟗T2

11. Explain the relational algebra operations from Set theory with examples
12. Considered the COMPANY DATABASE
EMPLOYEE (Fname, Minit Lname, Ssn, Bdata, Address, Sex, Salary, SuperSsn, Dno).
DEPARTMENT (Dname, Dnumber, Mgr Ssn, Mgr Start_date)
DEPART LOCATIONS (Dnumber, DLocation)
PROJECT Prame, Pnumber, PLocation, Dnum) Ssn, Pno, Hours)
DEPENDENT (ESsn, Dependent Name, Sex, Bdate, Relationship).
Specify the following queries in SQL, on the database schema given above.
I. For every project located in 'Stafford', list the project number, the controlling
department number and the department managers last name, address and birth date.
II. Retrieve the birth date and address of the employees whose name is 'John B, Smith'.
III. Retrieve the name and address of all employees who work for the 'Research'
department.
IV. Retrieve the salary of every employee
13. Define the following:
I. Primary key
II. Super key
III. Foreign key
IV. Candidate key

Module -3

1. How are Triggers and Assertions defined in SQL? Explain


2. How is view created and dropped? What Problems are associated with updating View?
3. Explain the concept of Create, passing parameter, Call stored procedure from JDBC.
4. What is Cursor? With program segment explain retrieving of tuples with embedded in C
5. What is SQLJ and how is it different from JDBC?
6. Define Database stored procedure. Explain creating and calling stored procedure with
example.
7. List out the different types of JDBC drivers.
8. With a real world example , explain the following :
I. JDBC
II. Correlated nested queries
III. Stored Procedures
IV. Schema change statements in SQL
9. Write a short note on :
I. JavaScript
II. CGL
10. Illustrate insert, delete, update, alter and drop statements in SQL
11. With an example, explain stored procedures in SQL
12. Briefly explain types of JDBC drivers
13. Illustrate aggregate functions in SQL.

You might also like