1 / 2

database system 2021 p

Please tell

31813
Download Presentation

database system 2021 p

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Roll No_________ Name ___________________ Faculty of management and computer science Database System Final Exam (2021) Class: BS (CS) 4rth Attempt All 6 Question. Q1. is the given table in first normal form? In case of Yes/No justify your answer. And normalize the given table up to 3rd normal form. Q2. why concurrency control is needed in transaction. And why Acid properties in transaction is important. Q 3. Explain three level architecture in DBMS with diagram Q4. Draw tables for the give ER diagram. And discuss the weak and strong entity from the given diagram.

  2. Q5. Separate DDL and DML Sql commands from the given queries. I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20), Email VARCHAR2(100), DOB DATE); II. DROP TABLE EMPLOYEE; III. ALTER TABLE STU_DETAILS ADD (ADDRESS VARCHAR2(20)); IV. INSERT INTO javatpoint (Author, Subject) VALUES ("Sonoo", "DBMS"); V. UPDATE students SET User_Name = 'Sonoo' WHERE Student_Id = '3' VI. DELETE FROM Studen_table WHER city= “Peshawar”; Q6. Write the relational algebra expression for the following queries I. Find all tuples from player relation for which country is Pakistan II. Select all the tuples for which runs are greater than or equal to 15000. III. List all the countries in Player relation.

More Related