You have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. In this Assignment, you will continue to use the data in the Sales Data document from previous weeks to create a database.
To complete this assignment:
1. Read Chapter 8 of the eBook (I’ve uploaded all necessary materials)
2. Install your choice of software for creating a database:
A. Option 1: MySQL open-source software and supporting documentation.
I. Oracle. (n.d.). MySQL Workbench community downloadsLinks to an external site. [Software]. https://dev.mysql.com/downloads/workbench/
Note: Select your operating system (Microsoft Windows or II. MacOS) from the drop-down menu.
III. MySQL. (n.d.). MySQL documentationLinks to an external site.. https://dev.mysql.com/doc/
IV. MySQL. (n.d.). Chapter 11: Data typesLinks to an external site.. https://dev.mysql.com/doc/refman/8.0/en/data-types.html
V. MySQL. (n.d.). Chapter 13: SQL statementsLinks to an external site.. https://dev.mysql.com/doc/refman/8.0/en/sql-statements.html
B. Option 2: MS SQL Express software and supporting documentation.
I. 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: Scroll for the free MS SQL Express download.
II. Microsoft Learn. (2022, November 18). Data typesLinks to an external site. (Transact-SQL). https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16
III. Microsoft Learn. (2022, November 18). Transact-SQL statementsLinks to an external site.. https://learn.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-ver16
IV. Microsoft Learn. (2023, March 3). CREATE TABLELinks to an external site. (Transact-SQL). https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver16
3. Review the “DDL and DML Commands” PDF document in the Week 4 Learning Resources. This resource shows the Data Definition Language (DDL) commands used by MS SQL and MySQL to create databases and tables and the Data Manipulation Language (DML) commands to insert data into tables that you create. Once you install the database management system that you select, copy these commands into Microsoft SQL Studio Manager for MS SQL and WorkBench for MySQL.
4. To help you can also search for tutorial videos to review the creation of the databases, tables, and insert data into the tables.
5. Create the tables for the data provided in the Sales Data document, located in the Learning Resources. The tables should include the primary and foreign keys. Provide the SQL statements.
6. Insert the data into the tables. Provide the SQL statements.
7. Show the contents of each table. Provide the SQL statements.
8. Submit a document of 2–4 pages in Microsoft Word and APA format in which you do the following:
9. Complete each task in Steps 1–3 and provide the required statements and documentation (e.g., screenshots).
Can you make it 2.5 pages instead, out of courtesy for the long-standing relationship? Minimum of 5 resources in APA format.
