Identify the referential integrity in your database

Assignment Help Management Information Sys

Reference no: EM131164907

Assignment 1

Database Modeling

After reading this week's article, "Modeling for the Future," expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further (or identify other commercially available modeling tools), compare three tools, and apply your findings as if you were selecting one of the tools for use at your place of employment. Be sure to include comparative detail information on implementation scenarios, target industries, company types most suited for the tool, costs, software type, the type of operating system required, and the target user population.

Select one of the tools previously compared, and discuss the benefits and the shortcomings. Discuss how this tool will help meet the data modeling requirements for your employer's database development needs.

Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts. In addition to the article, include a website reference for each of the three tools you research. The website references must come from the software vendor or other credible source.

Your paper must be two to three pages in length and must be formatted according to APA style as outlined in the Ashford Writing Center.

Modeling for the Future

https://books.google.com/books?id=xz4EAAAAMBAJ&pg=PA60&dq=Modeling+for+the+future+InfoWorld&hl=en&sa=X&ved=0ahUKEwinmI6fl63OAhXDOCYKHYapCnQQ6AEIHDAA#v=onepage&q=Modeling%20for%20the%20future%20InfoWorld&f=false

Assignment 2

Customer Service Database

Show a Structured Query Language (SQL) query, and screenshot your results into a Microsoft Word document to submit to your instructor. For Part 2, provide explanations and screenshots documenting Steps 1 through 4.

Part 1:

Please download, unzip, and open this zip file of the Microsoft Access Customer Service Database.

Save your database.

You should now be able to use Microsoft Access and the database created to complete the assignment.

Part 2:

Add 10 customers to the database using the Customers table. Show the table, including the SQL Code.

Using SQL query, update more than one element in a customer record. Show before and after data, including the SQL code.

Add an 11th customer, and then delete them with a SQL query. Show before and after data, including the SQL Code.

Create a report displaying the customer records using multiple tables. Identify the primary keys in the tables you are reporting on, and show the results of your report.

Screenshot your results into a Microsoft Word document to submit to your instructor using your First and Last name as the file name.

SQL statements should be complex. All data and screenshots should be included in a word document with an explanation of the actions you performed. The document should have a minimum of six screenshots with explanations.

Your paper should be formatted according to APA style as outlined in the Ashford Writing Center.

Assignment 3

The Final Project consists of building a customer service database to be submitted by the final day of the course.

Focus of the Final Project

Using the Microsoft Access database you created in Week Three: Customer Service Database, complete the following:

Output three queries using Structured Query Language (SQL) code (not the standard access view). Provide examples of operations. You should include the following:

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.

Using SQL commands add a field called Birthday to the Customers table. Populate the Birthday field for some of the table records (not all of the table records). This is important for step #4. Populate all other fields with data. Show your SQL query in a screenshot with before and after data.

Report on Customers in Database showing Names, State, and Phone Numbers. Show the SQL query and the resulting report in a screenshot.

Create a report showing contact names and birthdays. Do not show records without a birthday. Show the report and the SQL query in a screenshot.

Provide an explanation of referential integrity, including how a lack of referential integrity can compromise data in the dataset and provide examples. Identify the referential integrity in your database. Show the affected tables in each dataset and how the data elements are impacted as the result of add, change, or deletion (UAD) operations in a before and after screenshot.

All data and screenshots should be included in a Word document with an explanation of the actions you performed.

Book:

Hernandez, M. J. (2003). Database Design for Mere Mortals (2nd ed.). Boston: Addison-Wesley. ISBN: 9780201752847

Reference no: EM131164907

Questions Cloud

What price should the company charge : If demand falls to 80,000 units and the company wants to continue to earn a 50% return, what price should the company charge?

What is the importance of public relations to the marketing : What is the importance of public relations to the Marketing Communications Plan? What is the role of trade promotions in the Marketing Communications Plan

Neighborhood grill company : Unit selling price = $200; Variable cost per unit = $100; Fixed Costs = $36,000; Tax rate = 25%. How many units should Neighborhood Grill sell to achieve an after-tax target income of $6,000?

Write a loop-closure equation for this mechanism : If the input is the displacement of the cylinder, what are the unknowns?

Identify the referential integrity in your database : Provide an explanation of referential integrity, including how a lack of referential integrity can compromise data in the dataset and provide examples. Identify the referential integrity in your database. Show the affected tables in each dataset a..

Charges customers for indirect costs : A company using activity based pricing marks up the direct cost of goods by 40% plus charges customers for indirect costs based on the activities utilized by the customer.

Problem regarding the strategic form of a game theory : Explain how the he extensive form a game theory is detailed more than the strategic form of a game theory?

Write a loop-closure equation for this mechanism : Express the position of point P in terms of the input angle.

Return on investment for that scenario : If the new training program will reduce these costs to $60,000 per year, what is the maximum acceptable cost to initiate the program to reach the break-even point within three years? What is the return on investment for that scenario? 200 word min..

User Account

All Pages