Relational Databases
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| What are the three models of database system that have dominated over the history of database management systems? | a. hierarchical Model b.relational model c.network models
🗑
|
||||
| What is the relational term for a row of related data values? | tuple
🗑
|
||||
| How are the table name and the column names used in database study? | row attribute
🗑
|
||||
| What is the relational term for a column in a row of records? | attribute
🗑
|
||||
| What is the relational term for a collection of records about some object? | relation name
🗑
|
||||
| How is the primary key denoted in a relation diagram? | underlined
🗑
|
||||
| What is the term for a set of values each of the same data type in which each value is indivisible? | domain
🗑
|
||||
| What term is used to refer to a value that is indivisible? | atomic
🗑
|
||||
| What is the term that refers to the structure of a value? | data type
🗑
|
||||
| What is the term for the description of a relation? | schema
🗑
|
||||
| What is the relational term for a role or characteristic of a data element in a tuple of a relation? |
🗑
|
||||
| Using common database notation, denote a relation, Part, that has attributes partno, name, cost and qoh. | Part(part no,name,cost,qoh)
🗑
|
||||
| What is the term that refers to the number of attributes in a relation schema? | degree
🗑
|
||||
| What is the term that refers to a relation and all of its tuples at an instant in time? | Relation State
🗑
|
||||
| Does a relation in relational database theory have an order? | False
🗑
|
||||
| A domain, months, has a possible range of 12 values, January, February, March, etc. What is the term for the number of values in a domain? | cardinality
🗑
|
||||
| What is the term for the state of a relation that meets all constraints as defined in the relation schema? | Valid State
🗑
|
||||
| In a database attribute, a value that is unknown, exists but is not available, or is a value that is undefined is said to be __________. | null
🗑
|
||||
| If a relation, CUSTOMER, and a relation, VENDOR, both have a primary key, id, how would a user reference the two with dot notation in a query that uses both? | customer.id
vendor.id
🗑
|
||||
| What is the term that refers to restrictions on the actual values in a database state? | Constraints
🗑
|
||||
| What kind of constraint can be expressed in a schema of a data model? | explicit
🗑
|
||||
| What kind of constraint is just part of the relational data model? | implicit
🗑
|
||||
| What is the term for constraints that cannot be directly expressed in schemas and must be expressed and enforced by an application program? | Business Rules
🗑
|
||||
| List five of the domain constraints that we studied | a.
Booleans
b.
Characters
c.
time
d.
money
e.
fixed length strings
🗑
|
||||
| What is the term for any combination of attributes that can be uniquely used to identify a database record? | Superkey
🗑
|
||||
| What is the term for a superkey from which one cannot remove any attributes and still have the uniqueness constraint? | Key
🗑
|
||||
| A relation can have more than one key, so what is the term for another one of those keys? | Candidate Key
🗑
|
||||
| What is the term for a candidate key that is used to identify a relation? | primary key
🗑
|
||||
| What is the term for a candidate key that is NOT used to identify a relation? | foreign key
🗑
|
||||
| What displaying the structure of a relation, how is the primary key identified? | Underlined
🗑
|
||||
| What does the entity integrity constraint specify? | No primary key can be null
🗑
|
||||
| What is the key constraint? | Uniqueness
🗑
|
||||
| What is the term for a constraint that is specified between two relations in order to maintain consistency between the two relations? | referential integrity constraint
🗑
|
||||
| What are the two requirement specified for a foreign key? | a.Attributes in foreign key have same domain as primary key attributes
Not yet graded
b.
Value of foreign key in a tuple of the current state either occur as a value of primary key or be null
🗑
|
||||
| What do you call constraints that may be specified by application programs or some general purpose constraint definition language rather than the data definition language? | semantic integrity constraints
🗑
|
||||
| What constraint states that the value of one attribute determines the value of a different attribute? | functional dependency constraint
🗑
|
||||
| What are the three operations that change the state of a relation? | a.
insert
b.
delete
c.
update
🗑
|
||||
| How could an INSERT operation on a relation cause a violation of the key constraint? | if a key value in the new tuple already exists in another tuple relation.
🗑
|
||||
| How could an INSERT operation on a relation cause a violation of the entity integrity constraint? | if any part of the primary key of a new tuple is null
🗑
|
||||
| How could an INSERT operation on a relation cause a violation of the referential integrity constraint? | if value of foreign key in the new tuple refers to a tuple that doe not exist in the referenced relation.
🗑
|
||||
| What is the default action caused by a violation of any constraint of the relational database? | reject
🗑
|
||||
| How could a DELETE operation on a relation cause a violation of the key constraint? | does not violate key constraint
🗑
|
||||
| How could a DELETE operation on a relation cause a violation of the entity integrity constraint? | does not violate entity integrity
🗑
|
||||
| An alternative to rejecting a DELETE operation that removes a tuple with a primary key that is being referenced by another tuple’s foreign key is to CASCADE. What occurs with a CASCADE action? | delete all referring tuples
🗑
|
||||
| What is another alternative to REJECT and CASCADE, when a DELETE operation removes a tuple with a primary key that is being referenced by another tuple’s foreign key? | set to null
🗑
|
||||
| What is the term for an executing program that includes one or more database operations? | transaction
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
10154542572488346
Popular Computers sets