Database Systems Past University  Papers 

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

  1. 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

  1. 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:

  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.

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?

Latest posts by Prof. Fazal Rehman Shamil (see all)

Buy advertisement space on T4Tutorials

For more details email [email protected]