Devry BIS245 week 3 quiz

Grade Details – All Questions

Question 1. Question : (TCO 2) Which of the following is an example of an entity in a business?

Student Answer: Company

Business owner

CEO

Employees

Question 2. Question : (TCO 2) Which of the following is NOT a step in the Database Life Cycle?

Student Answer: Database Design

Maintenance and Redevelopment

Performance

Testing

Question 3. Question : (TCO 3) When troubleshooting a relationship, all of the following should be done EXCEPT

Student Answer: creating a relationship between like data types.

checking the size of fields to be used in the relationship.

checking that the correct type of relationship is established.

deleting the relationship and field and then rebuilding.

Question 4. Question : (TCO 2) A domain is a

Student Answer: group of data types that describe what kind of information that may be stored in a field.

model of the database.

set of values.

the set of primary and foreign keys in a database.

Instructor Explanation: Chapter 3: Frost section of book

Question 5. Question : (TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

Student Answer: a junction (associative) table is used.

many matching records are found in each direction between tables.

may be used to connect to Oracle and other databases.

there must be at least two tables.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 6. Question : (TCO 2) A primary key

Student Answer: can be computer generated.

consists of one field only that uniquely identifies each record in a table.

is a relationship between two or more tables.

All of the above.

Question 7. Question : (TCO 3) Which of the following does NOT describe data redundancy?

Student Answer: The same data exists in multiple tables.

The data is always in linked tables.

Data updating must be done in multiple table locations.

Data redundancy can result in data anomalies.

Question 8. Question : (TCO 4) Based on the image, which statement below is NOT true of the one-to-many relationships?

Student Answer: It is the least used type of relationship.

OrderID is a unique identification number that would be used in the Orders table and Order Details table.

Each record in the Orders table may match one, more than one, or no records in the Order Details table.

Each record in the Orders table matches only one record in the Customers table.

Question 9. Question : (TCO 4) Which is NOT true of a calculated field?

Student Answer: It cannot be added to queries or reports.

The value of a calculated field is produced from an expression.

A calculated field references other fields.

The result is useful at the moment the calculation is made.

Question 10. Question : (TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire?

Student Answer: Date arithmetic

Constant

Date/time field

Calculated field

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.