Data Management Applications C170 with complete solution

Document Content and Description Below

What is a table? Answer- 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 t... able? Answer- 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? Answer- A tuple is a row that represents a single entity occurrence within a set. What are records? Answer- A record is the same as a tuple (row). What is a field? Answer- A field is a column. What is a key? Answer- 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? Answer- 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 [Show More]

Last updated: 1 year ago

Preview 1 out of 30 pages