This assignment demonstrates knowledge of relationships within data focusing mainly on the terms functional dependency and determinants. This knowledge is then used to determine whether or not a given expression is true.
Assignment Response(s)
Question 01: A foreign key is an attribute that is a key of one or more relations other than the one in which it appears. A foreign key serves an important role in relational database tables by associating attributes together when necessary. One example of this would be if there were two separate tables, one having the theme “Patient” and the other having the theme “Room.” The Patient table would have all of the patient’s information as attributes,. This would include the patient ID number. The Room table would have the room information as attributes. Since it would be important to know who is staying in which room, we could add the patient’s ID number as a new column in the Room table when they are assigned a room. In this case the patient ID number would be a foreign key in the Room table.…show more content… While a determinant is one or more attributes that functionally determine another attribute. Sense these two terms have similar definitions, the difference can be explained by giving an example. As an example, we have the formula PopcornCost=NumberOfBags X $2. So, PopcornCost is functionally dependent on NumberOfBags. This statement is a functional dependency because it shows the relationship between the two attributes. The determinant in this example would be NumberOfBags because it is the attribute that determines another
