ch5 Flashcards Preview

ebus > ch5 > Flashcards

Flashcards in ch5 Deck (21):
1

Users have critical roles in database application development.

T

2

Another name for a column is a record.

F

3

Relational databases represent relationships through the use of formal keys.

F

4

The name of the field and the data type and width are an example of metadata

T

5

A database application consists of forms, reports, and database programs.

T

6

A DBMS is software that helps manage the operating system.

F

7

A DBMS is a collection of tables, relationships and metadata.

F

8

A DBMS can be used to add a new column to a table.

T

9

A database form translates the inputted change into a SQL query in order for the database to process it.

T

10

A physical representation of a database is called a data model.

F

11

A data model describes the data and relationships that will be stored in the database.

T

12

“PartNumber” would be a good identifier for a part entity in a database application

T

13

Each entity should have one unique identifier

T

14

In a 1:M type of relationship, the foreign key is stored on the “1” side.

F

15

Normalization is a process that helps ensure that the tables from the database design process are well structured.

T

16

Database integrity problems produce inconsistent answers, but this is easily corrected.

F

17

Normal forms have duplicated data removed.

T

18

In order to transform a data model into a database design, one must first represent each entity with a table.

T

19

DBMS is just a model of how users view the business world.

F

20

Oracle and DB2 are examples of multi-featured personal DBMS.

F

21

The DBA, as opposed to the user, is responsible for authorizing changes to the database.

T