Categories
Home » Database Systems Design Implementation And Management 12Th Edition by Carlos Coronel -Test Bank

Database Systems Design Implementation And Management 12Th Edition by Carlos Coronel -Test Bank

<< Developmental Psychology Childhood And Adolescence 9th Edition By Shaffer Test Bank Database Concepts 6th Edition By kroenke Test Bank >>
Product Code: 222
Availability: In Stock
Price: $24.99
Qty:     - OR -   Add to Wish List
Add to Compare

Database Systems Design Implementation And Management 12Th Edition by Carlos Coronel -Test Bank

Description

WITH ANSWERS

Database Systems Design Implementation And Management 12Th Edition by Carlos Coronel -Test Bank

CHAPTER 2:  DATA MODELS

 

  1. A data model is usually graphical.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.36

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. An implementation-ready data model neednt necessarily contain enforceable rules to guarantee the integrity of thedata.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.36

NAT:   BUSPROG: Analytic            STATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension                 TOP:         Data Modeling and Data Models

 

  1. An implementation-ready data model should contain a description of the data structure that will store the end-userdata.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.36

NAT:   BUSPROG: Technology         STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. Within the database environment, a data model represents data structures with the purpose of supporting a specificproblem domain.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.36

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. Even when a good database blueprint is available, an applications programmers view of the data should match thatof the manager and the end user.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.37

NAT:   BUSPROG: AnalyticSTATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension                 TOP:         The Importance of Data Models

 

  1. In the context of data models, an entity is a person, place, thing, or event about which data will be collected andstored.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.37-38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:        Data Model Basic Building Blocks

 

  1. Database designers determine the data and information that yield the required understanding of the entire business.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.39

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       Business Rules

 

  1. Business rules apply to businesses and government groups, but not to other types of organizations such as religiousgroups or research laboratories.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.39

NAT:   BUSPROG: Analytic            STATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension                  TOP:       Business Rules

  1. Business rules must be rendered in writing.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.39

NAT:   BUSPROG: Communication STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       Business Rules

 

  1. A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities ofthe relational model from the user.
    1. True
    2. False

 

ANSWER:  False.

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.43

NAT:   BUSPROG: Analytic            STATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension                  TOP:       The Evolution of Data Models

 

  1. In an SQL-based relational database, each table is dependent on every other table.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:        Difficulty: Easy                                       REF:    p.45

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. In an SQL-based relational database, rows in different tables are related based on common values in commonattributes.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                       REF: p.45

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF: p.46

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. M:N relationships are not appropriate in a relational model.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.47

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. In Chen notation, entities and relationships have to be oriented horizontally; not vertically.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.47

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. Today, most relational database products can be classified as object/relational.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.50

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

  1. The network model has structural level dependence.
    1. True
    2. False

 

ANSWER:  True

PTS:    1                                           DIF:        Difficulty: Easy                                       REF:    p.56

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. The external model is the representation of the database as seen by the DBMS.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Easy                                       REF:    p.60

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       Degrees of Data Abstraction

 

  1. The hierarchical model is software-independent.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.62

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       Degrees of Data Abstraction

 

  1. The relational model is hardware-dependent and software-independent.
    1. True
    2. False

 

ANSWER:  False

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.62

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       Degrees of Data Abstraction

 

  1. A(n) s main function is to help one understand the complexities of the realworld environment.
    1. node entity
    2. model d. database

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.36

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. A(n) is anything about which data are to be collected and stored.
    1. attribute entity
    2. relationship d. constraint

 

 

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.37

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Model Basic Building Blocks

 

  1. A(n) represents a particular type of object in the real world.
    1. attribute entity
    2. relationship d. node

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. A(n) is the equivalent of a field in a file system.
    1. attribute entity
    2. relationship d. constraint

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:  p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. A(n) is bidirectional.
    1. attribute entity
    2. relationship d. constraint

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:   p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. A(n) is a restriction placed on the data.
    1. attribute entity
    2. relationship d. constraint

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. are important because they help to ensure data integrity.
    1. Attributes Entities
    2. Relationships d. Constraints

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                       REF:    p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

 

 

  1. are normally expressed in the form of rules.
    1. Attributes Entities
    2. Relationships d. Constraints

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. Students and classes have a
    1. one-to-one one-to-many
    2. many-to-one d. many-to-many

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.38

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Data Modeling and Data Models

 

  1. From a database point of view, the collection of data becomes meaningful only when it reflects properly defined_____.
    1. business rules
    2. business norms
    3. business goals
    4. business plans

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.39

NAT:   BUSPROG: Analytic            STATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension     TOP:   Business Rules

 

  1. Which of the following is true of business rules?
    1. They allow the designer to set company policies with regard to data.
    2. They allow the designer to develop business processes.
    3. They can serve as a communication tool between the users and designers.
    4. They provide a framework for the companys self-actualization.

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Moderate                               REF:    p.40

NAT:   BUSPROG: Analytic            STATE:   DISC: Information Technologies

KEY:   Blooms: Comprehension     TOP:        Business Rules

 

  1. A noun in a business rule translates to a(n) in the data model.
    1. entity attribute
    2. relationship d. constraint

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.40

