Punjab Technical University 2010-4th Sem B.Sc BioInformatics BI (403) (th) Management Of Biological Database - Question Paper
Roll No.......................
Total No. of Questions : 13] [Total No. of Pages : 02
(Please fill this Paper ID in OMR Sheet)
B.Sc. BI (403) (S05/OLD) (Sem. - 4th)
MANAGEMENT OF BIOLOGICAL DATABASES
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) Section -A is Compulsory.
2) Attempt any Nine questions from Section - B.
Section - A<
(252 = 30) QI)
a) Define Database System.
b) What is the purpose of using a Data Model?
c) What is Transaction in DBMS? Give examples.
d) With proper example, explain meaning of a relationship in ER Model.
e) Differentiate between Entity & Relation in Relational Model.
f) Write four basic Set Operations applicable to Relation also.
g) SQL is Non - Procedural Language. Explain.
h) Write a SQL command to create a Table.
i) What is Functional Dependency? Give Ex.
j) Where do we need Decision Support System? Give One Application.
k) Write full form of DBTG CODASYL.
l) Explain relation between Canvas and Label.
m) Define Event. Write name of Two Mouse Event.
n) Write applications of Reports in Business.
o) Define Data Warehouse.
J-8222[S-9700366]
P.T.O.
Q2A Differentiate between Network Model and Relational Model.
QQ How many different types of users are there in Database System. Explain their roles.
Q4) Write purpose and syntax of extended relational algebra operations.
Q5) With proper example, show how Normal Join differs from Equi Join.
QT Draw an ER Model for any School with Proper Assumptions.
QUA Take one table and show how do you find in which Normal Form that table is.
Q8) Explain various applications of Databases in Education.
Q9) Explain Basic Components of a Network Model.
Qio) What are integrity constraints? How do you implement them in SQL?
QII) What is Developer 2000? Explain its uses.
Q12) What is Trigger? How do you write them in Developer 2000?
Q13) Explain different types of Databases.
J-8211[S-9700366]
2
|
Attachment: |
| Earning: Approval pending. |
