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.
| Course Title: DATABASE SYSTEMS | Course Code: CS-400 |
| Discipline /Program : BSCS 2nd Semester | Total Marks: 40 |
| Time allowed: 2 Hour | Instructor’s Name: Confidential |
Question #1: 4+4=8 marks
- Convert the following table into 1st normal form.
| emp_id | emp_name | emp_address | emp_mobile |
| 101 | James | UK | 2390231 |
| 102 | Asad | Lahore | 881212
9900012 |
| 103 | Ron | US | 8881212 |
| 104 | Rocky | Paris | 12300
80345 |
- Convert the following table into 2nd normal form.
| teacher_id | subject | teacher_age |
| 111 | Biology | 38 |
| 111 | Physics | 44 |
| 222 | Chemistry | 38 |
| 333 | Physics | 49 |
| 333 | Maths | 40 |
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:
- Built the tables according to requirements and also label the data types of each attribute in each table. Also, label the primary key.
- 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.
| Course Title: DATABASE SYSTEMS | Course Code: CS-400 |
| Discipline /Program : MCS 1st Semester | Total Marks: 40 |
| Time allowed: 2 Hour | Instructor’s Name: Confidential |
Question #1: 10 marks
What is database normalization? Explain 3rd 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 2nd Normal Form. Remove Partial Dependency form given relation.
Where StdID and CourselD is Composite key.
StdiD StdName CourseID CNIC DOB Grade Skills