Islamic Asian Colleges Past Paper 1st Term

ISLAMIC ASIAN COLLEGE OF COMMERCE, KHARIAN

COMPUTER (DBMS & OS)	1ST TERM EXAMS 2019 SECTION – I	TIME 2 HOURS
B.SC –II		MAX MARKS: 50

Note:   Attempt any FOUR questions. All question carry equal marks.

Q.1      a) Define attribute and its types.                                                                                4

            b) Normalize the following “Patient_visit” relation up to 3^rd Normal form but step by step show each                         intermediate resultant table with its data.                                                       8.5

(Patient Visit)

Do_ID	Doc_Name	Pat_ID	Pat_Name	P.adrs	Ch.Date	Ch.Fee
01	Dr. Toqeer	1 2 3	Umar Ibrahim Shahzad	Lahore Sialkot Okara	12-03-13 13-03-13 13-03-13	500 1500 750
02	Dr. Farhat	1 2 5	Umar Ali Farhan	Lahore Sialkot Okara	12-03-13 12-03-13 14-03-13	800 1000 1000

Note:   Doc_IDÞDoctor id                 Doc_NameÞDoctor Name    Pat_IDÞPatient ID

Pat_NameÞPatient Name     P.adrsÞPatient Address

Q.2      a) What is DBMS? Also discuss different components of DBMS.                                           8

            b) Define primary key. Foreign key and also discuss briefly role of these keys in database integrity. 4.5

Q.3      Identify entities with attributes, relationship and draw an ERP for the following SSQ University. Use following requirements & take you own assumptions (if needed).

A SSQ University consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students.

Q.4      a) Discuss three different phases of process scheduling.                                                      6

            b) Define lpc in detail.                                                                                                      6.5

Q.5      a) Explain kernel.                                                                                                             4.5

            b) Define deadlock. Write a detailed note on deadlock avoidance.                                      8

Q.6      a) Discuss briefly functions of Application layer of OSI model.                                            6

            b) What is transmission mode and discuss different types of transmission mode with examples. 6.5