What is the importance of data validation?

Just Click on Below Link To Download This Course:

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

 

Devry BIS 245 Week 5 Discussion 1 & 2 Latest

Discussion 1
Explain the difference between good and bad table structures. How do you recognize the difference between good and bad structures? What role does normalization play in good and bad table structures, and why is normalization so important to a good table structure?

Discussion 2
What is the importance of data validation? How can we avoid data-entry errors? How can forms help us reduce data-entry errors? What features does Access offer to help validate data? What are the different kinds of validations that are required?

 

Download File Now

 


perform calculations on entire columns of data.

Just Click on Below Link To Download This Course:

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

 

Devry BIS 245 Week 4 Quiz Latest

  1. 1.Question : (TCO 1) Data aggregates

Student Answer: are used to perform calculations on individual records in a table or query.

cannot be used in a report.

perform calculations on entire columns of data.

return multiple values.

Comments:

Question 7. Question : (TCO 2) A function used to isolate a specific portion of a date such as year, month, or day in a date field is

Student Answer: Date.

DateDiff.

DateParse.

DatePart.

Comments:

 

 

Download File Now

 

 


Deliver a short presentation (1 to 2 minutes) in which you introduce yourself to a group of people.

Devry SPCH 275 Week 1 Presentation Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-spch-275-week-1-presentation-latest/

Devry SPCH 275 Week 1 Presentation Latest 

Self-Introduction Speech

Deliver a short presentation (1 to 2 minutes) in which you introduce yourself to a group of people. Think for a short bit about what you might share with either an audience of your peers or people you might be meeting for the first time in a professional situation. Then take a look at the recording presentations guidelines to ensure that you have everything, and begin recording when you are ready. It may take you some time to get all of the logistics (e.g., adequate light, ensuring that the sound level is audible, and framing yourself), so plan to capture at least several test runs before the final recording. Though you may wish to include them, no outline or audience members are required for this presentation.

Download File Now


Describe what the querying technique is and how it is useful.

Just Click on Below Link To Download This Course:

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

 

Devry BIS 245 Week 4 Discussion 1 & 2 Latest

Discussion 1
For purposes of this discussion, assume that Woodcraft is an online store that sells wooden craft kits to churches, scouting organizations, and other groups that need crafts for children. Save Woodcraft’s database to your computer or space in our iLab environment; it’s found at this link: Week 4 Woodcraft Database. The database is also found in the first page of Doc Sharing. View the content and structure of the database, and then choose one of the questions that follow to answer.

Later in the week, you may answer a second or third question, but let’s start off with everyone answering one at a time.

  1. What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business? Describe what information you might want to select from the database in the form of a query, and list the specific columns and data that the query would produce. Assume that they have hundreds of customers, rather than the short list found in the database file.
  2. Suggest additional tables and information that you would like to see in a database like this, the kinds of queries that it would facilitate, and how such queries would help the company improve its business goals of profitability, cost reduction, or other business strategies.
  3. Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week’s lab. Post a screenshot of your query design and result set in a Word document.
  4. Research one new feature that you haven’t studied as it relates to query generation, and show how you could use that feature to create a useful query. Use the Woodcraft database to showcase this query-generation technique and post it in this discussion.

Discussion 2
In Doc Sharing, you will find an Access database labeled Week 4 Discussion Northwind. Save the database to your computer and open the database using Access. Answer the questions below. Please assist one another.

  1. View the design of the database in the Database Tools-Relationships window. Describe some queries that would be useful to Northwind Traders as it strives to increase sales, profits, or reduce expenses. Be specific, listing the tables, columns, and data that you would extract from the Northwind Database. Also, indicate why such queries are useful from a business standpoint.
  2. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document
  3. Create a few queries that allow you to practice concepts from the Lab. Please, don’t simply post queries from this week’s lab assignment! Post a screenshot of the query design and the results set in a Word document. Also, describe how this query could help managers make a business decision.
  4. Relying on the textbook, the lecture, or Internet research, describe query generation techniques that you haven’t yet applied in this week’s lab. Describe what the querying technique is and how it is useful. For example, you might research the concept of a parameter query, describe what it is, and then create such a query in the Northwind database. Post a screenshot of the query design and the query results as an MS Word document to this thread for discussion.
  5. Assist your classmates in modifying their queries if they run into difficulties.

