database/Database System BE/BS/Intermediate 4 Semester/Term 2024
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
Need a paper or stuck on a question? Ask here — students reply and you get an email.
Ask about a paperPaper text
University of Sargodha
BS 4 Term Examination 2024
Paper: Database System (CMPC-202/204)
Subject: SE/CS
Time Allowed: 02:30 Hours
Note: Objective part is compulsory. Attempt any three questions from subjective part.
Objective Part
(Compulsory)
Q.1.
ii.
¡ii.
IV.
V.
vi.
vii.
Vili.
Write short answers of the following in 2-3 lines of each on your answer sheet.
What is Meta Data?
What is difference between simple attribute and composite attribute?
What is the difference between multivalued and derived attribute?
Write a note on Redundancy and Consistency.
Write down the limitations of Hierarchical and Network model.
Referential integrity constraint.
Schema.
Virtual table.
Maximum Marks: 40
(2*8)
Q.2.
Q.3.
Q.4.
Q.5.
Q.6.
Subjective Part
(3*8)
The following tables exist in a university database.
STUDENT (StudentId int PRIMARY KEY, Stud_Name varchar NOT NULL);
Course (Courseid char (7) PRIMARY KEY, Cour_Name varchar NOT NULL, NoOfPts int NOT NULL):
ENROLLED (StudentId int NOT NULL REFERENCES Student, Courseld char (7) NOT NULL
REFERENCES Course, Grade char (2), PRIMARY KEY (StudentId; Courseld));
_SPORT (StudentId int NOT NULL REFERENCES Student, Sport_Name varchar NOT NULL,
PRIMARY KEY (Studentld, Sport Name));
Write SQL queries for the database above to do the following:
. a. Retrieve names of students that have enrolled the course with the name Database Systems.
b. Retrieve students whose name start with capital letter S.
c. Retrieve student id's and student names of students that passed at least one course with a grade better
than B+ (i.e. A-, A, or A+). Avoid duplicates.
d. Retrieve names of students who have enrolled in Database Systems.
i enrole in Database Systems
Develop an EER model for the following situation.
A person may be employed by one or more organizations, and each organization may be the employer of
one or more persons. An organization can be an internal organizational unit or an external organization. For
persons and organizations, we want to know their ID, name, address, and phone number. For persons, we
want to know their birth date, and for organizations, we want to know their budget number. For each
employment, we want to know the employment date, termination date, and bonus. Employment of a person
by an organization may result in the person holding many positions over time. For each position, we want
to know its title, and each time someone holds that position, we need to know the start date and termination
date and salary. An organization is responsible for each position. It is possible for a person to be employed
by one organization and hold a position for which another organization is responsible
Contrast the top-down nature of database development during conceptual data modeling with the bottom-
up nature of database development during logical database design. What major differences exist in the type
of information considered in each of these two database development steps?
Explain the three level architecture of Database systems?
Convert each of the following schemas to 3NF, showing all intermediate stages, that is, INF and 2NF.
a) CLIENT (Client#, Name, Location, Manager#, Manager_name, Manager_location, (Contract#,
Estimated_cost, Completion_date, (Stati#, Stail_name, Staff_location))).
b) PATIENT (Patient#, Name, DOB, Address, (Prescription#, Drug, Date, Dosage, Doctor#, Doctor,
Secretary))
LK-5434, 5447/12-01-24 -
