Get fast, custom help from our academic experts, any time of day.

Place your order now for a similar assignment and have exceptional work written by our team of experts.

✔Secure ✔ Original ✔ On Schedule

·         Coronel, C., & Morris, S. (2018). Database systems: Design, implementation, & management (13th ed.). Cengage Learning.
o    Chapter 4, “Entity Relationship (ER) Modeling” (pp. 113–167)
o    Chapter 8, “Advanced SQL”
§  Section 8-1, “Data Definition Commands” (pp. 360–366)
§  Section 8-2, “Creating Table Structures” (pp. 366–375)
§  Section 8-3, “Altering Table Structures” (pp. 375–378)
·         Oracle. (n.d.). MySQL Workbench community downloadsLinks to an external site. [Software]. https://dev.mysql.com/downloads/workbench/
Note: This software is one option you may choose for creating a database in the Week 4 Assignment. 
·         Microsoft. (n.d.). Try SQL Server on-premises or in the cloudLinks to an external site.. https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Note: This site provides another option, MS SQL Express, you may choose for creating a database in the Week 4 Assignment. 
·         Document: Key Terms  Download Key Terms(PDF)
Note: Focus on Week 4 key terms.
·         Document: Sales Data Download Sales Data(PDF)
Note: You will continue to use the data for the Week 4 Assignment.
·         Document: DDL and DML Commands  Download DDL and DML Commands(PDF)
Note: You will use this document for the Week 4 Assignment.
Optional Resources
·         w3schools.com. (n.d.). SQL tutorial.Links to an external site.https://www.w3schools.com/sql/default.asp 
·         w3schools.com. (n.d.). SQL data types for MySQL, SQL Server, and MS Access.Links to an external site. https://www.w3schools.com/sql/sql_datatypes.asp 
·         w3schools.com. (n.d.). SQL CREATE TABLE statement.Links to an external site. https://www.w3schools.com/sql/sql_create_table.asp 
·         w3schools.com. (n.d.). SQL ALTER TABLE statementLinks to an external site.. https://www.w3schools.com/sql/sql_alter.asp 
·         w3schools.com. (n.d.). SQL PRIMARY KEY constraint.Links to an external site. https://www.w3schools.com/sql/sql_primarykey.asp 
·         w3schools.com. (n.d.). SQL FOREIGN KEY constraint.Links to an external site. https://www.w3schools.com/sql/sql_foreignkey.asp 

Get fast, custom help from our academic experts, any time of day.

✔Secure ✔ Original ✔ On Schedule