This assignment uses a GCU-provided virtual machine.
The purpose of this assignm
This assignment uses a GCU-provided virtual machine.
The purpose of this assignment is to create a relational schema using an entity relationship diagram (ERD) and then map the relational schema into a dimensional star schema. The design will be created using industry standards and practices.
View the ″Data Warehouse″ video within the ″Video Playlist: Relational Databases for Business Applications,″ located in the topic Resources.
For this assignment, refer to the ″SYM-408 Design a Relational Schema″ document to complete the assignment.
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 desсrіption 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
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
This is the file you need for it:
https://halo.gcu.edu/resource/ffb6d638-5972-4884-a3e1-695d5db9cf4d