MIS 311 Appendix C Quiz – Flashcards

Unlock all answers in this set

Unlock answers
question
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
answer
B. A field is composed of rows and columns that represent an entity
question
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
answer
B. One-to-many relationship
question
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
answer
D. Composite entity
question
Which of the following would not be an attribute? A. Customer number B. Item price C. Distributor D. Order date
answer
C. Distributor
question
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
answer
D. Phone number
question
What does the Chen method use to represent entities? A. Rectangles B. Diamonds and lines C. Triangles D. Ellipse
answer
A. Rectangles
question
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
answer
D. None of the above is correct
question
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
answer
D. All of the above
question
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
answer
B. A primary key should never change its values
question
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
answer
D. All of the above
question
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
answer
A. Null-valued attribute
question
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.
answer
D. All of the above.
question
An Entity Relationship Diagram is a technique for documenting the entities and relationships in a database environment. A. True B. False
answer
A. True
question
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
answer
C. Education
question
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
answer
D. All of the above
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New