Academic Writing " Data Analysis and Design "

ASSIGNMENT TASK 1: You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P1.1, P1.2, and P1.3. The answers need to be reflected to the general Data Analysis and Design Concepts. Answers without application to an organization or without examples will be marked as Resubmission. P1. Understand data models and database technologies P1.1- critically compare different data models such as network, hierarchy, RDBMS etc and schemas such as external, conceptual etc. P1.2- critically discuss the benefits and limitations of different database technologies such ms access, sql server, oracle etc. P1.3- analyse different approaches such as DFD, Use case, ELH, ER etc to database design Case Study: DATALYTICS is a leading data analytic and consulting firm. The company supports their clients across the globe to design and analyse big data to guide strategic decision markers. Due to the rapid expansion of their businesses, the company will be dealing with massive and disjointed data to enable them survive in the global market. Since information is keen to business growth and continuity, the company foresees that they are likely to be unable to systematically apply relevant statistical and logical procedures to describe, illustrate, correlate, evaluate and discover useful information from their massive data. As a result, the company has hired you as their main data analyst and unfortunately, your main responsibilities were not properly clarified. Nevertheless, you were fortunate to meet with the Director of Human Resources (DHR) of the company during your induction training. Accordingly, the DHR gave an overview of your duties to subsume the design, documentation, querying and implementation of a relational database system for the company within the available resources. You will also work with GIS Specialists and Software Engineers to provide support to the healthcare service providers and some other notable clients across Asia, Africa, USA, Australia and UK. The database should contain at least ten related tables. In addition, when you create the database, you should be able to store different categories of data type such as varchar, float, text, integer and transaction’s date in its tables. For instance, you can create an Address table, Products table, county code’s table, Post code’s table, list of organizations, hospitals and list of therapies. The Address table for instance should be able to store several names, house numbers, street names, post codes, emails, and telephone numbers while the Products table should be able to store information such as different categories of products, unit price and location of each product. An information pack given to you shows that for your appointment to be confirmed by the company, you should be able to complete the following business functions within the agreed time: a) Design and develop information for strategic planning, operational and analytical purposes. b) You will be required to examine, clean, transform and model data that facilitate the discovery of useful information and suggestions that will meet the requirements of strategic decision makers and regulatory bodies. c) Use suitable platform to manipulate data, querying scripting and reporting standard to complement decision making process at the strategic level of the company. The document further states that you will need to constantly report to the management about the whole processes for you to secure the approval of the Chief Executive Officer (CEO) of the company.