VIVEKANANDHA COLLEGE OF ENGINEERING FOR WOMEN
(AUTONOMOUS)
Tiruchengode, Namakkal (Dt) - 637205
DEPARTMENT OF COMPUTER SCIENCE AND TECHNOLOGY
UNIT-1
QUESTION BANK
1. Define Database Management system?
2. Differentiate instance and schema.
3. Write the Characteristics that distinguish the Database approach with the File-based Approach?
4. List any five applications of DBMS.
5. What is a data model? List the types of data model used.
6. What is Relational Instance, Relational Schema? Give one examples?
7. Define Data independence.
8. What is the role of Database Administrator ?
9. Describe the three levels of data abstraction?
10. List and explain the functions and capabilities of DBMS.
11. Define Entity, Attributes, Entity set, relationship with appropriate notations
12. Draw the notation for multivalued attributes? Give one example?
13. What are composite attributes?
14. Assess the characteristics that distinguish the strong entity with weak entity
15. Define Embedded SQL
16. Give example of following relationships : a.Many-to-One b.One-to-One c.One-to-Many d.Many-to-Many
17. Define Entity Relationship Model
18. Draw Database Environment
19. What is an Entity set?
15 Marks
1.With the help of the block diagram, describe the basic architecture of a database management system.
2.What is a data model? Explain the different types of data model in detail
3.(i) List the disadvantages of File system over database. (6)
(ii)Who is a DBA? What are the responsibilities of a Database users? (9)
4.(i) Define Database? Discuss about applications of Database Systems in detail? (7)
(ii) Discuss about the purpose of Database Systems? (8)
5.Describe in detail about Relational Database and explain with necessary example.
6.Draw an E-R diagram for a banking enterprise with almost all components and explain. (13)
7.(i) Explain why would you choose a database system instead of simply storing data in operating system files?
When would it make sense not to use a database system? (8)
(ii)Explain the difference between logical and physical data independence. (7)
8.Develop an ER diagram for the "Restaurant Menu Ordering System", which will facilitate the food items
ordering and services within a restaurant. The entire restaurant scenario is detailed as follows. The customer is
able to view the food items menu, call the waiter, place orders and obtain the final bill through the computer
kept in their table. The water through their wireless tablet PC are able to initialize a table for customers, control
the table functions to assist customers, orders, send orders to food preparation staff (chef) and finalize the
customer's bill. The food preparation staffs (chefs), with their touch-display interfaces to the system, are able to
view orders sent to the kitchen by waiter. During preparation, they are able to let the waiter know the status of
each item, and can send notifications when items are completed. The system should have full accountability and
logging facilities, and should support supervisor actions to account for exceptional circumstances, such as a
meal being refunded or walked out on. (15)
9.(i) Develop an E-R diagram for a car-insurance company whose customers own one or more cars each. Each
car has associated with it zero to any number of recorded accidents. State any assumptions you make. (5)
(ii) A university registrar's office maintains data about following entities:
(1) Courses, including number, title, credits, syllabus, and prerequisites;
(2) Course offerings, including course number, year, semester, section number, instructor, timings and
classroom;
(3) Students, including student-id, name, and program; and (4) Instructors, including identification number,
name, department, and title.
Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled
for must be appropriately modeled. Construct an E-R diagram for the registrar's office. Document all
assumptions that you make about the mapping constraints. (10)
10.A car-rental company maintains a database for all vehicles in its current fleet. For all vehicles, it includes the
vehicle identification number, license number, manufacturer, model, date of purchase, and color. Special data
are included for certain types of vehicles: Trucks: cargo capacity.. Sports cars: horsepower, renter age
requirement. Vans: number of passengers. Off-road vehicles: ground clearance, drive train (four- or two-wheel
drive). Construct an E- R model for all operations
VIVEKANANDHA COLLEGE OF ENGINEERING FOR WOMEN
(AUTONOMOUS)
Tiruchengode, Namakkal (Dt) - 637205
DEPARTMENT OF COMPUTER SCIENCE AND TECHNOLOGY
UNIT-2
QUESTION BANK
1. Analyze about relational algebra.
2. Define Primary key and candidate key with example
3. Define Differenr types of keys in Rdbms
4. Write short notes on tuple relational calculus and domain relational calculus
5. What is the difference between DELETE and TRUNCATE commands?
6. Explain the structure of basic form of an SQL query
7. Write query for finding the age of the youngest sailor who is eligible to vote for each rating level with at
least two such sailors.
8. What are aggregate functions? And list the aggregate functions supported by SQL?
9. What are join operation in SQL?Listout different types of join operation
10. What are different types of Data languages?
11. Write short notes on relational calculus.
12. Write a SQL statement to find the names and loan numbers of all customers who have a loan at XYZ
branch.
13. Define Degree and Cardinality
14. Analyze the characteristics that distinguish the union operation with intersection operation in relational
algebra
15. Explain how to create table with syntax in SQL
16. List and explain various DML, DDL commands in SQL.
17. Define foreign key with an example?
18. Explain Select Query in SQL.
19. Illustarte Nested Queries with example
20. Explain Set operation in SQL
15 marks
1. Describe different operations in Relational algebra with an example
2. Expalin different types of keys in RDBMS with example
3. Describe the aggregate functions in SQL with an example.
4. Explain in detail about nested queries with suitable examples
5. What is a join operator? Explain about different types of joins with syntax and example
6. What are set operation in SQL?Listout different types of set operation with examples
7.Consider the given relation schema .
Employee(empno,name,office,age) Books(isbn,title,authors,publisher) Loan(empno,isbn,date)
Write the following queries in SQL
(a) Find the name of all employees who have borrowed a book published by McGraw-Hill.
(b) Find the name of all employees who have borrowed all book published by McGrawHill.
(c) Find the names of employees who have borrowed more than five different books published by McGraw-
Hill.
(d) For each publisher, find the name of employees who have borrowed more than five books of that publisher.
8.Describe DCL and TCL commands with examples
9.(i) What is the usage of group by and having clauses in SQL? (8)
(ii) Define foreign key ? How does it play a role in the join operation ? (7)
10.Describe the six clauses in the syntax of an SQL query, and show what type of constructs can be specified in
each of the six clauses. Which of the six clauses are required and which are optional?
11.A college consists of number of employees working in different departments. In this context, create two
tables employee and department. Employee consists of columns empno, empname, basic, hra, da, deductions,
gross, net, date-of-birth. The calculation of hra, da are as per the rules of the college. Initially only empno,
empname, basic have valid values. Other values are to be computed and updated later. department contains
deptno, deptname, and description columns. Deptno is the primary key in department table and referential
integrity constraint exists between employee and department tables?
12.Explain various DML, DDL commands in SQL.
13.Explain the basic structure of SQL Query
14.Illustarte Nested Queries with example
15.Discuss in detail about Relational Calculus with examples
16.Describe the DDL, DML, DCL commands for the student's database, which contains student details: name,
id, DOB, branch, DOJ, and course details: Course name, Course id, Stud Id, Faculty name, id, marks.(13)
18.Consider the relational table given below and assess about the following SQL
queries. Employee (Empno, Name, Department, Salary).
(i) list all the employees whose name starts with the letter 'L'. (3)
(ii) Find the maximum salary given to employees in each department. (3)
(iii)Find the number of employees working in 'accounts' department. (2)
(iv)Find the second maximum salary from the table. (3)
(v) Find the employee who is getting the minimum Salary. (2)
19.Consider the relational table given below and assess about the following SQL
queries. Employee (Empno, Name, Department, Salary).
(i) list all the employees whose name starts with the letter 'L'. (3)
(ii) Find the maximum salary given to employees in each department. (3)
iii) Find the number of employees working in 'accounts' department. (2) (
(iv)Find the second maximum salary from the table. (3)
(v) Find the employee who is getting the minimum Salary. (2)
