DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables Let me do this assignment for you. The work I complete for you is guaranteed to be 100% original, plagiarism free, edited, APA formatted and just ready for you to add your name to it.DBM 380 WEEK 4 Select and Update Data in Related Tables 

DBM 380 WEEK 4 Select and Update Data in Related Tables

DO YOU NEED HELP WITH YOUR SCHOOL?

DO YOU NEED HELP WITH THIS ASSIGNMENT?

CONTACT ME TO TODAY

 TO TAKE CARE OF ALL YOUR ACADEMIC NEEDS

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables Running reports on existing data and updating data records are very common tasks in the industry.

For this assignment, you will begin with a database containing several pre-populated tables.

Download and unzip the Microsoft® Access® database (ZIP file) available on the Cengage’s website. (You may need to convert the database depending on the version of Microsoft® Access® you are using. To convert the database, follow Microsoft®‘s Convert a Database to the .accdb File Format instructions.)

Open the database in Microsoft® Access® and explore the tables it contains by following this path:

/folderYouNameWhenYouUnzip/1305627482_526407/Student/Ch07-Intro-to-SQL/Databases/Ch07_SaleCo.mdb

Note: If you have chosen not to use Microsoft® Access® in this course, you will need to download the SQL statements for MySQL, Oracle®, or SQLserver and run those statements against your RDBMS to create a populated database.

Download the Select and Update Data in Related Tables document and follow the instructions.

  1. 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.)
  2. 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.
  3. Take a screenshot of your results. Name your screenshot: “DBM380Week4_YourLastNameYourFirstName_BEFORE.png”
  4. Update the database so that:
    1. The customer incorrectly named “Dunne” is named “Dipplehoffer.”
    2. 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®.”
  5. 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.
  6. Take a screenshot of your results. Name your screenshot: “DBM380Week4_YourLastNameYourFirstNamepng”
  7. In a Microsoft® Word document, type your answers to the following questions related to this assignment:
    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. Be sure to label each relationship that you list appropriately (e.g., “primary key” or “foreign key”).
    3. Normalization. Were the tables in this database normalized? How do you know?
    4. Data updates are destructive; that is, they can alter existing data in a way that makes reconstituting the original data difficult or even impossible. What strategies, or safeguards, did you use to mitigate the unintentional destruction of data while you were 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 prior to updating it?
  8. Prepare to turn in your assignment by zipping your two screenshots and the Microsoft® Word document into a single file named: “DBM380Week4_IndividualAsssignment_YourLastNameYourFirstName.zip”

Your completed assignment will consist of one document and two screenshots placed in one document (one screenshot showing the results of the “before” SELECT statement and a second showing the results of the “after” SELECT statement). DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

The post DBM 380 WEEK 4 Select and Update Data in Related Tables appeared first on LindasHelp.

 

LET ME DO TAKE CARE OF YOUR SCHOOL WORK

DBM 380 WEEK 4 Select and Update Data in Related Tables  At https://lindashelp.com  I offer a unique and confidential service for students like you. Through my personalized and customized original service, I can write your papers, do your presentations, discussion questions, labs, and final exams too. My personalized services is guaranteed to be 100% original, confidential, plagiarism free, edited, APA formatted and just ready for you to add your name to it.  DBM 380 WEEK 4 Select and Update Data in Related Tables 

DBM 380 WEEK 4 Select and Update Data in Related Tables 

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables Running reports on existing data and updating data records are very common tasks in the industry.

For this assignment, you will begin with a database containing several pre-populated tables.

Download and unzip the Microsoft® Access® database (ZIP file) available on the Cengage’s website. (You may need to convert the database depending on the version of Microsoft® Access® you are using. To convert the database, follow Microsoft®‘s Convert a Database to the .accdb File Format instructions.)

Open the database in Microsoft® Access® and explore the tables it contains by following this path:

/folderYouNameWhenYouUnzip/1305627482_526407/Student/Ch07-Intro-to-SQL/Databases/Ch07_SaleCo.mdb

Note: If you have chosen not to use Microsoft® Access® in this course, you will need to download the SQL statements for MySQL, Oracle®, or SQLserver and run those statements against your RDBMS to create a populated database.

Download the Select and Update Data in Related Tables document and follow the instructions.

  1. 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.)
  2. 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.
  3. Take a screenshot of your results. Name your screenshot: “DBM380Week4_YourLastNameYourFirstName_BEFORE.png”
  4. Update the database so that:
    1. The customer incorrectly named “Dunne” is named “Dipplehoffer.”
    2. 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®.”
  5. 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.
  6. Take a screenshot of your results. Name your screenshot: “DBM380Week4_YourLastNameYourFirstNamepng”
  7. In a Microsoft® Word document, type your answers to the following questions related to this assignment:
    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. Be sure to label each relationship that you list appropriately (e.g., “primary key” or “foreign key”).
    3. Normalization. Were the tables in this database normalized? How do you know?
    4. Data updates are destructive; that is, they can alter existing data in a way that makes reconstituting the original data difficult or even impossible. What strategies, or safeguards, did you use to mitigate the unintentional destruction of data while you were 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 prior to updating it?
  8. Prepare to turn in your assignment by zipping your two screenshots and the Microsoft® Word document into a single file named: “DBM380Week4_IndividualAsssignment_YourLastNameYourFirstName.zip”

Your completed assignment will consist of one document and two screenshots placed in one document (one screenshot showing the results of the “before” SELECT statement and a second showing the results of the “after” SELECT statement). DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

DBM 380 WEEK 4 Select and Update Data in Related Tables

The post DBM 380 WEEK 4 Select and Update Data in Related Tables appeared first on LindasHelp.

readyy

OR

LINDA ORIGINAL

DBM 380 WEEK 4 Select and Update Data in Related Tables

Leave a Comment

Your email address will not be published. Required fields are marked *