TAKE MY CLASS

BIS 245 Week 3 Quiz

Name: Devry BIS 245 Week 3 Quiz - Homework Help
Price: 12.00 USD
Availability: InStock

$12.00

Question :

(TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT

	Student Answer:		Can you envision more than one instance of the entity?
			Is there a variation over time?
			Is the item to be modeled a person, place, thing, or an event?
			Is the item to be modeled an attribute?

Question :

(TCO 2) Physical design refers to

	Student Answer:		developing a database model that will support company operations.
			purchasing your hardware components.
			selecting the specific hardware characteristics based on data storage and data access requirements.
			the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.

Question :

(TCO 3) Database design refers to

	Student Answer:		developing a database model that will support company operations.
			focusing on understanding the business and its functional areas or business processes.
			selecting the specific hardware characteristics based on data storage and data access requirements.
			the process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.

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.

Question :

(TCO 3) Which does NOT apply to the following relationship image?

	Student Answer:		A one-to-many relationship is shown between Orders and Order Details.
			The display is showing the Design View of relationships.
			Order Details has a composite primary key.
			Within the Orders Details table, the ProductID field will contain unique values only.

Question :

(TCO 4) To which of the following does the term cascading refer?

	Student Answer:		Data changes travel from one table to another.
			Data is put in sequential order.
			Queries can retrieve data at a faster rate.
			Records are arranged in order.

Question :

(TCO 4) Which of the following is NOT true of a birth date field?

	Student Answer:		A birth date is considered a constant.
			A birth date would be defined as a date/time field.
			The Age field is the same as a birth date field.
			Date arithmetic can be applied to a birth date field.

10.

Question :

(TCO 4) Based on the image, which statement does NOT describe the following one-to-one relationship?

	Student Answer:		An excel upload would impact the integrity of the data based on the table design.
			Author and AuthorNew tables use the same primary key.
			More tables can be joined to either table.
			It may be used for security reasons to protect data availability.