Number data types require no delimiters.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-2-quiz-latest/

 

Devry BIS 245 Week 2 Quiz Latest

  1. 2.Question : (TCO 2) Which of the following does NOT describe a many-to-many relationship?

Student Answer: There must be at least two tables.

Many matching records exist in each direction between the tables.

A junction table is used.

You can connect to tables in other databases such as Oracle.

Comments:

Question 4. Question : (TCO 3) Queries can do all of the following EXCEPT

Student Answer: display specific records from tables and other queries.

perform calculations.

provide parameters at run time.

run from a table Datasheet View.

Comments:

Question 5. Question : (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?

Student Answer: Date/Time data types need no delimiters.

Date/Time data types need to be enclosed in single quotes.

Number data types require no delimiters.

Text data types require pound signs.

Comments:

Question 10. Question : (TCO 2) What is the special character called to represent one or more characters in the Criteria area of a query?

Student Answer: Delimiter

Operand

Wildcard

Operator

Comments:

 

Download File Now

 


What role does the entity-relationship (ER) diagram play in the design process?

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-2-discussion-1-2-latest/

 

Devry BIS 245 Week 2 Discussion 1 & 2 Latest

Discussion 1

What role does the entity-relationship (ER) diagram play in the design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. Discuss the meaning of an entity as related to ER diagrams. How would you approach the diagramming process?

Discussion 2

Database Table Design (graded)

When designing database tables, the difference between a good design and a bad design can be a few seconds in response time and several minutes. You may think that this is not a huge difference, but imagine waiting several minutes on a web page for your results to load. How long would you wait? A slow database can mean the loss of customers. So let’s begin by discussing some of the common elements of tables and how you would approach the table design. What would you do to ensure that your page loads in a few seconds? Discuss the relationship types and how they affect your design.

 

 

Download File Now