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