please help solve quickly will thumbs up

(0 points) Single underline a primary key, double underline every foreign key, and cycle every candidate key for the following relations. A staff or 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. 13 points) What is the total fee collected from each room type dunny January 2020. The report should have type and total fee. (d) (13 points) The details of all rooms, including the name of the patient staying in the room if the room is occupied as yesterday. 13. (12 point) Use the following set of key values to construct a B+ tree index, assuming maximum 4 pointers per node. (17, 25, 76, 35, 52, 46, 99, 19, 23, 18, 41, 53, 56) (b) (13 points) A list of staff who did not admit any patient yesterday. The list should have staffno and staff name. (C) (13 points) Generate a list of doctor who only subscibs vitamin C to patients during last year. The list should contain docno and doctor name (0 points) Single underline a primary key, double underline every foreign key, and cycle every candidate key for the following relations. A staff or 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. 13 points) What is the total fee collected from each room type dunny January 2020. The report should have type and total fee. (d) (13 points) The details of all rooms, including the name of the patient staying in the room if the room is occupied as yesterday. 13. (12 point) Use the following set of key values to construct a B+ tree index, assuming maximum 4 pointers per node. (17, 25, 76, 35, 52, 46, 99, 19, 23, 18, 41, 53, 56) (b) (13 points) A list of staff who did not admit any patient yesterday. The list should have staffno and staff name. (C) (13 points) Generate a list of doctor who only subscibs vitamin C to patients during last year. The list should contain docno and doctor name