Deck 12: Designing Databases and Entity-Relationship Diagramming

Question 1

Which of the following characterizes a relational database?

A)A three-dimensional table or file of information
B)An object-oriented storage and data management system
C)A series of related worksheets populated with information
D)A logically related two-dimensional table or file of information

Answer 1

D
Explanation: A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Question 2

There are _____ primary steps in designing and building a database.

A)two
B)three
C)four
D)six

Answer 2

C
Explanation: Using a database amounts to more than just using various DBMS tools.The four primary steps in designing and building a database include:1.Define entity classes and primary keys.2.Define relationships among entity classes.3.Define information (fields)for each relation (the term relation is often used to refer to a file while designing a database).4.Use a data definition language to create your database.

Question 3

Which of the following would be a good primary key for the entity class of students?

A)Course ID
B)Student Course name
C)Student ID
D)Institute ID

Answer 3

C
Explanation: The primary key for each entity class uniquely defines each record or instance within the entity class.

Question 4

Why would you define business rules for a database?

A)To help define the correct structure of your database
B)To ensure smooth transfer of files containing information
C)To ensure that information is entered into the database correctly
D)To ensure that information is maintained properly

Question 5

Which symbol would you use in an E-R diagram to show that a course is taught by only one teacher?

A)Straight,vertical line ( | )
B)Crow's foot
C)Solid arrow
D)Circle

Question 6

Which symbol should you use in an E-R diagram to show the relationship between a student and the courses they are currently enrolled in?

A)Circle
B)Triangle
C)Dotted line
D)Arrow

Question 7

Which of the following denotes a relationship between entity classes in an E-R diagram?

A)Dotted line
B)Curved line
C)Arrow
D)Circle

Question 8

What is an instance?

A)It is a key that uniquely identifies a person,place,or thing.
B)It is a group of related information about an entity.
C)It is a record or row in a relation.
D)It is an occurrence of an entity class that can be identified by a primary key.

Question 9

Relational databases are similar to spreadsheets in that:

A)you maintain information in two-dimensional files.
B)you maintain information in three-dimensional files.
C)you compress information in order to store them.
D)you create primary keys for each entity class.

Question 10

What is a primary key?

A)The password used to protect a database
B)A collection of information that you organize and access according to the logical structure of that information.
C)A field or group of fields that uniquely describes each record in a database
D)The authorization key that establishes the usage rights for the database

Question 11

Which of the following is a graphic method of representing entity classes and their relationships?

A)Database model
B)Flowchart
C)Pie chart
D)E-R diagram

Question 12

Which of the following defines a database?

A)A software application that works primarily with numbers and is commonly used to execute calculations
B)A collection of information that is organized and accessed according to the logical structure of that information
C)A three-dimensional table of information
D)A concept in which you wish to store information and that you can identify with a unique key

Question 13

Which of the following is true about an entity class?

A)It is a field or class of fields that uniquely identifies information about an entity.
B)It is an occurrence of an entity class.
C)It represents a group or class of information that sits separately from other information in the database.
D)It typically consists of people,places,or things that you wish to store information about in the database.

Question 14

What is the first step in designing and building a database?

A)Defining entity classes and primary keys
B)Defining relationships among entity classes
C)Defining information for each relation
D)Defining the maintenance cycle for future enhancements

Question 15

_____ are statements concerning the information you need to work with and the relationships within the information.

A)Entity classes
B)Business rules
C)Instances
D)Foreign keys

Question 16

An E-R diagram includes five basic symbols.Which one denotes an entity class?

A)Line
B)Rectangle
C)Circle
D)Crow's foot

Question 17

An E-R diagram includes five basic symbols.Which of the following denotes a single relationship between entity classes?

A)A crow's foot (shown as <)
B)A "|" symbol
C)A dotted line
D)A circle

Question 18

A supplier is an example of a(n)____.

A)relational database
B)entity class
C)foreign key
D)Business rule

Question 19

An organization wishes to store information about its employees in a database.The employees,in this case,constitute a(n)____.

A)foreign key
B)primary key
C)entity class
D)data dictionary

Question 20

What is the most popular type of database?

A)Relational database
B)Embedded database
C)Graph database
D)Parallel database

Question 21

A data dictionary contains:

A)an external listing of relations and the fields stored in each.
B)the logical structure for the information in a database.
C)the definitions associated with database management systems.
D)a listing of business rules and the data these rules create.

Question 22

If a student's ID was also present in a relation that stored enrollment information,this field in the enrollment relation would be called a(n)_____ key.

A)intersecting
B)composite
C)merged
D)foreign

Question 23

A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Question 24

An intersection relation is also known as a(n)_____ relation.

A)primary
B)connection
C)composite
D)merged

Question 25

A foreign key is a:

A)primary key of one relation that appears in another relation.
B)primary key that contains a needed translation of the primary key from the same relation.
C)field that reformats the primary key so that it can be used in another application.
D)field that contains a primary key from an external database.

Question 26

An intersection relation consists of:

A)summary information.
B)primary keys for all entity classes in the relational database.
C)primary key fields from the intersecting relations.
D)definitions for the intersecting relations.

Question 27

_____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables.

A)Normalization
B)Standardization
C)Planning
D)Cross-functional modeling

Question 28

A composite primary key is:

A)a merged field containing the primary key and descriptive information.
B)a key in the intersecting relation that contains the primary keys from the two intersecting relations.
C)a field composed of information from multiple sources.
D)a unique field that can be used throughout the organization to identify an entity.

Question 29

If you find a many-to-many relationship,which of the following is a guideline to be followed when creating an intersection relation?

