Solution to Activity 1.1

These are the steps to solve Activity 1.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.

2. Specify the data types for the data contained in this table:

Figure 16.2 – The data types that are used for the table fields

Starting off, each column can be represented as varchar, since they are all text fields. Also, observe that the preceding table is in 1NF because every column contains a single value.

3. Create a key that uniquely identifies the table. You will have to create a composite key of Hostname and Location, since the table has common hostnames.
4. Once the...