· 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
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.