NAT:   BUSPROG: Communication STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Business Rules

 

 

  1. A verb associating two nouns in a business rule translates to a(n) in the data model.
    1. entity attribute
    2. relationship d. constraint

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.40

NAT:   BUSPROG: Communication STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Business Rules

 

  1. In the model, the basic logical structure is represented as an upside-down tree.
    1. hierarchical network
    2. relational d. entity relationship

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.41

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. In the model, each parent can have many children, but each child has only one parent.
    1. hierarchical network
    2. relational d. entity relationship

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Easy                                                  REF:    p.41

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The hierarchical data model was developed in the .a. 1960s 1970s
  2. 1980s d. 1990s

 

ANSWER:  a

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.41

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. In the model, the user perceives the database as a collection of records in 1:M relationships, where eachrecord can have more than one parent.
    1. hierarchical network
    2. object-oriented d. entity relationship

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.41-42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The object-oriented data model was developed in the 1960s b. 1970s
  2. 1980s d. 1990s

 

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. VMS/VSAM is an example of the .
    1. hierarchical model file system data model
    2. relational data model d. XML data model

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. Oracle 11g is an example of the .
    1. hierarchical model file system data model
    2. relational data model d. XML/Hybrid data model

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. MySQL is an example of the .
    1. hierarchical model file system data model
    2. relational data model d. XML data model

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

Relationship.

 

  1. A(n) enables a database administrator to describe schema components.
    1. extensible markup language (XML) data definition language (DDL)
    2. unified modeling language (UML) d. query language

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.42

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The relational data model was developed in the .a. 1960s 1970s
  2. 1980s d. 1990s

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.43

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The model was developed to allow designers to use a graphical tool to examine structures rather thandescribing them with text.
    1. hierarchical network
    2. object-oriented d. entity relationship

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.45

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:        The Evolution of Data Models

 

  1. A(n) enables a database administrator to describe schema components.
    1. extensible markup language (XML) data definition language (DDL)
    2. unified modeling language (UML) d. query language

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.45

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The model uses the term connectivity to label the relationship types.
    1. relational network
    2. object-oriented d. entity relationship

 

ANSWER:  d

PTS:    1                                           DIF:         Difficulty: Easy                                       REF:    p.46

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:       The Evolution of Data Models

 

  1. The data model is said to be a semantic data model.
    1. relational network
    2. object-oriented d. entity relationship

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.48

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The data model uses the concept of inheritance.
    1. relational network
    2. object-oriented d. entity relationship

 

ANSWER:  c

PTS:    1                                           DIF:        Difficulty: Easy                                       REF:    p.50

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. Which of the following types of HDFS nodes stores all the metadata about a file system?
    1. Data node Client node
    2. Name node d. Map node

 

 

ANSWER:  c

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.52

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:        The Evolution of Data Models

 

  1. Which of the following is true of NoSQL databases?
    1. They do not support distributed database architectures. They are not based on the relational model.
  2. They are geared toward transaction consistency rather They do not support very large amounts of

than performance.sparse data.

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.53

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

 

  1. Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?
    1. Data node Client node
    2. Name node d. Map node

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                       REF:    p.53

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:         The Evolution of Data Models

 

  1. NoSQL databases:
    1. are geared toward transaction consistency; not performance. support only small amounts of sparse data.
    2. are based on the relational model. d. provide fault tolerance.

 

ANSWER:  d

PTS:    1                                            DIF:         Difficulty: Easy                                       REF:    p.55

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:         The Evolution of Data Models

 

  1. Which of the following is a disadvantage of the hierarchical data model?
    1. It does not promote data sharing. It is not efficient with 1:M relationships.
    2. It does not promote data integrity. d. It does not have standards.

 

ANSWER:  d

PTS:    1                                           DIF:        Difficulty: Easy                                       REF:    p.58

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge             TOP:        The Evolution of Data Models

 

  1. One of the limitations of the model is that there is a lack of standards.
    1. hierarchical network
    2. relational d. entity relationship

 

 

 

 

 

ANSWER:  a

PTS:    1                                           DIF:        Difficulty: Easy                                       REF:    p.58

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. The model is the end users view of the data environment.
    1. abstract external
    2. conceptual d. internal

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                       REF:    p.60

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        The Evolution of Data Models

 

  1. An internal refers to a specific representation of an internal model, using the database constructs supportedby the chosen database.
    1. tuple schema
    2. object d. value

 

ANSWER:  b

PTS:    1                                           DIF:         Difficulty: Easy                                      REF:    p.62

NAT:   BUSPROG: Technology       STATE:   DISC: Information Technologies

KEY:   Blooms: Knowledge            TOP:        Degrees of Data Abstraction

 

  1. A(n) is a relatively simple representation of more complex real-world data structures.

ANSWER:  data model

PTS:    1                                           DIF:         Difficulty: Easy     &nbs

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below:



Continue

 

Once the order is placed, the order will be delivered to your email less than 24 hours, mostly within 4 hours. 

If you have questions, you can contact us here

May also like