Deck 5: Extensions A: Introduction to Microsoft Excel

Question 1

__________ is the last step in developing a database application.

A)Creating a data model
B)Reviewing the data model with users
C)Getting the information requirements
D)Creating the database tables in the DBMS
E)Designing the tables with the keys

Answer 1

Creating the database tables in the DBMS

Question 2

The user's review of the data model is

A)crucial.
B)not usually done.
C)treated as a casual process.
D)not necessary.
E)done after the database is programmed.

Answer 2

A

Question 3

__________is (are)the most popular diagramming tool(s)for database applications.

A)O -O
B)Flowcharts
C)UML
D)E -R
E)Workflows

Answer 3

E -R

Question 4

"One department can have many advisers" is an example of

A)a one -to -many relationship.
B)maximum cardinality relationship.
C)a many -to -many relationship.
D)a minimum cardinality relationship.
E)a one -to -one relationship.

Question 5

Understanding how to interpret E -R diagrams will help you interpret__________ with a bit of study.

A)UML models
B)workflow models
C)relational models
D)flow diagrams
E)O -O models

Question 6

A(n) __________data model captures the entities and their relationships in a database application.

A)O -O
B)workflow
C)E -R
D)flowchart
E)Semantic Object

Question 7

Tables are transformed into__________ to remove duplicate data and other problems.

A)normalized design
B)relational form
C)normal form
D)regular design
E)regular form

Question 8

__________ Is the process of converting poorly structured tables into two or more well -structured tables.

A)Normalization
B)Reengineering
C)Sharing
D)Redesigning
E)Decentralization

Question 9

In a relational database,each entity is described by

A)attributes.
B)characters.
C)records.
D)bytes.
E)data.

Question 10

On the many side of a relationship you place the___________of the ___________relationship to represent the relationships in the database.

A)foreign key,many side
B)primary key,one side
C)index key,one side
D)foreign key,one side
E)primary key,many side

Question 11

In a one -to -many relationship,the foreign key is stored in the table that is on the__________side of the relationship.

A)weak
B)one
C)many -to many
D)cardinal
E)many

Question 12

A person,place or object would be represented in a database application as a(n)

A)class.
B)record.
C)table.
D)object.
E)entity.

Question 13

A N:M relationship is represented with a(n)

A)composite table.
B)linking field.
C)intersection table.
D)entity.
E)index field.

Question 14

An example of a one -to -many type of relationship might be

A)an employee can be assigned more than one computer.
B)an employee is assigned a company car.
C)an employee cannot be assigned a computer.
D)an employee can be assigned one and only one computer.
E)an employee can be assigned an office.

Question 15

A crow's foot diagram is a type of

A)E -R diagram.
B)normalization model.
C)data model.
D)UML model.
E)relationship map.

Question 16

A 1:N relationship relates___________ record(s) to __________ record(s )in a database.

A)many,one
B)one,one
C)many,many
D)one,many
E)one,three

Question 17

In an automobile table the__________ would make the best primary key

A)licence plate number
B)a combination of make and model
C)model
D)make
E)VIN

Question 18

A(n)__________ diagram is like a blueprint of a database application.

A)O -R
B)O -O
C)workflow
D)Entity -Relationship (E -R)
E)flowchart

Question 19

__________ is used to indicate a many -to -many relationship.

A)M:1
B)1:M
C)1:1
D)M:N
E)N:M

Question 20

UML stands for

A)United Metadata Language.
B)Universal Metadata Language.
C)Unified Metadata Language.
D)Unified Modeling Language.
E)Universal Modeling Language.

Question 21

On difficulty with designing database is the __________number of possibilities of what to include.

A)small
B)known
C)minimal
D)large
E)fixed

Question 22

Entities have___________ that describes characteristics of the entity.

A)names
B)relations
C)attributes
D)properties
E)files

Question 23

A column whose value uniquely identifies a specific row in a table is known as the

A)foreign key.
B)index attribute.
C)identifier.
D)key attribute.
E)index field.

Question 24

When a table contains inaccurate data for the same data elements in a table,it is said that the data in the table lacks__________ .

Question 25

The___________shows the number of entities that can be involved in a relationship.

A)UML
B)E -R
C)cardinality
D)workflow
E)data integrity

Question 26

When you place data into a database you need to place (the)___________records first.

A)indexed
B)first
C)foreign key
D)any
E)primary key

