Exam 1 - CIS 241 Fall 2013 Exam 1 (chapters 1-5) TRUE /...

This preview shows page 1 - 2 out of 5 pages.

CIS 241 Fall 2013Exam 1 (chapters 1-5)TRUE / FALSE (indicate T or F)1.Data constitute the building blocks of information.2.Metadata present a more complete picture of the data in the database than the data itself.3.Structural dependence exists when it is possible to make changes in the file structurewithout affecting the application program’s ability to access the data.4.The relationships depicted within the specialization hierarchy are sometimes described in terms of“is-a” relationships.5.Data modeling starts with a very complex representation, and as knowledge of theproblem is gained, the model is simplified.6.M:N relationships are not appropriate in a relational model.7.The entity relationship model is limited to conceptual modeling, with no implementationcomponent.8.The order of the rows and columns is important to the DBMS.9.A design trap occurs when a relationship is improperly or incompletely identified and is thereforerepresented in a way that is not consistent with the real world.10.If the attribute (B) is functionally dependent on a composite key (A) but not on any subsetof that composite key, the attribute (B) is fully functionally dependent on (A).11.Entity subtypes do not inherit the relationships in which the supertype entity participates.12.A data dictionary is sometimes described as “the database designer’s database” because itrecords the design decisions about tables and their structures.13.As rare as 1:1 relationships should be, certain conditions absolutely requiretheir use.14.The word “entity” in the ER model corresponds to a table.15.Generalization is based on grouping unique characteristics and relationships of the subtypes.

Upload your study docs or become a

Course Hero member to access this document

We have textbook solutions for you!
/Systems-Analysis-and-Design-in-a-Changing-World-7th-Edition-9781305117204-1172/
The document you are viewing contains questions related to this textbook.
Chapter 9 / Exercise 7
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Relational model, Database management system, Distributed Database
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Systems Analysis and Design in a Changing World
The document you are viewing contains questions related to this textbook.
Chapter 9 / Exercise 7
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture