University of Sargodha MSc. 3*i Semester/Term Exam 2021 Subject: Information Technology Paper: Data Base System (CMP 3440)
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.
More Database System papers
See all
University of Sargodha ADP/BS 2"d Semester (F-24) Examination 2025 Subiest: SAT/S Paper: Database System (CMPC-5203) Time Allowed: 02:30 Hours
Uploaded 9 months ago
Download ↓
No preview
BSIT ADPIT Database System UOS 2025
Uploaded 12 months ago
Download ↓
Database Systems BSIT 2024 Sargodha University
Uploaded 2 years ago
Download ↓
Database System BSCS 2023 UOS
Uploaded 3 years ago
Download ↓
Database System MSC IT 2021 Part#2 UOS
Uploaded 3 years ago
Download ↓
Database System MSC IT 2021 Part#1 UOS
Uploaded 3 years ago
Download ↓
Paper text
University of Sargodha
MSc. 3*i Semester/Term Exam 2021
Subject: Information Technology
Paper: Data Base System (CMP 3440)
279K
Time Allowed: 02:30 Hours
Maximum Marks: 80
Note: Objective part is compulsory. Attempt any three questions from subjective part.
Q.1.
Objective Part
(Compulsory)
Write short answers of the following in 2-3 lines each on your answer sheet.
Detine determinant?
it.
i11.
iv.
V.
vi.
Define Entity cluster?
Differentiate between Entity integrity vs referential integrity?
What is concurrency control?
Shortly Explain Referential integrity constraint
What is anomaly in database?
(2*16)
Q.4.
хії.
XIV.
XV.
XI.
What is anomaly?
Explain the difference between logical and physical data indepemdenc@etadihii.com
What is three tier architecture?
Define Integrity Constraints?
Differentiate between subtype and supertype.
Subjective Part
(3*16)
0.2. 1) List the nine major components in a database system environment
b) What are the different options to avoid locking? Briefly explain all options.
2.3.
The following tables forms part of a database held in a RDBMS.
Hotel (Hotel_No, Name, Address)
Room (Room No, Hotel_No, Type, Price)
Booking (Hotel_No, Guest No, Date_From, Date_To, Room_No)
Guest (Guest_No, Name, Address)
where
- Hotel contains hotel details and Hotel_ No is the primary key and
- Room contains room details for each hotel and has (Hotel_No, Room_No) is the primary key.
Assuming the above, give SQL statements to retrieve the following information:
(a) Full details of all hotels in London.
(b) The average price of a room.
(c) The number of hotels.
(d) The number of guests who have made bookings for August
(e) The guests currently staying at the Grosvenor Hotel.
(f The number of rooms in each hotel in London.
You may assume that dates are stored in the following dd/mm/yyyy format.
1 company did a number of employces. The atributes of EMPLOYEE include Employee ID
(identifier), Name, Address, and Birthdate. The company also has several projects. Attributes of
EROJECT include Project ID (identifier), ProjectOahie, and Start Date. Each employee may be
assigned to one or more projects, or may napßò assigned to a project. A project must have at least
one employee assigned and may havezity number of employees assigned. An employee abilling
rate may vary by project, and the company wishes to record the applicable billing-hie (Billing
Rate) for each employee when assigned to a particular project.
Do the attribute names in this description follow the guidelines for nathing attributes? If not.
suggest better names.
Do you have any associative entities on your ERD? If so, what are the identifiers for those
associative entities?
Does your ERD allow a project to be created before it has any employees assigned to it? Explain.
How would you change your ERD if the Billing Rate could change in the middle of a project?
visit website: ustadni.com