Activity 1.01: Creating an optimized table for an employee project
Your manager asked you to create a database that holds information about network devices in your corporate network site. You may have multiple devices with the same name in the same location. You are required to make the tables conform to the 3NF to make them as efficient as possible. In addition to this, you need to determine the proper data types for each column in the table. Finally, you are required to determine which columns should be primary keys, such that 3NF is satisfied. You have decided to perform the following steps.
- Analyze the following table:
Figure 1.12 – A table of devices on the network
- Identify patterns to determine the data types and possible primary keys. You may need to add a column to the table if an appropriate primary key does not already exist. Next, bring the table to 1NF
- Bring it to 2NF, break down the table, and try to bring it to the 2NF form according to the rule.
- Bring it to 3NF, break it down even further, and bring it to 3NF so the table is in 2NF with the appropriate constraints.
Note
The solution to this activity can be found in the Appendix.
Now you have an optimized table set up, you will be able to use this technique to efficiently optimize your database before you start filling it up with data and deploying it in production.