Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

Task Overview

Write a 3000-word report on database design and its implementation based on the scenario below

Rice and Wheat are two principal crops fulfilling a major portion of food needs i.e., around 90% of the world food requirements. You have been provided a dataset (RiceAndWheat.xlsx file) related to the top producers of Rice and Wheat crops worldwide. The dataset contains several related aspects for the production and the concerned environment observed by these crop producers along with the production quantity related aspects.

Considering the given dataset, you are required to design a relational database for tracking the production of rice and wheat. Based on the dataset provided, the design should encompass the schema to include information about both crops and all the other important related aspects provided in the given dataset. Look for the opportunity for the derived data too. For, example as we can derive age from Date-of-Birth, so you may investigate what other data can be derived from this dataset. The dataset contains some of the example values related to countries, crops, production statistics, and related agricultural data, etc. could be utilized to model the schema design.

Following are the specific tasks for this course work:

TASK-A: (With specific reference to the dataset, explain why it should be converted into a relational database and what are the advantages of doing so. Consider and compare the potential advantages which could be attained if we convert it to relational database in contrast to keeping it in excel sheets or Comma-Separated Values (CSV) text files. You need to give specific examples based on the attached dataset and the discussion should not be generic. The concrete examples should show the key dis-advantages if we store this using file-based system as compared to the Relational Database.

Note: Discussions and answers should not be generic. You need to provide dataset related specific examples and scenarios.

TASK-B: Demonstrate the detailed process of implementing the relational database:

i. Produce “ERD” for a) Conceptual level, b) Logical level, and c) Physical levels. For all these tree ERDs discusses along justification/explanation why the concerned attribute, relationship, or cardinality has been chosen.

For the Logical level ERD, you should also define the domain for different attributes. For the Physical level ERD, you should properly represent all the Keys, including PK and PF, etc. For ERDs, you should use the Crow’s foot notation.

iii. Write SQL commands to create the tables (include the code-snippets in the report). Populate the tables with sample data either using SQL code or using an import function. Include proof of successful creation of the database (tables created and populated with appropriate data usable for other project tasks).

TASK-D: Write SQL code (queries or commands) to demonstrate the use of SQL joins. For each type of SQL join, you need to write one meaningful query (considering the dataset), brief explanation of key elements of the SQL code, screenshot of the results, and use case description considering the database design.

TASK-E: You need to create 4 graphs; each should be of a different type. Each graph should illustrate appropriate information from the data, and you should justify your choices. You must demonstrate their implementation in Python. Both the code (in-text) and the output graph (screenshot) itself should be included in the report. For each of the graphs, you must include an explanation of any conclusions demonstrated.

Marking Scheme

The project contributes 100% towards module assessment. This is an individual project and should be submitted withing the announced deadline. The following table shows the detailed composition of the marking scheme.