Data Management Applications C170; CORRECTLY ANSWERED

What is a table? correct answers A table is a persistent representation of a logical relation that is a relation whose contents can be saved for permanent use. What are the characteristics of a relational table? correct answers The characteristics of a relational table are that a table is perceived as a two-dimensional structure composed of rows and columns, each row (tuple) represents a single entity occurrence within the set, each column represents an attribute, each column has a distinct name, each intersection of a row and column represents a single data value, all values in a column must be of the same data format, the order of the rows and columns don't matter to the DBMS, and each table must have an attribute (or combination of attributes) that uniquely identifies each row (tuple). What is a tuple? correct answers A tuple is a row that represents a single entity occurrence within a set. What are records? correct answers A record is the same as a tuple (row). What is a field? correct answers A field is a column. What is a key? correct answers A key consists of one or more attributes that determine other attributes. For example, a social security number identifies all of the other attributes related to that person. What is determination? correct answers Determination is the state in which knowing the value of one attribute allows you to determine the value of another attribute. For example, if you know a key, you can find other information. What is functional dependence? correct answers Functional dependence is when knowing the value of one or more attributes lets you know the value of the other attributes. For example, knowing the first name and the social security number would let you find the person's last name. What is full functional dependence? correct answers Full functional dependence is when knowing the value of one or more attributes lets you know the value of other attributes and the value of the known attributes are NEEDED to find the other attributes. For example, a social security number lets you find the first and last name of someone. This is full functional dependence. If it was a social security number and a first name this would just be functional dependence because the first name is not required to look up the last name. All you need is the SSN. What is a determinant? correct answers A determinant is an attribute whose value determines the value of other attributes. For example, a social security number could be the determinant for your last name.