DBM380 V14 Titleabc123 Vx Page 2 Of 2 Select And Update Data

Dbm380 V14titleabc123 Vxpage 2 Of 2select And Update Data In Relatio

Begin with the populated Microsoft® Access® database you downloaded from the Cengage’s website. (If you have chosen not to use Microsoft® Access®, create and populate an identical database using the MySQL, Oracle®, or SQLServer statements provided.)

Select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables (using the appropriate SQL join keyword), ordering the results by invoice number. Take a screenshot of your results.

Name your screenshot: “DBM380Week4_YourLastNameYourFirstName_BEFORE.png”.

Update the database so that: a. The customer incorrectly named “Dunne” is named “Dipplehoffer.” b. All invoice dates reflect the year 2018. Note: Date values are handled differently than numeric (100) or string (‘Ralph’) values. For help with the date format in Microsoft® Access®, read “Create and run an update query” from Microsoft®.

Select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables (using the appropriate SQL join keyword), ordering the results by customer last name. Take a screenshot of your results.

Name your screenshot: “DBM380Week4_YourLastNameYourFirstName_After.png”.

In a Microsoft® Word document, type your answers to the following questions related to this assignment: a. Briefly describe the business scenario this database was designed to model. b. Describe at least two relationships implemented in the database that would have been modeled in the ERD, labeling each relationship as “primary key” or “foreign key.” c. Were the tables in this database normalized? How do you know? d. What strategies, or safeguards, did you use to mitigate unintentional destruction of data while completing this assignment? For example, did you select data prior to updating it to create a fall-back record? Did you back up the database before updating?

Prepare to turn in your assignment by zipping your two screenshots and the Microsoft® Word document into a single file named: “DBM380Week4_IndividualAssignment_YourLastNameYourFirstName.zip”.