Master in Data Science (SMS, TU) Database Management Systems Question Paper 2081 (Set page 8; First Assessment 2081) Nepal

Differentiate between Database and Database Management System

Define candidate key, primary key and foreign key

Describe the property of weak entity with an example

Explain the concept of logical and physical data independence

Differentiate between Cartesian product and natural join.

Draw an ER Diagram for online movie reservation system. Make necessary assumptions

Consider the following schema, write expressions using relational algebra

Suppliers (sid, sname, saddress, sphone) Parts (pid, pname, ptype) Catalog (sid, pid, cost)

a) Find the names of those suppliers whose ptype is of home_appliance b) Find the sid of those suppliers who have supplied ptype as mobile and whose cost is less than Rs. 50,000 c) Find the sid of those suppliers who have supplied all parts

Suppose there are two entity sets A and B where B is weak entity and R is relation. The schema is as follows: A(a1, a2) B(b1, b2, b3). The cardinality between them is many to many. Draw the schema and convert it to relational model.

OR

Explain different types of joins with an example of your own

Perform normalization on the following relation

OR

Find the closure for the relational schema R (A, B, C, D, E, F) and set of functional dependencies $F \{ AB \to C, BC \to AD, D \to E, CF \to B \}$

Write short notes on a) Abstraction b) View