Appendix
Solution to Activity 1.1
These are the steps to solve Activity 1.1:
- Analyze the given table:
Figure 16.1 – A table of devices on the network
You can see that, currently, there does not appear to be a unique field, so this is something that needs to be added to create a 2NF table. In addition, observe that Hostname, Location, OperatingSystem, and Layerlevel are all text fields, giving you an idea of the proper data type.
- Specify the data types for the data contained in this table:
Figure 16.2 – The data types that are used ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
