Data Analysis and Design

Individual report approx 4500 words 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 (..........) TASK 2: P2. Be able to design and implement relational database systems. P2.1- Using DFD, ELH, ER etc to design a relational database system to meet a given requirement of DATALYTICS database solution [class demonstration and observation]. TASK 3: P3. Be able to use manipulation and querying tools P 3.1 – Explain the benefits of using manipulation and query tools in a relational database system P3.2 – Implement a query language using SQL into the DATALYTICS relational database system [class demonstration and observation]. TASK 4: P4 Be able to test and document relational database systems P4.1- Critically review and test the DATALYTICS relational database system. P4.2- Create documentation to support the implementation and testing of the DATALYTICS relational database system.