Data Analysis and Design Case Study 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.

TASK 2:  

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P2.1, P2.2, and P2.3. The answers need to be reflected to the DATALYTICS on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

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].

P2.2- Build a relational database system i.e. database tables and table relationships based on a prepared design for DATALYTICS database solution [class demonstration and observation]. 

P2.3- Apply a range of database tools and techniques i.e. text box, combo box, list box, buttons, sub forms etc to enhance the user interface [class demonstration and observation].

TASK 3:  

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P3.1, P3.2, and P3.3. The answers need to be reflected to the DATALYTICS on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

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].

P3.3- Critically evaluate how meaningful data has been extracted i.e. present the query data through report through the use of query tools for DATALYTICS relational database system [class demonstration and observation].

TASK 4:  

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P4.1, P4.2, P4.3, P4.4 and P4.5. The answers need to be reflected to the DATALYTICS on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

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.

P4.3- Create user documentation for a developed DATALYTICS relational database system.

P4.4- Explain how verification and validation has been Addressed in DATALYTICS relational database system.

P4.5- Explain how control mechanisms have been used to develop DATALYTICS relational database system

Learn about Data Analysis and Design Assignment

Assignment Guidelines:

 Use a standard report structure, Word-process the report and use Normal script of a proper font size 12.

 Produce an academic report, detailing the above issues with a word limit of 4000 to 4500 words. 

 Complete the title page and sign the statement of authenticity.

 The Assignment sheet should be attached in the front.

 Submit the document in a folder in the form of a file as well as a soft copy on the submission date. 

 It should be uploaded on E-Learning platform before the deadline and submitted to -------- and sign the submission form of the college.

 Assignments submitted after the deadline will not be accepted unless mitigating and may be entitled for a late fee. 

 Collusion and Plagiarism must be avoided.

 Start each answer on a new page and pages should be numbered. Highlight each question clearly.

 Include a Bibliography at the end of the assignment and use the Harvard referencing system.   

 All work should be comprehensively referenced and all sources must be fully acknowledged, such as books and journals, websites (include the date of visit), etc. 

 Try to give the page numbers, publishers' details and the year of publication

 In order to pass you need to address all the LO and Assessment Criterias. 

 In order to get a merit you need to address the characteristics of pass and address M1, M2,M3  

 In order to get a Distinction you need to address the characteristics of pass and merit and Use a common format for the questions, for example:

 Introduction (analyze the question.)

 Underpinning Knowledge (write about the relevant theory/points)

 Applied knowledge(Data Analysis)

 Conclusions and Recommendations (summarizing the whole scenario keeping in view pass, merit, distinction criteria.)