[go: up one dir, main page]
Scribd
Upload
22 views3 pages

Important Unit 1,2,3

Uploaded by

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

Important Unit 1,2,3

Uploaded by

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

DBMS

Unit-1
Shorts:
1) What is DBMS? What are the goals of DBMS?
2) Define Database.
3) Quote examples for composite attributes.
4) What is Data model?
5) Define aggregation.
6) Write about Database Schema Vs Database state.
7) What is Relationship type? Give an example for binary relationship.
8) List the database applications.

Longs:
1) Compare and contrast file system Vs Database systems.
2) Explain Database users and functions of DBA.
3) Construct an ER diagram for online E-commerce application such as
Amazon. Incorporate all the features of entity relationship model.
4) List the disadvantages of file system.
5) Construct an ER diagram for collage admission systems. Try to incorporate
basic and advanced features of ER model.
6) Explain ER diagram and Relationships with example.
7) Outline DBMS Architecture with a neat sketch.
8) Prepare ER diagram for Library Database.
9) What is the importance of three schema architecture in Database design.
10) Define data model. Explain various types of data model.
11) Construct ER diagram for a hospital with a set of patients and a set of
medical doctors . Associate with each patient a log of the various tests and
examinationsconducted.
12) Levels of abstraction
13) Data independence
Unit-2
Shorts:
1) What is meant by Cardinality and degree of relation?
2) What are set operations on relation?
3) Write an example of candidate key.

Longs:
1) What is domain constraint explain with an example.
2) Define view. Explain how to create views.
3) Discuss the operators used in Relational Algebra to write queries for data
access.
4) Illustrate the use of join operation in Relational Algebra.
5) What is an integrity constraint? Discuss different integrity constraints and
their enforcement by DBMS.
6) Give the structure of Relational model.
7) Explain syntax and semantics of tuple relational calculus.
8) Why are constraints to be imposed on database design?
9) Explain Domain relational calculus.
10) Explain set manipulators in SQL.
Unit-3
Shorts:
1) Define trigger and list its 3 parts.
2) Differentiate Nested queries and Co-related queries with an example.
Consider the following schema.
Sailors(sid:int,sname:string,rating:int,age:int)
Reserves(sid:int,bid:int,day:date)
Boats(bid:int,bname:string,color:string)
a) Write a nested query to find the names of sailors who have reserved
both red and green boat.
b) Write a nested query to find the names of sailors who have reserved all
the boats.
3) Consider the following database schema in SQL.
EMP (eid,ename,ecity)
COMPANY (Cno,cname,ccity)
WORKS (eid,Cno,Salary)
a) Find the employees from Hyderabad.
b) Find the companies located in Warangal.
c) Find the employees working at Karimnagar.
d) Find the name of the employees getting maximum salary.
e) List the employee ids getting more than average salary of all the
employees.
4) Illustrate five aggregate operators of SQL.
5) What is a trigger? Develop a trigger to allow DOB of employee greater than
his date of join.
6) Set oprators.

You might also like