INF 322 Week 5 Final Project

INF 322 Week 5 Final Project

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-5-final-project/

Product Description

Focus of the Final Project

  1. Use the Access database you created in Week 3: Customer Service Database 2. Output 3 queries using SQL code and not the standard access view:

A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.

  1. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
  2. Report on Customers in Database showing Names, State, and Phone Numbers.
  3. Create a report showing contact name and birthdays. Do not show records without a birthday.
  4. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what

the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of

data.

  1. All data and screen shots should be included in a Word document with a brief explanation of the actions you

performed.

Carefully review the Grading Rubric in the online classroom for the criteria that will be used to evaluate your assignment.

Advertisements

INF 322 Week 5 DQ 2 Bending the Rules

INF 322 Week 5 DQ 2 Bending the Rules

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-5-dq-2-bending-the-rules/

Product Description

Bending the Rules. Chapter 15 discusses bending or breaking the rules. Can you think of a situation where you would apply this practice? List an example and which rule you would be bending or breaking. Respond to at least two of your classmates’ postings.

INF 322 Week 5 DQ 1 Views

INF 322 Week 5 DQ 1 Views

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-5-dq-1-views/

Product Description

Views. There are three types of views. Pick one of them and provide a definition, an example of that type of view, and when you would use the view. If you have ever purchased anything online and returned to the vendor Web site, many views of data will be accessible when you login, including your previous orders, their catalog of product, and even your shipping and credit card information. Think of examples like this before you respond. Respond to at least two of your classmates’ postings.

INF 322 Week 4 DQ 2 Business Rules

INF 322 Week 4 DQ 2 Business Rules

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-4-dq-2-business-rules/

Product Description

Business Rules. There is a great deal of information to consider when planning business rules. Now that you have read Chapter 11, think of a business rule from a place you have been employed at and use that in an example. This could be around defining user access or field specific data, deciding if a field is required or if a field has data validation. How effective was the application of the business rule? Please be specific in your example. Respond to at least two of your classmates’ postings.

INF 322 Week 4 DQ 1 Table Relationships

INF 322 Week 4 DQ 1 Table Relationships

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-4-dq-1-table-relationships/

Product Description

Table Relationships. Chapter 10 discusses table relationships. Define one type of relationship (one-to-one, one-to-many, many-to-many and self-referencing relationships) and provide an example of this type of data relationship. Respond to at least two of your classmates’ postings

INF 322 Week 3 DQ 2 Determining System Requirements

INF 322 Week 3 DQ 2 Determining System Requirements

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-3-dq-2-determining-system-requirements/

Product Description

Determining System Requirements. Identify the database or process you would like to begin to think about for your future database design. After you have developed a database idea, you need to plan the interviewing of your users. Interviewing will give you a better understanding of user needs, wants, and desires, as well as help you to determine your system requirements. What questions should you ask? How do you think this will help you in determining your table and field requirements? When do you think it would be important to make these decisions? Respond to at least two of your classmates’ postings.

Customer Service Database. Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment.

INF 322 Week 3 DQ 1 Keys

INF 322 Week 3 DQ 1 Keys

To Download This Material Click HERE: DOWNLOAD

Or Copy The Link:  http://www.fortuneofstudents.com/inf-322-week-3-dq-1-keys/

Product Description

Keys. Why is a Key important in a database? How does it help with Referential Integrity? Chapter 8 lists three compelling reasons why Keys are crucial to table structure. There is an example of a table and its’ key in Figure 8.2. Respond to at least two of your classmates’ posting