· 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