Term
The purpose of a database is to help people keep track of things? (T or F) |
|
Definition
|
|
Term
An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurences of the same data item in other rows will be automatically updated as well. ( T or F) |
|
Definition
|
|
Term
One problem with storing duplicated data is the potential for inconsistent values.( T or F) |
|
Definition
|
|
Term
A relational database stores data in the form of lists. ( T or F) |
|
Definition
|
|
Term
By separating data into tables containg data on only one theme each, making changes to the data is simplified. ( T or F) |
|
Definition
|
|
Term
A relational database can be defined as a self-describing collection of related tables. ( T or F) |
|
Definition
|
|
Term
Refential integrity constraints must be enforced by the application program. ( T or F) |
|
Definition
|
|
Term
| Most commercial databases are base on ______? |
|
Definition
|
|
Term
Relational database stores data in the form of ________? |
|
Definition
|
|
Term
|
Definition
| Structured Query Language. |
|
|
Term
| What are the four baisc components of a database system? |
|
Definition
1) Database, 2) user, 3) DBMS, 4) Database Application |
|
|
Term
| The component of a database that makes it self-describing is the________? |
|
Definition
|
|
Term
| The creation of a database and its tables is a functrion of which component of the database system? |
|
Definition
|
|
Term
| Microsoft Access is an example of a _______? |
|
Definition
| Database Management System |
|
|
Term
| What are the three things that make a relation? |
|
Definition
The order of the columns in a relation must go from largest to smallest. All entries in any column must be of the same kind. A relation may have duplicate column names. |
|
|
Term
|
Definition
|
|
Term
| A key that contains more than one attribute is called a(n)__________? |
|
Definition
|
|
Term
|
Definition
|
|
Term
| When the primary key of one relation is placed into a second relation, it is called a ______. |
|
Definition
|
|
Term
| A rule that requires that the values in a forein key must have a matching value in the primary key to which the foreign key corresponds, is called _____. |
|
Definition
Referential integrity constraint |
|
|
Term
| What are three true things about surrogate keys? |
|
Definition
They are usually hidden on forms and reports. They are unique. They are numeric |
|
|
Term
Which of the following is not a function of the database application in a database system? a) Execute Application Logic b) Control Concurrency c) Create and process reports D) Create and transmit queries E) None of the above |
|
Definition
| B) Control Concurrency. All the other three are functions of a database. |
|
|
Term
| Name something true about a key. |
|
Definition
It may be unique. It may be nonunique. It may identify more than one row. |
|
|
Term
| What is the function of the DBMS in a database system? |
|
Definition
|
|
Term
| What is an example of something thats not metadata and something that is metadata? |
|
Definition
Names of tables in a database is (METADATA) Random numbers.(NOT) Properties of tables in a database(METADAtA) NAmes of columns in a database of which they belong(METADATA) |
|
|
Term
| Name two data types in Microsoft access |
|
Definition
|
|
Term
| Name two other things that have the same meaning as field. |
|
Definition
| column and attribute both mean the same as field. |
|
|
Term
| Name the three types of objects in Microsoft access. |
|
Definition
| forms reports and quieres |
|
|
Term
|
Definition
|
|
Term
| Each relation is a ____ dimensional table. |
|
Definition
|
|
Term
| The attributes of an entity become the ____ in a table. |
|
Definition
|
|
Term
| Rows are also called ________. |
|
Definition
|
|
Term
| The ____ key of a table is the column that uniquely identifies a row in a table. |
|
Definition
|
|
Term
|
Definition
It is a unique. Used to represent rows in relationships Can be candidate key Used to identify unique rows |
|
|
Term
STUDENT(SID, S-Name, Major, AdvisorID) ADVISOR(AdvisorID, A-Name, Office, Phone) What is the foreign key? |
|
Definition
|
|
Term
In Microsoft Access the data type of a surrogate key is called a _______? |
|
Definition
|
|
Term
| The first step of the Normalization process is to _____? |
|
Definition
| Identify all candidate keys of a relation. |
|
|
Term
What is true about null values? |
|
Definition
Null values cannot be avoided Null value can mean that the value is known to be blank a null value can mean that the vaule is unknown value is amibuous. |
|
|
Term
| Name an example of a popular DBMS software |
|
Definition
| SQL, Oracle, Microsoft access, many more. |
|
|
Term
| The relationships between two attributes that denotes that given the value of the first attribute is known,m the value of the second attribute can be determined, is called a(n) ___________? |
|
Definition
|
|
Term
| What does the primary key of the relation determine? |
|
Definition
| It funtionally determines all of the attributes in the relation. |
|
|
