case-1 : In a single word document, each group to submit a minimum of 10 queries

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

case-1 : In a single word document, each group to submit a minimum of 10 queries

case-1 : In a single word document, each group to submit a minimum of 10 queries (show the queries and the results of running each query) to generate the following:
1. Two stored procedures to populate transactional tables
2. Two basic select statements including WHERE clauses
3. One query with ORDER BY command
4. Two queries with aggregate functions
5. One query with Having command
6. Two use of Subqueries
case-2 : Find the names of all patients who had visits on a date. Hint: Use EXISTS command (look for patients who have a record in the visit table).
Data : Entities and Attributes:
PatientPatientID (PK)
PractitionerPractitionerID (PK)
PractitionerType
PractitionerName
AdministratorAdminID (PK)
AdminDetails
ReceptionistReceptionistID (PK)
ReceptionistDetails
BookkeeperBookkeeperID (PK)
BookkeeperDetails
Medical TechnicianTechnicianID (PK)
TechnicianDetails
PharmacistPharmacistID (PK)
PharmacistDetails
Medical RecordRecordID (PK)
PatientID (FK)
AppointmentAppointmentID (PK)
PatientID (FK)
VisitVisitID (PK)
PatientID (FK)
PrescriptionPrescriptionID (PK)
VisitID (FK)
PatientID (FK)
Laboratory TestLabTestID (PK)
VisitID (FK)
SurgerySurgeryID (PK)
DeliveryDeliveryID (PK)
Recovery RoomRoomID (PK)
BillingBillingID (PK)
VisitID (FK)
PatientID (FK)
…
Insurance CompanyInsuranceID (PK)
GovernmentGovernmentID (PK)
Relationships:
Patient-Appointment: One-to-Many
Practitioner-Appointment: One-to-Many
Practitioner-Visit: One-to-Many
Patient-Visit: One-to-Many
Visit-Medical Record: One-to-One
Visit-Prescription: One-to-Many
Visit-Laboratory Test: One-to-Many
Visit-Billing: One-to-One
Patient-Billing: One-to-Many
Prescription-Billing: One-to-One
Pharmacy-Prescription: One-to-Many
Surgery-Practitioner: Many-to-Many
Surgery-Patient: Many-to-One
Delivery-Practitioner: Many-to-One
Delivery-Patient: Many-to-One
Submission Type : Word Document and oracle text file code Data Description:

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!