A)Create a new E-R diagram (showing no cardinality)with the original two relations in the middle and a new one (the intersection relation)in the end.
B)Move the minimum cardinality appearing next to the left relation just to the left of the intersection relation.
C)Move the minimum cardinality appearing next to the right relation just to the right of the intersection relation.
D)The new minimum and maximum cardinalities for the two original relations will be one and one.

Question 30

If you were looking at an E-R diagram,how would you be able to identify a many-to-many relationship between two entities?

A)There would be multiple entities sharing the same name.
B)There would be a crow's foot on each end of the relationship between the two entities.
C)There would be a double-edged arrow pointing to the many side of the relationship.
D)There would be a double line linking the two entities together.

Question 31

When defining information (fields)for a relation,you should ensure that:

A)the information for this relation cannot be derived from other information.
B)the information for this relation can be found in other relations.
C)the information can be identified by the primary key and by other fields in the relation.
D)the information can be identified by the foreign key in this relation.

Question 32

A database management system is:

A)a complete set of relations,their links,and the data stored in the database.
B)an application that allows you to specify the logical structure for a database and access the information within it.
C)a logical structure for the information within the database.
D)a data dictionary for a specific relational database.

Question 33

Which of the following denotes a multiple relationship between entity classes in an E-R diagram?

A)Double line
B)Dotted line
C)The symbol "|"
D)Crow's foot

Question 34

An E-R diagram includes five basic symbols.Which one denotes an optional relationship between entity classes?

A)Dotted line
B)Circle
C)Triangle
D)Straight,vertical symbol ( | )

Question 35

Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course?

A)Double-line circle
B)Solid arrow
C)Double straight line
D)Crow's foot

Question 36

Which of the following is not one of the rules of normalization?

A)Assure that the operating version of your relational database is consistent throughout the organization
B)Eliminate repeating groups or many-to-many relationships
C)Assure that each field in a relation depends only on the primary key for that relation
D)Remove all derived fields from the relations

Question 37

A database is a collection of information that you organize and access according to the logical structure of that information.

Question 38

Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course?

A)Circle
B)Square
C)Arrow
D)Straight,vertical line ( | )

Question 39

The primary key fields from the two original relations become foreign keys in the intersection relation.When combined,the two foreign keys make up the _____ for the intersection relation.

A)merged key
B)composite primary key
C)combined key
D)intersecting key

Question 40

An intersection relation is:

A)a temporary relation that pulls information from other linked relations.
B)a relation that holds aggregate or summary information.
C)a relation you create to eliminate a many-to-many relationship.
D)a relation that identifies and stores the primary key for all entity classes.

Question 41

An entity-relationship (E-R)diagram is a graphic method of representing entity classes and their relationships.

Question 42

Business rules help you define the correct structure of your database.

Question 43

A relational database is the most popular of all database types.

Question 44

The first step in designing a relational database involves defining information for each relation.

Question 45

An E-R diagram includes four basic symbols.

Question 46

An instance uniquely describes records.

Question 47

An entity class is a table which stores similar information and can be identified with a common key.

Question 48

Your implementation of technology should match the way your business works.

Question 49

In an E-R diagram,a rectangle denotes a relationship.

Question 50

The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality."

Question 51

A primary key is a field (or group of fields in some cases)that uniquely describes each record.

Question 52

A Social security number is an example of a primary key because it is unique.

Question 53

In an E-R diagram,"|" denotes a single relationship.

Question 54

In an E-R diagram,O is used to denote an entity class.

Question 55

Before you begin the process of designing a database,it is important that you first understand the business rules.

Question 56

Once you've implemented your database,you can neither change nor add information.

Question 57

In an E-R diagram,crow's foot denotes a multiple relationship.

Question 58

In an E-R diagram,a dotted line denotes an entity class.

Question 59

When creating a database you don't need to know the physical location of the information you want to see or use.

Question 60

Defining relationships among entity classes is the second step in designing and building a relational database.

Question 61

A(n)_____ is a concept about which you wish to store information and that you can identify with a unique key.

Question 62

The goal of the first step in designing a relational database is to define and identify _____ and their primary keys for your database.

Question 63

The first step in designing a _____ is to define the various entity classes and the primary keys that uniquely define each record or instance within each entity class.

Question 64

Repeating groups should be eliminated during database design.

Question 65

The first rule of normalization states that repeating groups can exist among the entity classes.

Question 66

To develop the numerical relationships or cardinality among entity classes,you must clearly understand the business environment and its business rules.

Question 67

The staff of a hospital,a supplier of optical fibers,raw materials for production are all examples of ____.

Question 68

A foreign key consists of the primary key fields from two intersecting relations.

Question 69

A(n)_____ is a field (or group of fields in some cases)that uniquely describes each record.

Question 70

A data dictionary consists of the primary key fields from the two intersecting relations.

Question 71

_____ are statements concerning the information you need to work with and the relationships within the information.

Question 72

An intersection relation is a relation you create to detect a many-to-many relationship.

Question 73

Normalization is a process of assuring that a relational database structure can be implemented as a series of three-dimensional relations.

Question 74

A library wishes to store information about its members in its database.Here,members belong to a(n)____ class.

Question 75

A(n)_____ is an occurrence of an entity class that can be uniquely described.

Question 76

A relational database uses a series of logically related _____ tables or files to store information in the form of a database.

Question 77

Defining entity classes and primary keys is the third step in designing and building a relational database.

Question 78

A library provides its members with a unique member ID and uses that ID for identification.This unique ID used instead of a member's name is an example of ____.

Question 79

A database management system helps you specify the logical organization for a database and use the information within it.

Question 80

A(n)_____ is a collection of information that you organize and access according to the logical structure of that information.