Download File Now

 


More tables can be joined to either table.

Just Click on Below Link To Download This Course:

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

 

Devry BIS 245 Week 3 Quiz Latest

Page 1

Question 1.1.(TCO 2) In a relational database, entities are (Points : 4)

events.
persons.
things.
All of the above

 

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

Database Design
Maintenance and Redevelopment
Performance
Testing

 

Question 3.3.(TCO 3) Database design refers to (Points : 4)

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 4.4.(TCO 2) A crow’s foot (Points : 4)

is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.

 

Question 5.5.(TCO 2) The term cardinality refers to (Points : 4)

a count of the total records in a table.
a field which is a candidate for a primary key.
the number of records in a relationship.
the most important field in a table.

 

Question 6.6.(TCO 2) A primary key (Points : 4)

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.7.(TCO 3) Which does NOT apply to the following relationship image?

.googleusercontent.com/proxy/Un8xM_Ucs59sXr9mw4h0kKKJTo-Q1U4Ge6pmYaAeEzkivh4LWhKDk0wp3LAY8CSdj_-zsgdK-hiNQX4F9Uzke1EK0xkFncR3j_oRAzZBa4gyXmS4qCBRhwIKmFM=s0-d-e1-ft#http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Quiz3%20a.jpg”>

(Points : 4)

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 8.8.(TCO 4) Entity attributes are represented as (Points : 4)

fields.
files.
records.
tables.

 

Question 9.9.(TCO 4) Validation text (Points : 4)

changes the way text data is formatted.
determines the maximum length of a Text field.
requires correct text data input.
specifies the error message when a rule is violated.

 

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

.googleusercontent.com/proxy/dVFPDjkDipDe0670XPCQJG8Ix2jd5IfRXS6hf3D9unPyEhB7nUJsDB8RDsN3fMdReSkIEK2MMjhw7hjJtcbVaPLRecCsfMu7C8O7fc1VmJ5YwayT5MuikfcdBZs=s0-d-e1-ft#http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Quiz3%20c.jpg”>

(Points : 4)

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.

 

 

Download File Now

 


Communication Anxiety Report and Analysis

Devry SPCH 275 Week 1 Homework Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-spch-275-week-1-homework-latest/

Devry SPCH 275 Week 1 Homework Latest 

Communication Anxiety Report and Analysis

Fill out the Personal Report (Links to an external site.)Links to an external site. of Communication Anxiety, and complete the following questions:

What does your report seem to suggest about your level of communication apprehension?

What effect do common causes of communication apprehension noted in the reading (e.g., heredity, learned apprehension, skill deficit, etc.) have on this?

What are some ways found in this week’s readings and this week’s discussion about managing apprehension that may help alleviate challenges or prove useful?

For each question, you should write at least 100 to 200 words in response, using correct grammar, spelling, and syntax. Please submit a copy of your report and your responses in a separate Word (.docx) file.

Download File Now


Explain why you think that a particular relationship applies to that pair of entities.

Just Click on Below Link To Download This Course:

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

 

Devry BIS 245 Week 3 Discussion 1 & 2 Latest

Discussion 1
Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?

Discussion 2
Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.

 

Download File Now

 

 


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

 


EXPERIENCES WITH PUBLIC SPEAKING

Devry SPCH 275 Week 1 Discussion 1 & 2 Latest

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-spch-275-week-1-discussion-1-2-latest/

Devry SPCH 275 Week 1 Discussion 1 & 2 Latest

dq 1

WEEK 1: COMMUNICATION BASICS

5959 unread replies.111111 replies.

This discussion will enable us to lay some of the theoretical groundwork for communication and public speaking. Let’s begin by exploring the basics. How do you define the term communication? Take a few minutes to go through the “Is This Communication?” activity included in this week’s lesson material and report your results.

dq 2

WEEK 1: EXPERIENCES WITH PUBLIC SPEAKING

7474 unread replies.108108 replies.

What have your experiences been with public speaking? Try to share with us a little about the things that you have already done in your personal and professional lives.

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