Using MS Access, create a database for keeping track of the network switches and ports on a companys network. Every network switch has either 12 or 24 ports (numbered 1-24). The ports then connect to a jack that provides network connectivity to a user in their office/cubicle. Every jack in the organization has a unique number to identify it and we have a record of its location (building and room number) Here is the information you need to keep track of for each switch: Location (building and room number) - Switch model - Number of ports -Speed of each port (10, 100, 1000 Mbps) Duplex setting on each port (auto, full, half) - Where each connected port to (i.e. which jack is connected) Name, department, and phone number of the user that each connected port serves. Date the port was connected (or last changed) - Requirements Create the necessary tables and fields to support this. You must determine how many tables to create in order to come up with the best design for this application. 1. 2. Define the table relationships, creating primary and foreign keys as required 3. Add some data to each table-I leave it to you to decide how much you need, but add enough to satisfy yourself that everything in the assignment works as expected. I suggest a minimum of 5 switches. Using MS Access, create a database for keeping track of the network switches and ports on a companys network. Every network switch has either 12 or 24 ports (numbered 1-24). The ports then connect to a jack that provides network connectivity to a user in their office/cubicle. Every jack in the organization has a unique number to identify it and we have a record of its location (building and room number) Here is the information you need to keep track of for each switch: Location (building and room number) - Switch model - Number of ports -Speed of each port (10, 100, 1000 Mbps) Duplex setting on each port (auto, full, half) - Where each connected port to (i.e. which jack is connected) Name, department, and phone number of the user that each connected port serves. Date the port was connected (or last changed) - Requirements Create the necessary tables and fields to support this. You must determine how many tables to create in order to come up with the best design for this application. 1. 2. Define the table relationships, creating primary and foreign keys as required 3. Add some data to each table-I leave it to you to decide how much you need, but add enough to satisfy yourself that everything in the assignment works as expected. I suggest a minimum of 5 switches