Database Management Systems — DU B.Sc. (Prog) Physical Science courses pertaining to Computer Science Previous Year Question Papers

5. Parts of a question must be answered together. What are the different types of database users? (b) Draw the symbols that are used in ER diagram for representing the following: 3 i) Composite Attribute ii) Multivalued Attribute iii) Derived Attribute (c) Consider the following relational schema and identify the foreign keys: 3 CUSTOMER(Cust#, Chame, Phone, City) ORDER(Order#, Odate, Cust#, Order Amount) ORDER_ITEM(Order#, Item#, Qty) ITEM(Item#, ItemName, UnitPrice) (d) Consider the following table: S1 Raman C101 DBMS Dr. Jain S3 Raman C101 DBMS S4 Amit C103 Networks For the given relational state, check if the following functional dependencies exist or not: (e) Consider entity types DOCTOR and PATIENT. A doctor has DoctorlD, 3 DoctorName and Specialization. A patient has PatientID, PatientName and Disease as attributes. A doctor can treat at most one patient at a time while a patient can consult at most three doctors for a disease. How will you draw these entities in an ER diagram using (min, max) notation. (f) Consider the relation: 3 COMPANY(EmpID, EmpName, Dept, MonthlySalary). Write a command to create a view showing all employees of 'IT' department and their MonthlySalary > 30000. !-" (g) Consider a Relation R(A, B, C, D, E) with following Functional 3 Find closure of A (At) and decide whether (A) is a candidate key or not. FD3: CD → E Give reason for your answer. (h) Show the resulting relation affer performing the FULL OUTER JOIN on the following relations STUDENT and MARKS: MARKS Marks STUDENT StudentID StudentID Name 90 (i) situations role names are essential? What is the significance of role names in the relationship? In what () Define ACID properties in the context of a database transaction. Q2 (a) Discuss five main advantages of using Database Management System. (b) Consider the following instance of a relation PRODUCT_SUPPLIER: SPI Dell Stationers Pune PD1 Pen Delhi Pencil SP2 Om Stationers PD2 SP2 Om Stationers Delhi PD3 Eraser Mumbai Folder SP3 HP Stationers Sheets SP2 Om Stationers Explain the kind of anomalies (if any) that may occur if we apply the following operations on the above table: i) Insert a new supplier (SP4, Golden Stationary, Delhi) who has not supplied any product yet. ii) Delete the product PD3 as it is no longer needed. i11) Supplier SP2 has moved from Delhi to Noida. iv) Delete the product PDI. V) Insert a new product (PD5, Marker) whose supplier is not yet known. (c) which of the DBMS LANGUAGES will be used to specify each of the In DBMSs where a clear distinction is maintained between the three levels. y To insert, delete and modify data i) To retrieve data ii) To create user views iii) To specify conceptual schema iv) To add a new constraint to a table v) Explain thre-schema architecture and draw a diagram. Why do we need ; 16 (a) mappings between schema levels? (b) Draw an Entity Relationship diagram for the Recording Studio having the 10 following requirements: