Need Help ?
Have a Question ?

(Solved): 10 Points) Single Underline A Primary Key, Double Underline Every Foreign Key, And Cycle Every Candi ...

please help solve quick will thumbs up
10 points) Single underline a primary key, double underline every foreign key, and cycle every candidate key for the followin
10 points) Single underline a primary key, double underline every foreign key, and cycle every candidate key for the following relations. A staff of a doctor can alos be a patient An employee can not be a staff and a doctor at the same time. A patient does not have to be a US citizen. A patient cannot be admitted twice at any date. The driverno is the driver license number and ssno is the social security number. Any assumption has to be logical and realistic without changing the problem. (Minus 1 point for each wrong answer) Patient (patno, name, add, ssno, driverno) Staff (staffno, name, add, ssno, driverno) Doctor (docno, name, add, ssno, driverno) Admission (roomno, patno, startdate, enddate, staffno) Room (roomno, type, fee) Drug (drugno, drugname, drugsalesprice, drugprice) Prescription (prescno, docno, patno, drugno, stardate, enddate) 12. Given the following relations: Patient (patno, name, add, ssno, driverno) Staff (staffno, name, add, ssno driverno) Doctor (docno, name, add, ssno, driverno) Admission (roomno, patno, startdate, enddate, staffno) Room (roomno, type, fee) Drug (drugno, drugname, drugsalesprice, drugprice) Prescription (prescno, docno, patno, drugno, stardate, enddate) Formulate the following queries in relational algebra. (a) (13 points) What is the total fee collected from each room type during January 2020. The report should have type and total fee.

Expert Answer


Check out the solution and do comment if any queries. ______________________________ ______ Explanation :: R1 <- selects all records f
We have an Answer from Expert Buy This Answer $6