{"id":35852,"date":"2022-02-24T12:43:06","date_gmt":"2022-02-24T12:43:06","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/?p=35852"},"modified":"2022-02-24T12:43:06","modified_gmt":"2022-02-24T12:43:06","slug":"data-analysis-3","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/data-analysis-3\/","title":{"rendered":"Data Analysis"},"content":{"rendered":"<p><strong>A University wants to keep track of its students. Answer the following questions: (25)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Check whether the following is data or metadata:<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student\u2019s Name.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student\u2019s Contact information.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student\u2019s Birth Date.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Contact Information is a long integer.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student name is a string of not more than 50 characters.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>2)\u00a0\u00a0 The following are some data checks whether the data is structured or unstructured<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Image of Student\u2019s ID.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student Name, contact information, and age.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Students score information.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Messages using their chatbot service.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Fees Invoice Information<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3)\u00a0\u00a0\u00a0\u00a0 Identify the following Attribute Data Type or Instance.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Students ID is integer.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student name is Robert.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Birthdate should be Date type.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>The student gender is Male.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"4\">\n<li>Student\u2019s overall GPA is 4.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0 4)\u00a0\u00a0\u00a0 Identify the data type of the following and give examples of one instance each:<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student Name<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student admit number<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student Birthdate<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student Email Address<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Student Red ID<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0 5)\u00a0 Complete the following table: <\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table width=\"593\">\n<tbody>\n<tr>\n<td width=\"125\"><strong>Attribute<\/strong><\/td>\n<td width=\"125\"><strong>Required or Optional<\/strong><\/td>\n<td width=\"125\"><strong>Simple or Composite<\/strong><\/td>\n<td width=\"125\"><strong>Single-Valued or <\/strong><\/p>\n<p><strong>Multi-Valued<\/strong><\/td>\n<td width=\"93\"><strong>Stored or Derived<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student ID<\/strong><\/td>\n<td width=\"125\">Required<\/td>\n<td width=\"125\">Simple<\/td>\n<td width=\"125\">Single Valued<\/td>\n<td width=\"93\">Stored<\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student Name<\/strong><\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"93\">&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student Address<\/strong><\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"93\">&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student Contact<\/strong><\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"93\">&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student Birthdate<\/strong><\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"93\">&nbsp;<\/td>\n<\/tr>\n<tr>\n<td width=\"125\"><strong>Student age<\/strong><\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"125\">&nbsp;<\/td>\n<td width=\"93\">&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2)\u00a0 Draw an ER diagram for the following problem. You can use any software or online tools or draw it by hand. (15)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><em>Wikipedia is interested in creating a database to manage its website. Wikipedia works in several different languages, each of which has a language code and common name. Wikipedia has many pages, each of which have a name, text, and date created. Each page can exist in several languages. Wikipedia has users that edit each page, each of whom have a legal name, username, email address, and one primary language. \u00a0Each user can edit multiple pages, and a page can be edited by multiple users.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>3) Regarding the entity-relation diagram below answer the questions. (10)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>An airport can have many Airlines?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Can SSN be a Multivalued Attribute? Why or why not?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>How many flights can be assigned to a Pilot?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Can there be zero airlines at the airport?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Identify strong entities and weak entities for all the entities.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Can an Airline be assigned to multiple Airports (give an answer according to the ER diagram)?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Add an entity passenger and give its attributes.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Which of the attributes in Pilots can be considered as a multivalued attribute?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>How many flights can be assigned by the airlines?<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Write all the relationships in the ER diagram.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>4) Give difference between the following in your own words:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 (5)<\/strong><\/p>\n<ol>\n<li>Data and information.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Data and Metadata.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Structured data and Unstructured data.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Data Dependence and Data Independence.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Strong Entities and Weak Entities.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>5) Define Data Warehousing.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (5)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>6) Explain File Processing systems and the Database Approach. What are the advantages of Database Approach over the File Processing Systems? Give examples for the same.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (5)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>7) Explain System Development Life Cycle.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (5) <\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>8) Explain different types of relationships.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(5)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A University wants to keep track of its students. Answer the following questions: (25) &nbsp; Check whether the following is data or metadata: &nbsp; Student\u2019s Name. &nbsp; Student\u2019s Contact information. &nbsp; Student\u2019s Birth Date. &nbsp; Contact Information is a long integer. &nbsp; Student name is a string of not more than 50 characters. &nbsp; 2)\u00a0\u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-35852","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/35852","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=35852"}],"version-history":[{"count":2,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/35852\/revisions"}],"predecessor-version":[{"id":35855,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/35852\/revisions\/35855"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=35852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=35852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=35852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}