Question 27

There is (are)___________ style(s)of E -R diagrams.

A)one
B)2
C)15
D)several
E)10

Question 28

Entities have_______with one another.

Question 29

__________would be the best identifier attribute for an employee table.

A)Social Insurance number
B)Birth Date
C)First Name and Last Name
D)Phone number
E)Last Name

Question 30

If the same data element is stored differently in another table,this is said to be an issue of

A)normalization.
B)entity integrity.
C)data integrity.
D)data repetition.
E)inaccurate data.

Question 31

__________form removes duplicate data and other problems from a table.

Question 32

The foreign key is put on the_____side of a one -to -many relationship.

Question 33

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.

A)1:1
B)N:M
C)M:N
D)1:N
E)N:1

Question 34

___________Is the process of converting poorly -structured tables into two or more well -structured tables.

A)Application development
B)Clarification
C)Structuring
D)Normalization
E)Conversion

Question 35

Database developers__________as the first step in development.

A)create an E -R diagram
B)create a relational model
C)create a data model
D)write queries
E)interview users

Question 36

The cardinality of the relationship between a employer and its employees is

A)1:1.
B)N:M.
C)N:1.
D)M:N.
E)1:N.

Question 37

Entities have an ___________which is an attribute whose value is associated with one and only one entity instance.

A)attribute
B)agenda
C)initial
D)index
E)identifier

Question 38

Database practitioners classify tables into various____________depending on the type of data integrity problems to which they might be subject.

A)strata
B)categories
C)types
D)normal forms
E)layers

Question 39

The most complex type of a relationship is the ___________relationship.

A)1:N
B)M:M
C)1:1
D)N:M
E)N:1

Question 40

__________is a process for ensuring that the tables in a database design are efficient and well -structured.

Question 41

Data _____ problems are serious.

Question 42

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

Question 43

In an E -R data model,the crow's feet symbol is used to indicate the__________side of the relationship.

Question 44

__________ cardinality indicates the most entities that can be involved in a relationship.

Question 45

An E -R data model captures both the entities involved and the __________between the entities.

Question 46

"PartNumber" would be a good identifier for a part entity in a database application.

Question 47

The easiest time to change a database is during the__________stage.

Question 48

A crow's foot diagram is a type of__________ .

Question 49

A(n)__________is a characteristic of an entity.

Question 50

__________is the notation used to describe a many -to -many relationship.

Question 51

The easiest time to make changes to the database structure is during the__________phase.

Question 52

The number of entities that can be involved in a relationship in a data model is called the__________.

Question 53

A(n)__________ is an attribute or group of attributes whose value is associated with one and only one entity instance.

Question 54

__________problems can occur when data is duplicated.

Question 55

Database developers______as the first step in development.

Question 56

Normalization is a trade -off between the elimination of data duplication and processing speed.

Question 57

__________is the second most popular data modeling technique.

Question 58

A(n)__________is something users want to track.

Question 59

A(n)__________is an attribute or group of attributes whose value is associated with one and only one entity instance.

Question 60

In order to represent a(n)__________type of relationship,a third table is created using the keys from the two entities being related.

Question 61

"Name" would be a good identifier for a customer entity in a database application.

Question 62

Once the entities have been defined,the data model can be implemented directly on the DBMS.

Question 63

Users need to verify the data model for correctness.

Question 64

An entity is something you want to track.

Question 65

Users validate and approve the data model prior to its transformation into a database design.

Question 66

In E -R diagrams,attributes can be represented with crow's feet.

Question 67

When two rows in a database are suppose to refer to the same thing and they do not,you have a data integrity problem.

Question 68

E -R diagrams are too cumbersome for use in database design discussions.

Question 69

In a 1:N type of relationship,the foreign key is stored on the "1" side.

Question 70

The easiest time to change a database design is during the data modeling stage.

Question 71

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

Question 72

The Object -Relationship (OR)technique is the most popular one for creating a data model.

Question 73

In E -R diagrams,entities are represented with rectangles.

Question 74

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

Question 75

Each entity should have one unique identifier.

Question 76

Any mistake in the data modeling stage will come back to haunt you.

Question 77

A data model should show how users see their world.

Question 78

The notation N:N indicates a many -to -many relationship.

Question 79

"Address" would be a likely attribute of a customer entity in a database application.

Question 80

At times you may not place a field in a table because it can be readily computed in forms or reports.