Show a structured query language query

Assignment Help PL-SQL Programming

Reference no: EM13764375

1) After reading this weekâ€^TMs 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â€^TMs database development needs.Your paper must be two to three pages in length APA Style

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

Part A:

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 B:

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.

3) Using the Microsoft Access database you created in Step 2: 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 all of the 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.

Reference no: EM13764375

Questions Cloud

Firms marketing and pricing policies : Compute the elasticities for each variable. On this basis, discuss the relative impact that each variable has on the demand. What implications do these results have for the firm's marketing and pricing policies?

Main elements of data breach : Discuss the importance of breach notification for credit card information, as it relates to PCI-DSS.

Compare and contrast the foreign exchange market : The foreign exchange system contains the prices of currencies of other countries. These prices fluctuate based on demand and supply. Individuals buy and sell currency as they would any other commodity.

What factors might explain the differences in the rates : Utilize FBI Uniform Crime Report data and select one offense, such as burglary, in two metropolitan areas. What factors might explain the differences in the rates

Show a structured query language query : Show a Structured Query Language (SQL) query, and screenshot your results in a Microsoft Word document. For Part 2, provide explanations and screenshots documenting

Paper on a juveniles delinquency treatment program : Prepare a written analytical report (3-4) pages on a juveniles delinquency treatment program in your community or any community of your choice

Changes in planned expenditures affect aggregate demand : how do changes in planned expenditures affect the aggregate demand curve?

Fraud and risk factors and enterprise systems : Review the Fraud Risk Factors. Choose one (1) factor which you believe is the most important. Justify your response. Next, choose one (1) factor and determine two (2) policies that a company could put in place in order to counter the risk factor i..

Depreciation expense for purchase : What will the depreciation expense for this purchase (exclude all other plant and equipment) be after its second year of use? (Use FASB GAAP)

User Account

All Pages