Design a relational schema and include the following:

Based on the attached business requirements, design an entity relationship diagram for the Canyon Sales Department using a tool of your choice to design the ERD. Make sure to deliver a screenshot that captures the full diagram.

Map the ERD into a relational schema using SQL Server Management Studio $($SSMS$)$ in LopesCloud. Capture the Create statements for the creation of the schema.

Insert the data provided by the instructor. Display the newly created tables. Capture the insert statements, the select statements and a display of each table with the required data inserted.

Submit the following in a single document compatible with the digital classroom $($e$.$g$.,$ Microsoft Word$).$ Include a one$-$line description above each screenshot

Screenshot of the full entity relationship diagram $($ERD$)$

Screenshot$($s$)$ showing the successful table creation statements

Screenshot$($s$)$ showing the insert statements, select statements, and a display of each table with the required data inserted