NOBEL COLLEGE
Sinamangal, Kathmandu
Final Assesment 2005
Section :BCIS IV F.M 100
Subject : DBMS P.M 50
Time:3 hrs
Attempt all the questions.
1. a. Explain the advantages and disadvantages of the DBMS [8]
b What are the various component of DBSM [7]
2. a. Explain the E-R data model with the suitable example. [9]
b) Explain the importance of feasibility study in database design [6]
3. a. Explain the importance of the normalization in database. Explain about the first, second and third normal form. [9]
b. Consider the following table with the given functional dependencies, primary keys are underlined: [6]
Drinkers (name, address, beersLiked, manufacturer, favBeer)
name->address, favBeer
beersLiked->manufacturer
State in which normal form the given table is and normalize it up to 3NF.
4. a. Consider the following class diagram and write the SQL syntax to create necessary tables. [7]
 |
b. Write SQL syntax to perform the following operations:[4X2=8]
I. Insert data into the employee table
II. Alter table department to add column branch.
III. Show name of all employees who live in Kathmandu.
IV. Display the no. of employees working in each department.
6. a. Define the functions of Data Administrator and Database Administrator. [8]
b. Explain the Cryptographic technique used in the database.[7]
7. a. Define Distributed Database System with its important properties.[8]
b. What is client server database? Explain its advantage over file server.[7]
8. Write short notes. (Any two): [5X2=10]
a) Data types
b) Transaction
c) Horizontal and vertical partitioning.
****Good Luck****
No comments:
Post a Comment