Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
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
Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.