IDS EXAM 2

Which of the following statements correctly describes a foreign​ key?

A. A foreign key is a key that is not properly formatted. B. A foreign key is a primary key from one table represented in another table. C. A foreign key is a subkey to a primary key. D. A foreign key is a key from a table in a​ competitor's database. E. Foreign keys are obsolete technology. B

Which of the following statements about information system data integrity is​ FALSE?

A. A table that has data integrity problems will produce incorrect and inconsistent information. B. Normalization is the process of converting poorly structured tables into two or more​ well-structured tables. C. Information systems with poor reputations have no effect on the organizations that use them. D. An information system that has data integrity problems will make users lose confidence in the​ information, and the system will develop a poor reputation. E. Database design is the process of converting a data model into​ tables, relationships, and data constraints. D

Which of the following statements about entities is​ FALSE?

A. All entities represent a physical object. B. Entities have an​ identifier, which is an attribute​ (or group of​ attributes) whose value is associated with one and only one entity instance. C. An entity is something that the users want to track. D. Entity names are always singular. E. Entities have attributes that describe characteristics of the entity. A

In the fictional public television scenario described in the​ text, why did the consultant dislike having the Name column as a​ key?

A. Because names have no meaning to users B. Because the user did not want to show names in the database C. Because you cannot use a name as a key D. Because the name can be recorded in different ways E. Because there are too many different names D

What is a model of how users view their business​ world?

A. Entity diagram B. Report C. Database D. Data model E. Record C

Which of the following statements about identifiers is​ FALSE?

A. If each member of the sales staff always has a unique​ name, then SalespersonName is an identifier of Salesperson. B. An identifier is an attribute​ (or group of​ attributes) whose value is associated with one and only one entity instance. C. An identifier may have a value that is associated with more than one entity instance. D. OrderNumber is an identifier of Order. E. CustomerNumber is an identifier of Customer. C

Which of the following statements regarding relationships between entities in the​ entity-relationship data model is​ FALSE?

A. If one university department can have many academic advisors that work with​ students, this is a​ one-to-many relationship. B. Cardinality expresses the maximum and minimum number of entities required in a relationship. C. A​ crow's-foot diagram is the only acceptable technique to depict an​ entity-relationship diagram. D. If one academic advisor can have many students and one student can have many​ advisors, this is a​ many-to-many relationship. E. If one student can take many classes and each class can have many students in​ it, the relationship between student and class is a​ many-to-many relationship. C

Which of the following statements about transforming a data model into a database design is​ FALSE?

A. Represent each entity with a table B. Normalize tables as necessary C. Add additional tables to handle​ N:M relationships D. Represent relationships using primary keys E. Convert entity attributes into table columns D

Which of the following activities does NOT occur when transforming a data model into a database​ design?

A. Represent each entity with a table. B. Ensure that the entity identifier becomes the table column. C. Add additional tables for​ N:M relationships. D. Normalize tables as necessary. E. Represent relationships using foreign keys. B

Which of the following statements about data modeling is​ true?

A. The data model only contains the relationships among the data. B. The data model only contains a description of the data. C. The data model is developed by the users of the database. D. It is a logical representation of the structure of the data. E. A data model is not needed in the database development process. D

Which of the following statements about data integrity is​ FALSE?

A. The general goal of normalization is to construct tables such that every table has a single topic or theme. B. Maximum cardinality involves transforming a table into a normal form to remove duplicated data and other problems. C. Duplicated data can be eliminated by transforming table design into two tables. D. The data integrity problem can occur only if data are duplicated. E. Normalized tables eliminate data​ duplication, but they can be slower to process. B

Which of the following statements about the​ entity-relationship (E-R) data model is​ FALSE?

A. The​ entity-relationship data model and the Unified Modeling Language are both techniques of creating a data model. B. The most popular technique for creating a data model is the​ entity-relationship (E-R) data model. C. The developers describe the relationships among entities using the​ entity-relationship (E-R) data model. D. The developers describe the content of a database by defining the things ​(entities​) that will be stored in the database using the​ entity-relationship (E-R) data model. E. The​ entity-relationship (E-R) data model is a less popular technique for creating a data model. E

Which of the following statements about user reviews of the data model is​ FALSE?

A. Users should not review or influence the data model. They should leave such tasks to the IT professionals. B. When asked to review a data​ model, a user should take that review seriously. C. User review of a data model is crucial. D. When a database is developed for a given​ user, that user must carefully review the data model. E. If users do not understand any aspect of the data​ model, they should ask for clarification. A

How should a user handle a situation when asked to review a data​ model?

A. Wait until the end of the project. B. Take the request seriously. C. Defer all requests to senior management. D. Ask the IT people for feedback. E. Review parts of the data model at the beginning and the rest at the end. B

Which of the following statements about the​ user's role in database creation is​ FALSE?

A. When a database is developed for the​ user, the user must carefully review the data model. B. Users are the final judges of what data the database should contain and how the records in that database should be related to one another. C. It is not mandatory for the data model to accurately reflect the​ user's view of the business. D. Databases can be more difficult to develop than spreadsheets. E. The easiest time to change the database structure is during the data modeling stage. C

When is the easiest time to change a database​ structure?

A. When the database has been loaded with data B. At any stage if the user notices the database structure is incorrect C. During the data modeling stage D. After the reports have been created E. During the application​ program's creation stage C

A database application consists of the following EXCEPT​ ________.

A. forms B. queries C. application programs D. reports E. DBMS E

Which of the following statements about the database development process is​ FALSE?

A. ​First, the developers interview users and develop the requirements for the new system. B. The database developers usually know everything to include in the database from the start. C. During the interview and requirement development​ process, the developers determine the need for new​ forms, reports, and queries. D. During the interview and requirement development​ process, the developers analyze existing​ forms, reports,​ queries, and other user activities. E. The requirements for the database are summarized in a data model. B