Annotate the “OSI Model Diagram” spreadsheet according to the following instructions:
In the center of the diagram (Column B), beneath each label place a one- or two-word descriptor for that layer.
Create a list of at least 10 networking devices. Add those devices to their proper layer on the left side (Column A) of the diagram.
Create a list of at least 40 protocols. For each protocol, determine its port number. Add each protocol to the appropriate layer on the right side (Column C) of the diagram. Note: Some protocols span multiple layers; indicate these protocols by adding a ‘+’ symbol to the annotation.
Save the spreadsheet as follows:
OSIModelDiagram–.xlsx
i.e.) OSIModelDiagram–Fred Flintstone–ITT-116-MWF123A.xlsx
Submit your completed spreadsheet to the assignment.
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.
You are not required to submit this assignment to LopesWrite.
Category: IT
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.