MIS 311 Appendix C Quiz – Flashcards

Which of the following is an incorrect statement? A. A primary key is a field that uniquely identifies a given record in a table B. A field is composed of rows and columns that represent an entity C. Date of birth would be a stored attribute D. A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity? A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship D. Composite entity

What have to be created to represent a many-to-many relationship between two entities? A. One-to-one relationship B. One-to-many relationship C. Composite attribute D. Composite entity

Which of the following would not be an attribute? A. Customer number B. Item price C. Distributor D. Order date

Which of the following represents an example of a multi-valued attribute of the student entity? A. Student number B. Student name C. GPA D. Phone number

What does the Chen method use to represent entities? A. Rectangles B. Diamonds and lines C. Triangles D. Ellipse

Which of the following is correct? A. Entities are represented by columns in a physical database B. Attributes are represented by rows in the tables in a physical database C. Instances are represented by tables in a physical database D. None of the above is correct

Which of the below is correct about primary key? A. Primary key is a field (or group of fields) that uniquely identifies a given record in a table B. A unique primary key makes it possible to uniquely identify every row in a table C. The primary key is important to retrieve every single piece of data put into a database D. All of the above

What are qualities of all primary keys? A. A primary key should contain some value that is highly unlikely ever to be null B. A primary key should never change its values C. A primary key should be as complicated as possible D. Both A and B

Which of the following is a type of attribute? A. Single-valued attribute B. Multi-valued attribute C. Null-valued attribute D. All of the above

What kind of attribute would be given for a person who does not have an email address? A. Null-valued attribute B. Multi-valued attribute C. Single-valued attribute D. Stored attribute

Which of the following statements is accurate? A. A correct business rule for one organization may not be correct for another organization. B. Each business rule will have entities and sometimes even attributes. C. A typical business may have hundreds of business rules. D. All of the above.

An Entity Relationship Diagram is a technique for documenting the entities and relationships in a database environment. A. True B. False

In Nate Silver's presentation, which variable was identified to have a strong predictive relationship with racism? A. Income B. Religion C. Education D. Age

Which of the following was a finding from Sean Gourley's study of Iraq War? A. There was a correlation between the size of the attack (the number of people killed) and the frequency of that type of attack B. The same pattern emerged across different wars C. The identified pattern could be used to generate an equation to predict the likelihood of an attack D. All of the above