Question 1) Consider the given relationships:
Doctor (doct_no, doct_name, doct_address, doct_city)
Hospital (hosp_no, hosp_name, street, hosp_city)
Doct_Hosp (doct_no, hosp_no, date)
Solve queries in Relational Algebra:
(i) Find hospital name to which Dr. Padghan has visited.
(ii) Determine all doctors who have visited hospital in the same city.
(iii) Write name of hospital to which Dr. Shirsat has visited on 08/01/2010.
(iv) Write all doctors who visited ‘Padghan Hospital’.
(v) Write name of Hospital in ‘Shrirampur’.
Question 2) Consider the given relationships:
Player (pno, name, city)
Game (gno, name, place)
Player_Game (pno, gno, date)
Solve queries in Relational Algebra:
(i) Determine list of players playing ‘Cricket’.
(ii) Determine list of games played by more than 10 players.
(iii) Determine list of players and games played on ‘March 4, 2010’.
(iv) Write all available games in India.
(v) Write players playing cricket and football.
Question 3) Shramik Vidhyapit offers 10 courses on ‘Information Technology’.
Each course is conducted in several batches, where a maximum batch size is of 50 students. For every batch separate instructor is appointed. When for the particular course minimum 25 students get admitted, then the timetable is prepared and separate classrooms and also instructors availability, daily one hour is allocated to each batch. As numbers of students is growing, it is difficult to the management to schedule the course. Suggest a suitable information system to handle the above problem:
(i) Draw a Entity-Relation Diagram for Information System Design.
(ii) Convert Entity-Relationship Diagram into Relational Database in 3NF.
Question 4) Describe Degree of Relationship Type.
Question 5) Distinguish between Single Attribute and Multivalued Attribute.