MIS602 - Data Modelling and Database Implementation Assignment

Assignment Task

Task Summary

In this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests from an existing database and develop appropriate SQL statements to satisfy those requirements.

Question

1. How many patients are there in the patient table?

2. Write a query to determine if there are more males than females in the patient table. 

3. Retrieve the names of patients who have 'Lee' in their name and 'follow-up' in the appointment notes. 

4. Retrieve the medications that have been prescribed for patients whose names ending with 'Smith’. 

5. List the doctors who have not been assigned any appointments using a subquery. 

6. Retrieve the doctors who have prescribed medications containing 'pain' in their description more than 2 times.

7. Write a query to find patients who have appointments scheduled in the month of June 2023. 

8. Write a query to find the doctor with the highest number of appointments scheduled in a single day 

9. List the total number of appointments based on the day of the week 

10. Display the patients if they are sharing the same birth month as another patient 

11. How many patients have never had an appointment or scheduled any appointments so far?

12. Show medications that have never been prescribed to by any doctor using a JOIN of your choice.

13. List the doctors who have treated at least one patient from ‘WA’ 

14. Which medicine has the second-highest overall prescription rate?

15. Retrieve the patients who have never cancelled an appointment. 

16. Retrieve the youngest and oddest female patient. 

17. Find medications that have appeared only once in any prescription.

18. Find medications that have appeared only once in any prescription along with the doctors who prescribed them. 

19. Retrieve the patients who have had appointments with at least three different doctors

20. In not more than words, comment on whether the tables are in 3NF. Justify your argument with relevant examples, and then explain at least two ways to improve this database based on

This MIS602 - IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.