Scribd
Upload
271 views

Database System Final 2021 Paper

The document contains instructions for a database systems final exam, asking students to answer 6 questions related to database concepts like normalization, transaction concurrency control, DBMS architecture, entity relationship diagrams, SQL commands, and relational algebra expressions. Students are asked to justify their answers, draw tables, separate DDL and DML commands, and write relational algebra expressions for given queries.

Uploaded by

harisafridi09876
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
271 views

Database System Final 2021 Paper

The document contains instructions for a database systems final exam, asking students to answer 6 questions related to database concepts like normalization, transaction concurrency control, DBMS architecture, entity relationship diagrams, SQL commands, and relational algebra expressions. Students are asked to justify their answers, draw tables, separate DDL and DML commands, and write relational algebra expressions for given queries.

Uploaded by

harisafridi09876
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

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 3 rd 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.
Q5. Separate DDL and DML Sql command s 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.

You might also like