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 Studi
o (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:
londonessays.com
Share this:
FacebookX