Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Consider the relations described below: PHYSICIAN (regno, name, telno, city)PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname identify the physician and the patient uniquely corresponding. Express queries (i) to (iii) in SQL.(i) Get the name and regno of physicians who are in Delhi.(ii) Find out the name and city of patient(s) who visited a physician on 31 August 2004.(iii) Get the name of the physician and the total number of patients who have visited her.(iv) What does the subsequent SQL query answer SELECT DISTINCT nameFROM PHYSICIAN PWHERE NOT EXISTS( SELECT *FROM VISITWHERE regno = p.regno )
(i) Select name, regno from PHYSICIAN where city = ‘Delhi'; (ii) Select pname, city from PATIENT,VISIT where PATIENT.pname=VISIT.pname and date_of_visit = '31-Aug-04'; (iii) select name, count(*) from PHYSICIAN, VISIT where PHYSICIAN.regno = VISIT.regno group by Physician . regno; (iv) This will provide the name of physicians who have not visited any patient.
What is banker's algorithm? Banker's algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple instances of each resource ty
Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.
What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.
What is a candidate key? Minimal super keys are known as candidate keys.
While using extract datasets it is required to have a special workarea for interface False. It is not required to have a special workarea for interface
Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering
Hardware failure : Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and
Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent
Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s
various techniques of hashing?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd