LD7084 - Database and Analytics Principles - Data Analytics Assignment Help

Assignment Task

Assessment Brief
Learning Outcomes Assessed in this assessment
This assignment will assess the following learning outcomes:
1. A critical knowledge and understanding of data and data analytics theories and methodologies
2. Ability to apply data analytics skills and knowledge to a complex business challenge or project
3. Ability to evaluate your data analytics skills.
4. Critical reflection of your implementation, recommendations for improvement and the subsequent implications for your learning development in data and data analytics domain.

Scenario
WeDeliver is an online delivery company, which is looking to develop an effective Relational Database Management System (RDBMS) and data warehouse to cater the
needs of their growing business. As a data analyst, you have been asked to develop a required system for WeDeliver. Which should satisfy the following information
requirements:

• The database should contain information about Customers, Items, Restaurants, Orders, Drivers and their Vehicle. For payroll, the NI number of the drivers is recorded.

Assessment Brief
• For each customer, the database should store the CustomerID, Last Name, First Name, Email, and the Phone Number.

• For each driver, their name, salary, email address and their manager are recorded as well details of their Driving License such as Driving License Number, Issue Date,
country of issue and Expiry Date.

• Each driver is assigned a motorbike when they start with the company and they normally keep it during the duration of their contract. Details of the motorbike are registered such as RegistrationNo, Colour, date of purchase, engine size etc.

• Each Manager manages at least one driver and each driver is associated with one restaurant only but one restaurant employs many drivers.

Questions -

1. Using Crow’s foot notation, design a logical data model (ERD) for WeDeliver database in a modelling tool of your choice. All entity types, attributes and the relationships between them must be labelled clearly. Your design should show all cardinality and participation constraints accurately. Discuss and justify your design choices in detail. 

2. (a) Produce a script using appropriate SQL commands (DDL) to create a set of database tables using MySQL relational database. Your tables should also show all
constraints applied at either the column or the table level. You are expected to implement the database so that it must meets the requirements described in the scenario.

(b) By using appropriate SQL statements (DML), populate all the tables in the database you created with some data (At least 10 records in each table). The data should be meaningful but does not need to be extensive.

3. As a Data Analyst, produce 5 DML statements that will provide valuable insights for WeDeliver. Your DML statements should contain at least one of the following:
a. A statement involving a self-join.
b. A statement involving an equi-join.
c. A statement involving at least one group function
d. A statement involving at least one subquery.
e. A statement involving null values.

This LD7084 - Data Analytics Assignment has been solved by our Data Analytics experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.