






Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
CIS 223 Database Midterm Review- ECPI University, Newport News
Typology: Exams
1 / 12
This page cannot be seen from the preview
Don't miss anything!
Question 1 provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
Question 2 A data warehouse can store data derived from many sources.
Question 3 What are some reasons for studying file systems?
Question 4 Which of the following is an example of structured data?
Question 5 We are now said to be entering the "knowledge age."
Question 6 Data is a discipline that focuses on proper generation, storage and retrieval of data.
Question 7 The same data might be simultaneously structured and unstructured depending on the intended processing.
Question 8 A(n) develops when all required changes in the redundant data are not made successfully.
A query language is a procedural language.
Question 10 A(n) database is used by an organization and supports many users across many departments.
Question 11 Initially the files within a computer file system were similar to manual files.
Question 12 exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.
Question 13 A(n) might be written by a programmer or it might be created through a DBMS utility program.
Question 14 Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.
Question 15 To reveal meaning, information requires.
Question 16 M:N relationships are not appropriate in a relational model.
Question 17 Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
Question 18 End-user interfaces require the end user to manually generate SQL code.
Describe a conceptual model and its advantages. What is the most widely used conceptual model?
Question 30 The data model is said to be a semantic data model.
Unit 2 Question 1 A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.
Question 2 All primary key entries are unique, and no part of a primary key may be.
Question 3 Fortunately, the problems inherent in the ---------------- relationship can easily be avoided by creating a composite entity.
Question 4 As rare as 1:1 relationships should be, certain conditions absolutely require their use.
Question 5 DBMSs use indexes for many different purposes.
Numeric data are data on which you can perform meaningful arithmetic procedures.
Question 7 What is the system catalog?
Question 8 A(n) is an orderly arrangement used to logically access rows in a table.
Question 9 The index key can have multiple attributes, this is called a(n) index.
Question 10 The relationship should be rare in any relational database design.
Question 11 The DBMS can easily handle multivalued attributes.
Question 12 relationships are most common.
Question 13 The following step occurs first in the process of building an ERD:.
Question 14 All simple attributes are also single-valued.
Question 15 attributes can have many values.
Composite keys are useful as identifiers of weak entities, where the weak entity has a strong relationship with the parent entity.
Question 6 Generalization is based on grouping unique characteristics and relationships of the subtypes.
Question 7 One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
Question 8 A(n) is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
Question 9 completeness means that not every supertype occurrence is a member of a subtype.
Question 10 To model time-variant data, you must create a new entity in a M:N relationship with the original entity.
Question 11 One important inheritance characteristic is that all entity subtypes inherit their key attribute from their supertype.
Question 12 The default comparison condition for the subtype discriminator attribute is the comparison.
Question 13 Subtypes that contain nonunique subsets of the supertype entity set are known as subtypes.
Question 14 Entity subtypes do not inherit the relationships in which the supertype entity participates.
When selecting a foreign key placement for a 1:1 relationship, place the PK of the entity on the mandatory side in the entity on the optional side as a FK, and make the FK mandatory when .
Question 16 Specialization is based on grouping characteristics and relationships of the subtypes.
Question 17 Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the relationship.
Question 18 The " " characteristic of a primary key states the following: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK in an EMPLOYEE table is not a good idea.
Question 19 If you use a surrogate key, you must ensure that the candidate key of the entity in question performs properly through the use of the " " and "not null" constraints.
Question 20 The constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
Question 21 A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
Question 22 The property of enables an entity subtype to inherit the attributes and relationships of the supertype.
Optional Questions from Second Attempt: Question 1 In what two cases are composite primary keys particularly useful?
Question 2 A occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.
Question 3 Non-overlapping subtypes are subtypes that contain a(n) subset of the supertype entity set.
Question 4 What do specialization hierarchies do?
Question 5 An entity cluster is considered "virtual" or " " in the sense that it is not actually an entity in the final ERD.
Question 6 An entity supertype can have disjoint or overlapping entity subtypes.
Question 7 Partial completeness is symbolized by.
Question 8 An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
Question 10 keys work with primary keys to properly implement relationships in the relational model.
Question 11 is the bottom-up process of identifying a higher-level, more generic entity supertype from lower- level entity subtypes.
Question 12 If one exists, a data modeler uses a as the primary key of the entity being modeled.
Question 13 Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed in the M:N relationship.
Question 14 A key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
Mid-Term Review