Provide one new example of relations (tables) that could have more than one candidate key. Some examples are: employee data that contain both Social Security number and employee number; and state data that contain both state abbreviation and state name. Include an organization that might use the database making use of the relation in your example.
Description Keys and Relations Overview Relational databases have multiple tables which are connected to each other by one or more attributes. Many of the connected attributes are either primary or foreign keys. Time to discuss relation between keys and attributes further! Instructions This is a two-part discussion. In your initial response, answer both parts and […]