Register

a) Following relational schema is given: Doctor (DName, Reg_no,D_City), Patient (Pname, Disease, P_City) and Assigned To (Pname, Dname) Give expression in Relational Algebra for each of the queries: i) Get the names of patients who are assigned to more than one doctor. ii) Get the names of doctors who are treating patients with 'Polio’. iii) Get the details of doctors who are treating to the patient belongs to the same city. iv) Count the number of patients treated by each doctor

• retagged by
864 views

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
aashijn asked Apr 28, 2022
1,391 views
Que: Consider the relational database of given below, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries:
employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name) a. Find the names of all empl...
User Avatar
0 votes
0 votes
2 answers
2
Neyoa asked May 19, 2022
2,913 views
Suppose an ISP owns the block of addresses of the form 131.210.16.0/21. Suppose it wants to create four subnets from this block, with each block having the same number of IP addresses. i. What are the prefixes (of form a.b.c.d/x) for the four subnets? ii. What is the number of host address that can be supported per subnet?
Suppose an ISP owns the block of addresses of the form 131.210.16.0/21. Suppose it wants to create four subnets from this block, with each block having the same number of...
User Avatar
Link Copied!