{"id":90038,"date":"2022-08-23T05:15:11","date_gmt":"2022-08-23T05:15:11","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/database-health-baptist-memorial-college-of-health-sciences\/"},"modified":"2022-08-23T05:15:11","modified_gmt":"2022-08-23T05:15:11","slug":"database-health-baptist-memorial-college-of-health-sciences","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/database-health-baptist-memorial-college-of-health-sciences\/","title":{"rendered":"Database | HEALTH | Baptist Memorial College of Health Sciences"},"content":{"rendered":"<div>\n<p>\u00a0\u00a0\u00a0<\/p>\n<p>Consider the below schema for a library database and write relational algebra expressions for the following queries \u00a0<\/p>\n<p>\u00a0\u00a0<\/p>\n<p>\u00a0\u00a0\u00a0<\/p>\n<p>1. Author ( <u>authorname,<\/u> citizenship, birthyear)\u00a0<\/p>\n<p>2. Book (<u>isbn<\/u>, title, authorname)<\/p>\n<p>3. Topic (<u>isbn, subject<\/u>)<\/p>\n<p>4. Branch (<u>libname<\/u>, city)<\/p>\n<p>5. Instock (<u>isbn, libname,<\/u> quantity)<\/p>\n<p>1. Give all authors\u2019 names born after 1940. [0.25 Point]<\/p>\n<p>2. Give the names of libraries in Sydney. [0.25 Point]<\/p>\n<p>3. Give the city\/cities and \u201cisbn\u201d where each book is held. \u00a0\u00a0\u00a0[0.25 Point]<\/p>\n<p>4. Give the title of each book on the topic of either alcohol or drugs. [0.25 Point]<\/p>\n<p>5. Give the title and author of each book of which at least two copies are held in a branch located in Melbourne. \u00a0[0.50 Point]<\/p>\n<p>\u00a0\u00a0\u00a0<\/p>\n<p>What is the different between the database schema and the database instance? Give an example for each.<\/p>\n<p>\u00a0\u00a0\u00a0<\/p>\n<p>Name at least three tables that might be used to store information in the following systems:<\/p>\n<p>a. An e-commerce system such as Amazon. \u00a0[0.25 Point]<\/p>\n<p>b. A social media system such as Twitter. \u00a0\u00a0\u00a0[0.25 Point]<\/p>\n<p>c. A health care system. [0.25 Point]<\/p>\n<p>d. A university system. [0.25 Point]<\/p>\n<p>\u00a0\u00a0\u00a0<\/p>\n<p>Given the relation below named <strong>Contact_Info<\/strong>, answer the following questions:<\/p>\n<p>\u00a0\u00a0<\/p>\n<p><u><strong>SSN<\/strong><\/u><\/p>\n<p><strong>Name<\/strong><\/p>\n<p><strong>Phone<\/strong><\/p>\n<p><strong>Email<\/strong><\/p>\n<p><strong>Age<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>234-356<\/p>\n<p>Sara Fahad<\/p>\n<p>340-675-9876<\/p>\n<p>[email\u00a0protected]<\/p>\n<p>22<\/p>\n<p>\u00a0<\/p>\n<p>673-980<\/p>\n<p>Mohammad Ahmed<\/p>\n<p>234-896-2567<\/p>\n<p>[email\u00a0protected]<\/p>\n<p>28<\/p>\n<p>\u00a0<\/p>\n<p>129-678<\/p>\n<p>Waad Saud<\/p>\n<p>280-986-8736<\/p>\n<p>[email\u00a0protected]<\/p>\n<p>31<\/p>\n<p>a. What is the relational schema of the relation Contact_Info? \u00a0[0.25 Point]<\/p>\n<p>\u00a0<\/p>\n<p>b. What is the degree of the giving relation? [0.25 Point]<\/p>\n<p>\u00a0<\/p>\n<p>c. Is the column Name an atomic attribute\/value? If no, justify your answer? [0.25 Point]<\/p>\n<p>d. What are the outputs of the given operations? \u00a0<\/p>\n<p>1. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(Contact_Info) \u00a0[0.50 Point]<\/p>\n<p>2. \u00a0\u00a0(Contact_Info) \u00a0\u00a0[0.25 Point]<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0\u00a0 Consider the below schema for a library database and write relational algebra expressions for the following queries \u00a0 \u00a0\u00a0 \u00a0\u00a0\u00a0 1. Author ( authorname, citizenship, birthyear)\u00a0 2. Book (isbn, title, authorname) 3. Topic (isbn, subject) 4. Branch (libname, city) 5. Instock (isbn, libname, quantity) 1. Give all authors\u2019 names born after 1940. [0.25 Point] [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-90038","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/90038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=90038"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/90038\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=90038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=90038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=90038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}