{"id":343,"date":"2023-12-27T09:43:46","date_gmt":"2023-12-27T09:43:46","guid":{"rendered":"https:\/\/britainwriters.com\/answers\/?p=343"},"modified":"2023-12-27T09:43:48","modified_gmt":"2023-12-27T09:43:48","slug":"how-many-patients-are-there-in-the-patient-table","status":"publish","type":"post","link":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/","title":{"rendered":"MIS602 – Data Modelling and Database Implementation Assignment"},"content":{"rendered":"\n

Assignment Task<\/strong><\/h3>\n\n\n\n

Task Summary<\/strong><\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Question<\/strong><\/p>\n\n\n\n

1. How many patients are there in the patient table?<\/p>\n\n\n\n

2. Write a query to determine if there are more males than females in the patient table. <\/p>\n\n\n\n

3. Retrieve the names of patients who have ‘Lee’ in their name and ‘follow-up’ in the appointment notes. <\/p>\n\n\n\n

4. Retrieve the medications that have been prescribed for patients whose names ending with ‘Smith\u2019. <\/p>\n\n\n\n

5. List the doctors who have not been assigned any appointments using a subquery. <\/p>\n\n\n\n

6. Retrieve the doctors who have prescribed medications containing ‘pain’ in their description more than 2 times.<\/p>\n\n\n\n

7. Write a query to find patients who have appointments scheduled in the month of June 2023. <\/p>\n\n\n\n

8. Write a query to find the doctor with the highest number of appointments scheduled in a single day <\/p>\n\n\n\n

9. List the total number of appointments based on the day of the week <\/p>\n\n\n\n

10. Display the patients if they are sharing the same birth month as another patient <\/p>\n\n\n\n

11. How many patients have never had an appointment or scheduled any appointments so far?<\/p>\n\n\n\n

12. Show medications that have never been prescribed to by any doctor using a JOIN of your choice.<\/p>\n\n\n\n

13. List the doctors who have treated at least one patient from \u2018WA\u2019 <\/p>\n\n\n\n

14. Which medicine has the second-highest overall prescription rate?<\/p>\n\n\n\n

15. Retrieve the patients who have never cancelled an appointment. <\/p>\n\n\n\n

16. Retrieve the youngest and oddest female patient. <\/p>\n\n\n\n

17. Find medications that have appeared only once in any prescription.<\/p>\n\n\n\n

18. Find medications that have appeared only once in any prescription along with the doctors who prescribed them. <\/p>\n\n\n\n

19. Retrieve the patients who have had appointments with at least three different doctors<\/p>\n\n\n\n

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<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-343","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nMIS602 - Data Modelling and Database Implementation Assignment - My Blog<\/title>\n<meta name=\"description\" content=\"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MIS602 - Data Modelling and Database Implementation Assignment - My Blog\" \/>\n<meta property=\"og:description\" content=\"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests\" \/>\n<meta property=\"og:url\" content=\"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/\" \/>\n<meta property=\"og:site_name\" content=\"My Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-27T09:43:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-27T09:43:48+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/person\\\/c698e0f0b4a723b0d250ea199e68a6d3\"},\"headline\":\"MIS602 – Data Modelling and Database Implementation Assignment\",\"datePublished\":\"2023-12-27T09:43:46+00:00\",\"dateModified\":\"2023-12-27T09:43:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/\"},\"wordCount\":340,\"publisher\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/\",\"name\":\"MIS602 - Data Modelling and Database Implementation Assignment - My Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#website\"},\"datePublished\":\"2023-12-27T09:43:46+00:00\",\"dateModified\":\"2023-12-27T09:43:48+00:00\",\"description\":\"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/how-many-patients-are-there-in-the-patient-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MIS602 – Data Modelling and Database Implementation Assignment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#website\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\",\"name\":\"My Blog\",\"description\":\"My WordPress Blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\",\"name\":\"My Blog\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/bw-logo.png\",\"contentUrl\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/bw-logo.png\",\"width\":379,\"height\":81,\"caption\":\"My Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/person\\\/c698e0f0b4a723b0d250ea199e68a6d3\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/britainwriters.com\\\/website\"],\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MIS602 - Data Modelling and Database Implementation Assignment - My Blog","description":"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/","og_locale":"en_US","og_type":"article","og_title":"MIS602 - Data Modelling and Database Implementation Assignment - My Blog","og_description":"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests","og_url":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/","og_site_name":"My Blog","article_published_time":"2023-12-27T09:43:46+00:00","article_modified_time":"2023-12-27T09:43:48+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/#article","isPartOf":{"@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/"},"author":{"name":"admin","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/person\/c698e0f0b4a723b0d250ea199e68a6d3"},"headline":"MIS602 – Data Modelling and Database Implementation Assignment","datePublished":"2023-12-27T09:43:46+00:00","dateModified":"2023-12-27T09:43:48+00:00","mainEntityOfPage":{"@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/"},"wordCount":340,"publisher":{"@id":"https:\/\/britainwriters.com\/answers\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/","url":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/","name":"MIS602 - Data Modelling and Database Implementation Assignment - My Blog","isPartOf":{"@id":"https:\/\/britainwriters.com\/answers\/#website"},"datePublished":"2023-12-27T09:43:46+00:00","dateModified":"2023-12-27T09:43:48+00:00","description":"n this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests","breadcrumb":{"@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/britainwriters.com\/answers\/how-many-patients-are-there-in-the-patient-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/britainwriters.com\/answers\/"},{"@type":"ListItem","position":2,"name":"MIS602 – Data Modelling and Database Implementation Assignment"}]},{"@type":"WebSite","@id":"https:\/\/britainwriters.com\/answers\/#website","url":"https:\/\/britainwriters.com\/answers\/","name":"My Blog","description":"My WordPress Blog","publisher":{"@id":"https:\/\/britainwriters.com\/answers\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/britainwriters.com\/answers\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/britainwriters.com\/answers\/#organization","name":"My Blog","url":"https:\/\/britainwriters.com\/answers\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/logo\/image\/","url":"https:\/\/britainwriters.com\/answers\/wp-content\/uploads\/2023\/12\/bw-logo.png","contentUrl":"https:\/\/britainwriters.com\/answers\/wp-content\/uploads\/2023\/12\/bw-logo.png","width":379,"height":81,"caption":"My Blog"},"image":{"@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/person\/c698e0f0b4a723b0d250ea199e68a6d3","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/britainwriters.com\/website"],"url":"https:\/\/britainwriters.com\/answers\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/comments?post=343"}],"version-history":[{"count":1,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/343\/revisions"}],"predecessor-version":[{"id":344,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/343\/revisions\/344"}],"wp:attachment":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/media?parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/categories?post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/tags?post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}