Test 1 Part 2 Database

Below is a list of problems that may occur in a list. Indicate which problems can be avoided/fixed by storing data in a relational database instead of in a list. Check all that apply.

*** ALL OF THE ABOVE***

According to your textbook, a relational database management systems need to do which of the following? Check all that apply.

***NOT Allow users to create and process forms and reports*** ***NOT Allow users to create databases and tables***

Which of the following possible problems may occur when a list is used? Check all that apply.

***NOT Lists do not generally have problems***

Which of the following is an example of an aggregate function?

***NOT Max***

A document that contains the objectives and timelines in a database project is known as a __________.

***NOT Statement of Scope***

A short statement outlining what the database will do is called the _______.

***NOT Statement of Work***

Something that the database is concerned with, about which data can be stored and which can have relationships with other like objects in the database is called a(n) ____________.

***NOT attribute***

The process of organizing data into tables or entities and then determining relations among them is known as:

***NOT data integrity***

_________ define or describe an entity.

Attributes

Which of the following is a benefit of establishing relationships between tables?

Data extraction and data integrity are benefits of establishing a relationship between tables.

In defining a one-to-many relationship between two tables, what is the next step after having placed the two tables in the Relationships window?

Drag the common field from the primary table to the related table.

A group of rows in a table is called a field.

False

A relational database, like Oracle, is designed to store data in lists.

False

Data is never duplicated in a relational database.

False

Field names can contain both upper and lower case letters of the alphabet, but cannot contain numbers or the underscore character.

False

It is best practice to use spaces when naming objects. For example, Last Name instead of Last_Names

False

______________ refer(s) to the accuracy and the correctness of the data stored in a database.

Integrity

A type of database that uses relations to store and relate tables is called a

Relational Database management System (RDBMS)

A database management system (DBMS), like Access, stores data in tables.

True

A piece of information about a person, place or item is called a field.

True

A problem with keeping data in lists is that if you delete a row of data from a list you may also delete some data items you wanted to keep.

True

A relational database may contain several themes, but should relate to a single overarching topic.

True

One problem with storing duplicated data is the potential for inconsistent values.

True

A(n) _________ limits what the database will do.

constraint

A key from Table A that is repeated in Table B to create a relationship is called a ______ key in Table B.

foreign

What type of relationship is illustrated in this picture?

one-to-many

A constraint that uniquely identifies each row in a table is called a _________ key.

primary