Please answer these step by step

Global Waste Management is committed to offering Skip Bin products, rubbish removal as well as Recycling Centres in the most efficient, economically effective and environmentally conscious waste management solutions. For years, Global Waste Management have operated in the NSW $($without any computer system $($Paper Based$)),$ currently expanding their operation across Australia, they are planning to automate their entire operation.$$ Their main categories are:

Mixed rubbish $($Light$)-$ gardening materials, household items,..

Buidling materials $($Heavy$)-$ soil, bricks,...

Concrete $($Concrete$)-$ Only concrete removal

Dirt $($Dirt$)-$ Only soil

The smart waste management systems include:

Financial Management

Ordering Systems $($customer$,$ address, tin size, assign vehicle, assign personnel,...$)$

Customer Management

Personnel Management $($HR$)$

Rostering Management

Company Vehicle Management

Smart Tins

Outsource Management $($Vehicles & Staff$)$

Council Administration $($Based on locality$)$

Council Dump Management $($Based on locality$)$

Council Recycling Facilities $($Based on locality$)$

Performance in Cloud $($If Necessary$)$

Business Intelligence

$$

The requirements are as followings:

$1.$ write the SQL code to create database, tables, attributes and show the relationship in the SQL Code.

$2.$ write the SQL Query code and demonstrate the outcome $($View$)$ for some complex dashboard for Data Analysis.

$3.$ Create security and privacy policies for Global Waste Management.

$4.$ Develop $1$ A$3$ size poster defining the entire completed work for a wider audience. This page $$ should include:$$

Problem: Detailed explanation of a problem $($the reason for Project$)$

Best Solution: The best solution that could be provided $($Ultimate solution in Perfect Word

which is the best$-$case scenario but unachievable at this phase of the project.

Desired Solution: The solution that can be achieved at this phase of the project.

Challenges and Assumptions: The key design decisions, challenges and assumptions made for $$ completing the desired solution.

Completed ERD: Provide completed BRD after fully revisited after completion Assignment $2.($Your ERD will be mainly modified at this stage of the project$).$

Team Name:$$ Create a table with $2$ rows. Include the team member name in the first row and their signature in the bottom row.