· ERD:Entity Relationship Diagram
·SQL:Structure Query Lang.
·Basic concepts of DBMS.
·Models in DBMS.
Normalization in
DBMS.
Q1. Design an ER schema for keeping
track of information about votes taken in the U.S. House of Representives
during the current two-year congressional session.
The database needs to keep
track of each U.S. state name(e.g., Texas,Newyork) and includes the region of
the state (whose domain is {NORTH-EAST,MIDWEST,
SOUTHWEST,SOUTHEAST,WEST}
). Each CONGRESSPERSON in the house of Representives is described by their
Name, and includes the District represented ,
the StartDate when they
were first elected , and the political Party they belong to (whose domain
is {
Republican,Democrat,Independent,Other} ).the database
keeps track of each BILL(i.e.
proposed law), and includes the BillName,the DateOfVote on the bill , whether
the bill PassedOrFailed(whose domain is {YES,NO} )
, and the sponsor (the
congressperson(s) who sponsored- i.e. , proposed- the bill). The database keeps
track of how each congressperson voted on each bill
(domain of vote attribute
is {YES,NO,Abstain, Absent } ).Draw an ER schema diagram for the above
application . state clearly any assumption you make.
Q2. Briefly explain the eight steps that are required to Map an ER model
into relational model.
Q3. Explain various Aggregate function in SQL with e.g.
Q4. Explain the following terms with Syntax and e.g.
(a)Select (b)Project (c)
Theta join (d)Equi join (e) Natural join (f) Union (g) Intersection (h) Difference (i) Cartesian Product (j)
Division
Q5.For each of the following UML terms discuss the corresponding terms
in the EER model, if any:
Object, Class, Association,
Aggregation, Generalization, Multiplicity,
Attrbute , Discriminator, Link, Reflexive association, Qualified
association, link attributes.
Q6.Draw an UML conceptual schema(Class Diagram) for BANK.
Q7.write shorts notes on followings.
(a) Data Independence.
(b) Advantages of DBMS.
(c) Differentiate b/w a procedural and non procedural DML.
(d) Discuss the various reasons that leads to the the occurance of null
values in th DB.
Q8.
(a)What is data abstraction ?Explain the mechanism by which it is
achieved in the DB environments.?
(b)How is project operation similar to select operation ?.
Q9.Discuss the main categories of data models.
Q10.Consider the following relations for database thats keeps track of
students enrollment in courses and the books adopted for each
course :
STUDENT(SSN,Name,Major,BDate)
COURSE(COURSE,CName,Dept)
ENROLL(SSN,Course,Quarter,Grade)
BOOK_ADOPTION(Course,Quarter,Book_ISBN)
TEXT(Book_ISBN,Book_Title,Publisher,Author)
Specify the foreign keys for the above schema ,starting any assumption
you make. Then write the SQL commands for the followinf
SQL query
(a) List the number of courses taken by all students named 'Ashish
Kumar' in Winter 1998(i.e, Quarter=W98).
(b) produce a list of textbooks (include Course,Book_ISBN,Book_Title)
for courses offered by the 'CS' department that have used
more than two books.
(c) List any department that has all its adopted books published by 'BC
Publication'
(d) Define Candidate key and unique key.
Q.11 Answer the following questions:
(a)
Explain difference between left outer join and right outer join.
Also write their syntax.
(b)
What is the dependency preservation property for decomposition?
(c) Draw a state diagram, and discuss the typical
states that a transaction goes through execution.
(d)
What is meant by completeness and
soundness of Armstrong inference rules?
Q12.
Q.13
(a) Consider the following two sets of functional
dependencies: F = { A → C, AC → D, E→AD, E→ H} and G = {A →CD, E→AH}. Check
whether they are equivalent.
No comments:
Post a Comment