Explain
the role of database administrator.
Explain
with a suitable example, converting an E-R diagram into a table.
Mention
and explain primitive operations in reltional algebra.
What are
keys? Mention and explain various keys used.
What are
integrity constraints?Explain.
Compare
and contrast file systems versus DBMS. Explain difference between logical and physical
data independence.
Consider
the following schema: suppliers( sid: integer, sname:string, address:string) ;
Parts(pid:integer, pnme:string, color:string) ; Catalog(sid:integer, pid:integer,
cost:real). write queries in relational algebra and TRC:
Find names of suppliers who supply
some red part.
Find sids of suppliers who supply
every part.
Finf pids of parts that are supplied
by at least two different suppliers.
Find the pids of the most expensive
parts supplied by suppliers named Tata
What are
the salient features of SQL?
Consider
the Sailors, Boats and Reserves schema in the text book and write the following
queries in SQL;
Find the names of sailors who have
reserved boat no: 103
Find the color of boats reserved by
Sudhakar.
Find the names of sailors who have
reserved both a red and a green boat.
Find the sailors whose rating is
better than some sailor called Sudhakar.
Distinguish
between DDL and DML
Explain about Generalisation and
Aggregation
Compare SQL and QBE.
Explain about Domain Calculus
expression.
Write short notes on a)Entities and
attributes b)Strong and Weak Entities c)Cross products and Joins.
Explain different levels of
abstraction in a DBMS.. What is data independence? Explain different types of Data
Independence.
Explain TRC and DRC with examples.
List two reasons why null values are introduced into databases. Explain nested subqueries
in SQL.
Differentiate between binary and
ternary relationships.
Let R=(A,B,C) and let r1 and r2 be
relations on schema R. Give an expression in SQL that is equivalent to each of the
following queries:
r1 U r2 2. r1 - r2 3. Pi(AB)
(r1) Join Pi(BC) (r2)
Construct an ER digrm for a cr
insurance company that has a set of customers, each of whom owns one or more cars. Each
car has associated with it zero to any number of recorded accidents.
Describe the extended ER features.
Draw the ER diagram for the banking
Enterprise and explain.
Describe fundamental operations of
relational algebra with examples. Discuss natural join with an example.
Explain various built in functions of
SQL.