Chapter 1
1.Explain dense and parse index?
2.What
are logical and physical files.
3.Explain
Basic File Operation
4.Explain
sequential file organization in detail.
5.What
is file organization ? Explain the indexed file organization.
6.What
is file ? Explain file structure.
Chapter 2
1.List
various users of DBMS and Specify their jobs
2.Explain
advantages and disadvantageous of DBMS.
3.Explain
Object oriented model
4.Explain the advantageous of network model over
Hierarchical model
5.Explain
the application of DBMS
6.Difference
between network model and relational model
7.What are the functions of Database Administrator
8.What
are the strong and weak entities
9.What
do you mean Data model ?Explain ERD model with example.
10.What
do you mean Data model ?Explain network
model with example.
11.Explain
the overall structure of system.
12.What
is Generalization and specialization
13.Explain
the views of database Management System.
14.Explain
the different DBMS and RDBMS used in the industry
15.Explain
the role of a DBA
16.Write
a short note on Data Abstraction
17.Explain
Referential Integrity with suitable example
18.What
are the different types of relationship
Chapter 3
1.Explain
select and project operation in Relational Algebra
2.Explain
the terms Super key ,Entity ,Tuple,Domain
3.Explain
primary key and Foreign key with suitable example.
4.Explain
entity and attributes and explain its types
5.Explain
the terms or commands Group by ,Entuty,Order by ,Domain
6.Explain
Unary and Binary operations
7.Explain
the natural join and Cartesian product with examples
8.Explain
the terms group by ,Entity ,Cardinality ,Super key
9.Define
the terms Attribute ,Cardinality ,Primary key ,Foreign Key
10.Explain
terms Record,Data Dictionary
11.What
is Relational Algebra ? explain Union and Cartesian Product operation with example.
12.What
is Relational Algebra ? explain Union and difference operation with example
Chapter 4
1.List
various DDL Commands. Explain any one with Example.
2.What
are different aggregate function in sql.
3.List
various DML Commands. Explain any one with Example.
4.Explain
DDL and DCL
5.Explain
ALTER Table
Chapter 5
1.What
are anomalies of un-normalized database
2.Write
a note on normalization
3.What
is Normalization? Explian 1NF with suitable example
4.Explain
different anomalies related with Normalization.
5.Explian
Insert Anomalies with example
ERD
Diagram (8mk)
1)Design
database for banking enterprise which recods information about customers,
employees of bank. A customer can be depositor or borrower.An employee of the
bank can be customer of bank. There are
two types of accounts,saving account and current account .
A
database should provide following
details.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
2)A
reputed general hospital has decided to computerized its operations .In
hospital many doctors are working. The patients are admitted to the hospital
,into the room. There they are treated by various doctors. Some times patients
have to undergo certain pathological tests ,which are carried out in the labs.
A
database should provide following
details.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
3)In a milk billing system the farmers are the
members of the dairy in a village .They submit the milk daily once or more than
that depending upon the collected milk from cow,the dairy accepts milk and pays
the bills to farmers fortnightly i.e on 15 th of every month.The dairy sends
the bill to the Bank located in the village.
A
database should provide following
details.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
4)Star
is an agency for flat booking and it has number of builders and agents who are
jointly working.A customer can get a flat for residential or commercial
purpose.If customer is approached through an agent the agency and builders are
giving some commission to the agent.Agent shows various flats and sites within
various location.
A
database should provide following
details.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
5)An
Insurance agent sells insurance policies to clients.Policies can be of different
types such as Vehicle Insurance,Life Insurance ,Accident Insurance etc.The
agent collects monthly premimums on the policies in the form of cheques of
local bank.Database should provide the various details to the user.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
6)Design
database for banking enterprise which recodes information about customers,
employees of bank .A customer can be a depositor or a borrower. An employee of
the bank can be customer of bank. These are two types of accounts, saving
account and current account.
A database should provide following details.
1)Identify
all entities
2)Identify
all relationship
3)Draw
E-R diagram.
Algebric Expression. (8 mk)
1)Customer(
cno,cname,address,city)
Loan(lno.lamt,ldate,cno)
One
to many relationship
1)List
loan details of customer name as”Mr.Damle”
2)List
names of customer names who have taken loan amount more than 50000 and city as
‘mumbai’
3)List
names of customer who do not have loan at the bank.
4)
Display customer with loan amount greater
than 100,000
5)
List loan details of customer name as”Mr.Shinde”
6)
List names of customer names who have taken loan amount more than 50000.
7)List
names of customer who stay in city “Mumbai”
2)Supplier
(Supno,sname,supaddress)
Item(Ino,Inmae,stock)
Supp-Item(Supno,Itemno,rate)
1)List
all suppliers from Varanasi city who supplies PISTON
2)Display
all suppliers supply PISTON TINGS
3)Change
supplier names to upper case
4)List
all suppliers supplying DOOR Lock from jaipur city.
3)Customer(cno.cname,city)
Quotation(qno,qdate
,description,amt-quoted,cno)
One-many
relationship
1)Display
customer names having quotation for LCD
2)List
all the customer bearing quotation dated 20 may 2010
3)list
all the customers who live in MP OR UP
4)Display
customers of amt-quoted as Rs.15000
4)Patient
Master(pno,pname,sex,Address city,Allergy ,Chief Complaints)
1)Display
all patients whose allergy is”Nimesulide”
2)Display
allmale patients from city Calcutta
3)Update
all patients whose sex is M with Male
4)List
all patients whose chief complaint is fever.
5)Movie(mvno,mname,release-year)\
Actor(actno,actname)
Many-Many
1)Display
actorwise movie details.
2)Display
all actor details of movie ‘Airlift”
3)Count
all the movie names releaed in the year 2015
4)Add
age column to Actor table
5)Display
all movies of actor ‘Amitabh’
6)Change
the actor name from ‘Ranbir’ to ‘John’
Query (16 mk)
1Item(ino,name,quantity)
Sup(sno,sname
,addr,city,phone)
Many
to many relationship with rate and discount
1)Insert
a row in item table
2)Find
the rate and discount of the item keyboard.
3)Count
the number of items supplied by supplier ‘Mr.SATHE’
4)Display
the details of all suppliers from
‘Banglore ‘ city
5)Display
item name in descending order of quantity
6)Display
supplier names in ascending order.
2)Game(gno,gname.no-of-player,coachname)
Player(pno,pname)
Many-Many
Relationship
1)Insert
a row in Game table
2)List
total number pf players playing “Basket BALL”
3)Display
all players having coach as “Mr.Dixit”
4)Add
birth date column to player table.Use alter table command
5)List
all games played by Amit
6)Count
toatal no. of players whose coach name is “Mr.Sharma”
7)Delete
a row from Game table for game “cricket”
8)Display
all players who play game “Table Tennis”
9)List
all games played by Rajesh
10)Add
column Age in the player table
11)Count
total no.of players whose coach is “Kiran”
12)Count
max no.of players in a game.
3)Item(Ino,Iname,Iqty)
Po(Pno,pdate)
Supplier(sno,snmae,saddr)
Item
and Po (one to many)
Supplier
and Po(one to many)
1)Insert
a row in item Table
2)List
the name of supplier to whom Po is given for mouse.
3)List
the name of supplier and itemname in Po’s generated on 30-sep-2009
4)List
the names of suppliers who is going to supply monitor with minimum cost
5)Find
out Po number,po date and supplier name
of the po which is of maximum amount
6)Display
all Po which contains the number,date,supplier name of the Po details of all
items included in that i.e name of item,qty,rate,
4)ALBUM(id,name,category,release-year)
SINGER(Sid,name,address)
Many-Many
1)Insert
a row in singer table
2)Display
all album details of Singer ‘Himesh Reshmiya’
3)Count
all the album names released in the year 2010
4)Add Gender column to singer table
5)Display
all albums names from classical category
6)change
the singer address from Delhi to Mumbai
5)Enployee(eno,enmae,salary,commission,designation)
Department(dno,dnmae,location)
Many-to-one
1)Display
all details of employees who are working at ‘pune’location
2)Display
department name wise list of employees
3)Count
the number of employees who are working in computer department
4)Display
Maximum salary for every department
5)Display
average salary for every designation.
6)Update
commission for every employees by 5% for all department.
Invoice
Hilltop
Animal Hospital Date: Jan 14
2018
Invoice
No.97
Mr.Richard
Cook
490
This Street
England
PET Procedure Amount
Rover Rabbies Vaccination 400
Morris Rabbies Vaccination 700
Total ------------------------
1100
Tax(10%)
------------------------------------------------------------
Amount
Owing 1210=00
Normalize
the above case upto 3 NF.
