Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

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 database system.

Course Title: DATABASE  SYSTEMSCourse Code: CS-400
Discipline /Program :  BSCS 2nd   SemesterTotal Marks: 40
Time allowed: 2 HourInstructor’s Name: Confidential

Question #1:                                                                                                               4+4=8 marks

  1. Convert the following table into 1st normal form.
emp_idemp_nameemp_addressemp_mobile
101JamesUK2390231
102AsadLahore881212

9900012

103RonUS8881212
104RockyParis12300

80345

  1. Convert the following table into 2nd normal form.
teacher_idsubjectteacher_age
111Biology38
111Physics44
222Chemistry38
333Physics49
333Maths40

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 university management system(Online application) according to the following requirements;

A Teacher should log in 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 Hierarchical data model? Explain hierarchical data model in detail.

Database Systems Past Paper  for MCS Students

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

Course Title: DATABASE  SYSTEMSCourse Code: CS-400
Discipline /Program MCS 1st   SemesterTotal Marks: 40
Time allowed: 2 HourInstructor’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, multivalued attribute, etc.

Question #4:                                                                                                               10 marks

Define and explain Data Conversion and Loading Testing?

Fazal Rehman Shamil Click Here to Know More
Instructor, Researcher, Blogger, SEO Expert, Poet and Publisher of International Journal Of Software, Technology & Science ISSN : 2616 - 5325
Dear Professors and Resarchers!You are welome to Cite these tutorials in your research or slides etc. Please don't forget to mention the reference of website. Copy Paste of text is strcitly forbidden. Images can be reuse because images are protected with watermark.