Database Systems Past University  Papers

Here, we are sharing with you a sample paper of database system for BSCS, BSSE, BSIT and MCS students

Database Systems Past Paper for BSCS, BSIT, and BSSE Students

Here, we are sharing with you a sample paper of the database system.

Question #1:                                                                                                               4+4=8 marks

1. Convert the following table into 1^st normal form.

1. Convert the following table into 2nd normal form.

Question #2:                                                                                                               8 marks

What are the facts? How facts are collected? Explain different facts about finding techniques?

Question #3:                                                                                                               4+4=8 marks

You are hired in a software house and  need to design a database for the university management system(Online application) according to the following requirements;

A Teacher should log in to the system and take the attendance of the students.

The teacher can also save the marks of the student in the database.

The teacher can upload the helping material like books and assignments.

A student can view books and assignments. A student can also message to his/her teacher.

Instructions:

1. Built the tables according to requirements and also label the data types of each attribute in each table. Also, label the primary key.
2. Draw the Entity-relationship diagram of the tables.

Question #5:                                                                                                               8 marks

What is the Hierarchical data model? Explain the hierarchical data model in detail.

Database Systems Past Paper  for MCS Students

Here, we are sharing with you a sample paper of the database system.

Question #1:                                                                                                               10 marks

What is database normalization? Explain 3^rd normal form in detail

Question #2:                                                                                                               10 marks

What are the facts? How facts are collected? Explain different facts about finding techniques?

Question #3:                                                                                                               10 marks

What is the ER Diagram? Explain in context of the attribute, strong entity, week entity, multi-valued attribute, etc.

Question #4:                                                                                                               10 marks

Define and explain Data Conversion and Loading Testing?

[OBJECTIVE]

Subject: Database Systems (CMP)

Time Allowed: 15 Minutes

Maximum Marks: 10

NOTE: Attempt this Paper on this Question Sheet only.  Please encircle the correct option. Division of marks is given in front of each question. This Paper will be collected back after expiry of time limit mentioned above.

Part-I Encircle the right answer, cutting and overwriting are not allowed. (10)

1. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
2. For each attribute of a relation, there is a set of permitted values, called the of that attribute.
a) Domain
b) Relation
c) Set
d) Schema
3. By default SQL server has _________ isolation level
a) READ COMMITTED
b) READ UNCOMMITTED
c) SERTALIZABLE
d) REPEATABLE READ
4. The deadlock state can be changed back to stable state by using statement.
a) Commit
b) Rollback
c) Savepoint
d) Deadlock
5. An attribute is a _______ in a relation.
a) Row
b) Column
c) Value
d) Tuple
6. Which command is used to create a new relation in SQL?
a) create table
b) create relation
c) new table
d) new relation
7. What does this query do? Select distinct dept_name from institute;
a) It gives all the tuples having a distinct dept_name
b) It gives the dept_name attribute values of all tuples without repetition
c) It gives all the dept_name attribute of all the tuples
d) It gives all the tuples having a null value under the dept_name attribute
8. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are and course is a
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
9. Foreign key is the one in which the ______ of one relation is referenced in another relation.
a) Foreign key
b) Primary key
c) References
d) Check constraint
10. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
a) Single valued
b) Multi valued
c) Composite
d) Derived

[SUBJECTIVE]

Subject: Database Systems (CMP)

Time Allowed: 2 Hours 45 Minutes

Maximum Marks: 50

NOTE: ATTEMPT THIS (SUBJECTIVE) ON THE SEPARATE ANSWER SHEET PROVIDED.

Part-II-A Give short notes on following, each question carries equal marks. (20)

Q#1: Explain Group By Clause in SQL

Q#2: Define theta join with an example.

Q#3: What is the use of IN operator in SQL command?

Q#4: What is concurrency and deadlock?

Q#5: Define multivalued attribute with an example.

Part-II-B Write SQL queries for the given statements. (10)

Q#1: Show the name and salary of all clerks having salary grade 1 and 2 or manager

Q#2: how the dept name, Grade and ename of all employees working in New york or Chicago.

Q#3: Show name of those employees working with king and getting less sal than king but hired before king.

Q#4: Show name of all employees getting salary more than king but less than any employee of dept 20 and more than any employee of department 30

Q#5: Show name and salary of all employees working with KING and getting salary less than the king.

Emp (empno,ename,sal,comm,hiredate,mgr,deptno)

Dept(deptno,dname,loc}

SalGrade (Grade,minsal,maxsal)

Tables for queries

Part-III Give detailed answers, each question carries equal marks. (30)

Q#1: Explain Three Tire ANSI-SPARC Architecture.

Q#2: Explain ACID properties of transaction with example.

Q#3: Define 2^nd Normal Form. Remove Partial Dependency form given relation.

Where StdID and CourselD is Composite key.

StdiD                     StdName             CourseID             CNIC                      DOB                       Grade                   Skills