Database System Msc IT University Of Sargodha (UOS) 2021
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
Database System MS Computer Science/MSc Computer Science/PhD Computer Science
Uploaded 9 days ago
Download ↓
Database System ADP/BS 2 Semester/Term University Of Sargodha (UOS) 2025
Uploaded 1 month ago · by Jaweria Gull
Download ↓
Database System AD/ADP/BS 2 Semester/Term University Of Sargodha (UOS) 2025
Uploaded 2 months ago
Download ↓
Database System ADP/BS 2 Semester/Term University Of Sargodha (UOS) 2025
Uploaded 9 months ago
Download ↓
Database System BS 2 Semester/Term University Of Sargodha (UOS) 2025
Uploaded 9 months ago
Download ↓
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 10 months ago
Download ↓
Paper text
University of Sarzodha
Subiest Information Exchaokes
Time Allowed: 02:30 Hours
RiST
Cesc: Data Maxe Saten CME 2480
Masimam Marker 80
Note Objecüive part is compubiors. Attempt any three questions from valjective part.
Objective Part
(Compulsory!
0.1. Write short answers of the following in 2-V lines each on your anawer sheet
Detine determinant!
ustadni.com
ne Entity cluster?
rentiate between Entity integrity vs referential mlegnity?
What is concurrency control?
shonly Explain Referential integrity con
Whal is anomaly in database?
What is a transaction?
(25167
VITE
Define Aggregation?
What's the dilference berween Degree and Cardinality in relation?
What's meant by Transitive dependency?
What is anomaly?
What is three tier architecture?
Explain the difference between logical and physical data independence.
Define Integrity Constraints?
Differentiate between subtype and supertype.
ustadni.com
0.2.
Subjective Part
(3-16)
a) List the nine major components in a database system environment
0.3.
by What are the different options to avoid locking? Brielly explain all option.
Hotel (Hotel
Hotel (love oblamen pure a a database heid inaRDOMS.
Room (Room! No, Hotel
Booking (Hotel No. Gues
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 SOL statements to retrieve the following information:
(a) Full details of'all hotels in London.
(b) The average price of a room.
(e) 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 euch hotel in London.
You may af
0.4.
Devalue OPme that dates are stored in the following dd/mm/yyyy format
R model for the following situation.
ustadni ny has a number of employees. The attributes of EMPLOYEE include imployee 1D
Name, and Start Date. Each employee may be
ate may vary by project, und the company wishes to record the applicatle thin. CO Pilling
Rate) for ench emplovee when assigned to a particular project.
Do the attribute names in this description follow the guidelines for Mr
fing attributes? 1f not.
suggest beller 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.
e in the middle of a project?
How would you change your ERD if the Billing Rate could
visit website: ustadni.com