Important Questions
Internal Assessment-1
Part-A
1. What is Database? Give some applications of Database
2. List the three levels of data abstraction.
3. What is weak entity set? Give Example
4. Differentiate Instance and Schema.
5. Compare the features of file system with database system.
6. List the steps involved in Query Processing
7. What is primary key and foreign key. Give example for each.
8. What are aggregate Functions? List the aggregate functions used in SQL.
9. Write SQL query to get the department and department wise total (sum) salary, display it in
ascending order according to salary.
10. Compare Dynamic SQL and Static SQL.
11. Define Functional Dependency.
12. List the Properties of Decomposition.
13. State Anomalies in NF.
Part-B&C
1. Explain Basic architecture of DBMS with its neat block diagram.
2. Write short notes on
(i) Purpose of Database systems(5)
(ii) Views of data (4)
(iii) Applications of database systems(4)
3. Illustrate with an example, Extended E-R Diagram and its notations.
4. Illustrate in detail about Relational Data model and ER model for employee database
application.
5. Draw ER Diagram for “ Restaurant menu ordering system”, which will facilitate the food items
ordering and services within restaurant. The entire scenario is detailed below. The customer
is able to view the food items menu, call the waiter, place orders and obtain final bill through
the computer kept in their table. The waiters 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 customers bill. The chef with their touch
display interface to the system, are able to view orders sent to the kitchen by waiters. 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 meal being refunded or walked out on.
6. Explain select, project, Cartesian product operation and Join operation types in relational
algebra.
7. Give syntax and explain DDL, DML, DCL commands for the given student’s database which
contains student details: name, id, DOB, branch, DOJ, and course details: Coursename, Course
id, Stud Id, Faculty name, id, marks.
8. Consider the following relational schema:
a.Book(bookid,title,publisher_name)
b.Book_author(bookid,author_name)
c.Book_copies(bookid,branched,No_of_copies).
Write the following queries inSQL.
i. Retrieve the author name of book having title ‘Operating System’.
ii. Retrieve the total number of titles of each publisher.
iii. Retrieve the total number of titles.
iv. Retrieve title, publishername&authorname of the bookid ‘B101’.
v. Retrieve the number of copies with bookid=’B101’ and branched=’BR001’
9. Develop queries and show how a SQL relation can be defined using various constraints and
types of keys? Also, Explain different data definition Language statements in detail.
10. Perform the following clauses of SQL with example queries.
i. FROM clause
ii. GROUP BY clause
iii. HAVING clause
iv. ORDER BY clause.
11. Explain the concept of functional dependencies and its types with example.
12. State the need for Normalization .Construct 1NF,2NF,3NF with example
