DBM380 V14 Title ABC123 Vx Page 2 Of 2 Select And Update Dat ✓ Solved

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

• The customer incorrectly named “Dunne” is now named “Dipplehoffer”.
• All invoice dates reflect the year 2018. (Note: Date values are handled differently than numeric or string values; for help, refer to Microsoft® Access® documentation on date formats.)

After updating, select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables, 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, answer the following questions:

1. Database design: Briefly describe the business scenario this database was designed to model.
2. Entity-relationship diagram: 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”.
3. Normalization: Were the tables in this database normalized? How do you know?
4. Management: Data updates are destructive; what strategies or safeguards did you use to mitigate the unintentional destruction of data? For example, did you back up the database before updating, or select data prior to editing to create fall-back records?

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