- Under what conditions will a determinant be unique in a relation?
In a table or a relation, for a determinant to be unique, it must determine all other columns in that specific table or relation. As we know that two rows in a table cannot hold the same data, therefore there must be a column that have unique data in it e.g. ID column in most of relations. The ID column therefore acts as a unique identifier.
- When you receive a set of tables, what steps should you take to assess their structure and content?
When a database developer receives a set of data tables, he/she should follow the following steps to assess the structure and content of the data tables:
First is to count the rows and understand the attributes or columns. Then ask the data users about the data values and their nature that will help determine Multivalued and functional dependencies and candidate, primary and foreign keys.