Database Concepts 8th Edition

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix A Getting Started with Microsoft SQL Server 2016 1) To start working with SQL Server 2016 in Windows 10, use the command Start | All Apps

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix B Getting Started with Oracle Database XE 1) Oracle Database XE uses Application Express to create new workspaces. Answer: TRUE Diff: 1 Page Ref: B-16 AACSB:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix C Getting Started with MySQL 5.7 Community Server 1) Users log into MySQL Workbench using the Connect to MySQL Server dialog box. Answer: TRUE Diff: 1

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix E Advanced SQL 1) Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS. Answer: TRUE Diff: 2 Page Ref: E-54 AACSB: Information

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 55) The SQL command SELECT is used to retrieve data from view instances. Answer: TRUE Diff: 1 Page Ref: E-35 AACSB: Information Technology Chapter Obj: To use SQL statements to create

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix F Getting Started with Systems Analysis and Design 1) There is no set format for a statement of work (SOW). Answer: TRUE Diff: 1 Page Ref:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix G Getting Started with Microsoft Visio 2016 1) Microsoft Visio 2016 is a component of Microsoft Office 2016. Answer: TRUE Diff: 1 Page Ref: G-3 AACSB:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix H The Access WorkbenchSection HMicrosoft Access 2016 Switchboards 1) A Microsoft Access 2016 switchboard provides networking capabilities in Microsoft Access 2016. Answer: FALSE Diff: 1 Page

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix I Getting Started with Web Servers, PHP, and the NetBeans IDE 1) The default WPI 5.0 installation provides full support for both the standard ODBC and

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix J Business Intelligence Systems 1) Business Intelligence (BI) systems are information systems that help users analyze and use data. Answer: TRUE Diff: 1 Page Ref: J-4

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 49) Market basket analysis as described in the text uses the technique of conditional probabilities. Answer: TRUE Diff: 3 Page Ref: J-15 AACSB: Information Technology Chapter Obj: Learn the basic concepts of

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix K Big Data 1) ________ is a set of approaches for taking portions of a database and moving them to a different server in a cluster.

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 1 Getting Started 1) Regarding Big Data, what does the term NoSQL really mean? A) No SQL used B) NortonOS Query Language C) Notational Query Language

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 2 The Relational Model 1) A key must be unique. Answer: FALSE Diff: 1 Page Ref: 74 AACSB: Information Technology Chapter Obj: Learn basic relational terminology

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 3 Structured Query Language 1) The result for SELECT statements in SQL is a relation unless the result is a single number. Answer: FALSE Diff: 1

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 49) Microsoft Access SQL commands are run within the SQL View of a Query window. Answer: TRUE Diff: 1 Page Ref: 204 AACSB: Information Technology Chapter Obj: Learn basic SQL statements

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 5 Database Design 1) The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality. Answer: FALSE Diff: 1 Page Ref:

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 35) To create a 1:1 relationship between two tables in Microsoft Access, the Indexed property of the foreign key column must be set to ________. Answer: Yes (No Duplicates) Diff: 3

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 6 Database Administration 1) Additional DBA responsibilities do not include ________. A) problem and error reporting B) requests of changes to existing systems C) controlling database

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 7 Database Processing Applications 1) When using Microsoft Access and IIS, the Web pages that access the database cannot be written using PHP. Answer: FALSE Diff:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 8 Data Warehouses, Business Intelligence Systems, and Big Data 1) NoSQL really stands for "Not only SQL." Answer: TRUE Diff: 1 Page Ref: 511 AACSB: Information

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 48) A data mart differs from a data warehouse in these ways except ________. A) it has a smaller database B) it deals with a particular component or functional area of the

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 4 Data Modeling and the Entity-Relationship Model 1) One or more entities can be associated together in relationships. Answer: TRUE Diff: 2 Page Ref: 267 AACSB:

Appendix A - Getting Started with Microsoft SQL Server 2016 2018 Pearson Education, Inc. Page 18 of 33 2018 Pearson Education, Inc. Page 18 of 33 2018 Pearson Education, Inc. Page 18 of 33 10. Click the Next button to display the Save and Run

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Appendix A Getting Started with Microsoft SQL Server 2016 2018 Pearson Education, Inc. Page 2 of 33 2018 Pearson Education,

Appendix B - Getting Started with Oracle Database XE 2018 Pearson Education, Inc. Page 14 of 26 2018 Pearson Education, Inc. Page 14 of 26 2018 Pearson Education, Inc. Page 14 of 26 We will first import the table then create foreign keys in the

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Scott L. Vandenberg Appendix B Getting Started with Oracle Database XE 2018 Pearson Education, Inc. Page 2 of 26 2018 Pearson Education, Inc.

Appendix C Getting Started with MySQL 5.7 Community Server Edition 2018 Pearson Education, Inc. Page 14 of 25 IMPORTANT: If you are using the Microsoft Windows operating system, download and use the MySQL Installer for Windows! Do not download separate MySQL components for the Windows OS. The

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Robert C. Yoder and David J. Auer Appendix C Getting Started with MySQL 5.7 Community Server 2018 Pearson Education, Inc. Page 2 of 25

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Appendix D James River Jewelry Project Questions 2018 Pearson Education, Inc. Page 2 of 3 2018 Pearson Education, Inc. Page

Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 61 of 107 2018 Pearson Education, Inc. Page 61 of 107 2018 Pearson Education, Inc. Page 61 of 107 ALTER TABLE EMPLOYEE ADD Supervisor Int NULL; ALTER TABLE EMPLOYEE ADD CONSTRAINT EMP_EMP_FK FOREIGN KEY

Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 21 of 107 2018 Pearson Education, Inc. Page 21 of 107 2018 Pearson Education, Inc. Page 21 of 107 For Microsoft Access: SELECT * FROM viewPetCount ORDER BY PetType; For SQL Server, Oracle Database, and MySQL:

Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 95 of 107 2018 Pearson Education, Inc. Page 95 of 107 2018 Pearson Education, Inc. Page 95 of 107 D. How did your steps to add the Training column differ from your steps to add

Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 41 of 107 2018 Pearson Education, Inc. Page 41 of 107 2018 Pearson Education, Inc. Page 41 of 107 NOTE: We are not implementing the UNIQUE constraint; its no longer part of the question. /*** Add

Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 81 of 107 2018 Pearson Education, Inc. Page 81 of 107 2018 Pearson Education, Inc. Page 81 of 107 SELECT C.FirstName AS CustomerFirstName, C.LastName AS CustomerLastName, R.FirstName AS ReferrerFirstName, R.LastName AS ReferrerLastName FROM CUSTOMER C

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Scott L. Vandenberg Online Appendix E Advanced SQL 2018 Pearson Education, Inc. Page 2 of 107 2018 Pearson Education, Inc. Page 2 of

Page 1 of 10 Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Robert C. Yoder APPENDIX F Getting Started in Systems Analysis and Design Page 2 of 10 Page 2 of 10 Page 2 of

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Appendix G Getting Started with Visio 2016 2018 Pearson Education, Inc. Page 2 of 13 2018 Pearson Education, Inc. Page

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Appendix H The Access Workbench Section H Microsoft Access 2016 Switchboards 2018 Pearson Education, Inc. Page 2 of 3 2018

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Appendix I Getting Started with Web Servers, PHP, and the NetBeans IDE 2018 Pearson Education, Inc. Page 2 of 12

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Scott L. Vandenberg Appendix J Business Intelligence Systems 2018 Pearson Education, Inc. Page 2 of 19 2018 Pearson Education, Inc. Page 2 of

Page 1 of 16 Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Robert C. Yoder APPENDIX K BIG DATA Page 2 of 16 All rights reserved. No part of this publication may be reproduced, stored

All Sections The Access Workbench 2018 Pearson Education, Inc. Page 61 of 102 2018 Pearson Education, Inc. Page 61 of 102 2018 Pearson Education, Inc. Page 61 of 102 C. Create a form that allows users to view and edit project data. The form should

All Sections The Access Workbench 2018 Pearson Education, Inc. Page 41 of 102 2018 Pearson Education, Inc. Page 41 of 102 2018 Pearson Education, Inc. Page 41 of 102 CREATE TABLE COMPUTER_ASSIGNMENT( SerialNumber Int NOT NULL, EmployeeNumber Int NOT NULL, DateAssigned Date

All Sections The Access Workbench 2018 Pearson Education, Inc. Page 92 of 102 2018 Pearson Education, Inc. Page 92 of 102 2018 Pearson Education, Inc. Page 92 of 102 SECTION EIGHT CHAPTER OBJECTIVES Learn how to create an OLAP report for Microsoft

All Sections The Access Workbench 2018 Pearson Education, Inc. Page 21 of 102 2018 Pearson Education, Inc. Page 21 of 102 2018 Pearson Education, Inc. Page 21 of 102 SECTION THREE CHAPTER OBJECTIVES Learn how to use Microsoft Access SQL Learn

All Sections The Access Workbench 2018 Pearson Education, Inc. Page 81 of 102 2018 Pearson Education, Inc. Page 81 of 102 2018 Pearson Education, Inc. Page 81 of 102 // Table data while($RecordSetRow = odbc_fetch_array($RecordSet)) { echo "<tr>"; echo "<td>" . $RecordSetRow['NickName']

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer All Sections including Appendix E and Appendix H The Access Workbench 2018 Pearson Education, Inc. Page 2 of 102 2018

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Chapter One Getting Started 2018 Pearson Education, Inc. Page 2 of 25 All rights reserved. No part of this publication may

Chapter One Getting Started 2018 Pearson Education, Inc. Page 14 of 25 Online transaction data is stored in an online transaction processing (OLTP) database. Companies build data warehouse to store data needed for data analysis in a business intelligence (BI) system, which includes tools such as online

2018 Pearson Education, Inc. Page 1 of 38 2018 Pearson Education, Inc. Page 1 of 38 2018 Pearson Education, Inc. Page 1 of 38 Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by

Chapter Two The Relational Model Page 20 of 38 D. Based on your answer to part C, show the data changes necessary to add a second major for the second student. StudentNumber StudentName SiblingName Major 100 Mary Jones Victoria Accounting 100 Mary Jones Slim Accounting 100 Mary Jones

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Scott L. Vandenberg Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 2 of 154 2018 Pearson Education, Inc. Page 2 of

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 121 of 154 2018 Pearson Education, Inc. Page 121 of 154 2018 Pearson Education, Inc. Page 121 of 154 J. Answer part I but use a join using JOIN ON syntax. For SQL Server,

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 41 of 154 2018 Pearson Education, Inc. Page 41 of 154 2018 Pearson Education, Inc. Page 41 of 154 CREATE TABLE ENROLLMENT( CustomerNumber Int NOT NULL, CourseNumber Int NOT NULL, AmountPaid Number(8,2)

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 61 of 154 C. Figure 3-34 shows the column characteristics for WP COMPUTER_ASSIGNMENT table. Using the column characteristics, use Access SQL to create the COMPUTER_ASSIGNMENT table and the associated constraints in the WP.accdb database. Are there

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 138 of 154 2018 Pearson Education, Inc. Page 138 of 154 2018 Pearson Education, Inc. Page 138 of 154 INSERT INTO VENDOR VALUES( 'New York Brokerage', 'Smith', 'Mark', '621 Roy Street', 'Seattle', 'WA',

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 21 of 154 2018 Pearson Education, Inc. Page 21 of 154 2018 Pearson Education, Inc. Page 21 of 154 Note that there are no results; that is the correct response. 3.23 Write an

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 101 of 154 2018 Pearson Education, Inc. Page 101 of 154 2018 Pearson Education, Inc. Page 101 of 154 SELECT * FROM OWNED_PROPERTY; SELECT * FROM PROPERTY_SERVICE; E. Write an SQL statement

Chapter Three Structured Query Language 2018 Pearson Education, Inc. Page 81 of 154 2018 Pearson Education, Inc. Page 81 of 154 2018 Pearson Education, Inc. Page 81 of 154 G. Write an SQL statement to list the INVOICE.InvoiceNumber for sales that include the Heather

Page 1 of 52 Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Robert C. Yoder and David J. Auer CHAPTER FOUR DATA MODELING AND THE ENTITY-RELATIONSHIP MODEL Page 2 of 52 Page 2

Chapter Four Data Modeling and the Entity-Relationship Model Page 21 of 52 4.30 Extend your work for question 4.29 to include supplies that Heather uses on a project. Assume that she wants to track the description, price, and amount used of each supply. Supplies are used on multiple

Chapter Four Data Modeling and the Entity-Relationship Model Page 37 of 52 Chapter Four Data Modeling and the Entity-Relationship Model Page 38 of 52 C. Describe how you would go about validating the model in part B. This model assumes single owners of

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Chapter 5 Database Design 2018 Pearson Education, Inc. Page 2 of 66 2018 Pearson Education, Inc. Page 2 of 66

Chapter Five Database Design 2018 Pearson Education, Inc. Page 41 of 66 2018 Pearson Education, Inc. Page 41 of 66 2018 Pearson Education, Inc. Page 41 of 66 ANSWERS TO GARDEN GLORY PROJECT QUESTIONS Convert the data model you constructed for Garden Glory in

Chapter Five Database Design 2018 Pearson Education, Inc. Page 54 of 66 2018 Pearson Education, Inc. Page 54 of 66 2018 Pearson Education, Inc. Page 54 of 66 Chapter Five Database Design 2018 Pearson Education, Inc. Page 55 of 66

Chapter Five Database Design 2018 Pearson Education, Inc. Page 21 of 66 2018 Pearson Education, Inc. Page 21 of 66 2018 Pearson Education, Inc. Page 21 of 66 N:M Recursive; If agents in the community where PNWREA is located want to acquire property themselves, they

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Scott L. Vandenberg Chapter Six Database Administration 2018 Pearson Education, Inc. Page 2 of 36 2018 Pearson Education, Inc. Page 2 of 36

Chapter Six Database Administration 2018 Pearson Education, Inc. Page 19 of 36 2018 Pearson Education, Inc. Page 19 of 36 2018 Pearson Education, Inc. Page 19 of 36 E. Summarize the recovery capabilities of Oracle Database XE. See the answer to Question D above. 6.52

Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by David J. Auer Chapter 7 Database Processing Applications 2018 Pearson Education, Inc. Page 2 of 100 2018 Pearson Education, Inc. Page 2 of

Chapter Seven Database Processing Applications 2018 Pearson Education, Inc. Page 61 of 100 2018 Pearson Education, Inc. Page 61 of 100 2018 Pearson Education, Inc. Page 61 of 100 E. Code a Web page using PHP to display the data in OWNED_PROPERTY. Add a hyperlink

Chapter Seven Database Processing Applications 2018 Pearson Education, Inc. Page 21 of 100 2018 Pearson Education, Inc. Page 21 of 100 2018 Pearson Education, Inc. Page 21 of 100 !DOCTYPE> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>ReadCustomer PHP Page</title> <style type="text/css"> h1 {text-align: center;

Chapter Seven Database Processing Applications 2018 Pearson Education, Inc. Page 81 of 100 2018 Pearson Education, Inc. Page 81 of 100 2018 Pearson Education, Inc. Page 81 of 100 NewCustomerForm.html HTML Code: <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>NewCustomerForm HTML Page</title>

Chapter Seven Database Processing Applications 2018 Pearson Education, Inc. Page 41 of 100 2018 Pearson Education, Inc. Page 41 of 100 2018 Pearson Education, Inc. Page 41 of 100 Web Page code: <!DOCTYPE html> <html> <head> <title>Marcia's Dry Cleaning Demonstration Pages Home

Page 1 of 62 Database Concepts 8th Edition David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder Instructors Manual Prepared by Robert C. Yoder and David J. Auer CHAPTER EIGHT BIG DATA, DATA WAREHOUSES, AND BUSINESS INTELLIGENCE SYSTEMS Page 2 of 62

Chapter Eight Big Data, Data Warehouses and Business Intelligence Systems Page 41 of 62 ANSWERS TO GARDEN GLORY PROJECT QUESTIONS If you have not already implemented the Garden Glory database shown in Chapter 3 in a DBMS product, create and populate the GARDEN_GLORY database now in the

Chapter Eight Big Data, Data Warehouses and Business Intelligence Systems Page 21 of 62 Page 21 of 62 Page 21 of 62 See the file: DBC-e08-MSSQL-HSD-DW-Create-SALES_FOR_RFM.sql. F. What transformations of data are necessary to load the SALES_FOR_RFM table? List any needed transformations, showing the original format of the

Chapter Eight Big Data, Data Warehouses and Business Intelligence Systems Page 52 of 62 D. What transformations of data will need to be made before the JRJ-DW database can be loaded with data? List all the transformations, showing the original format of the JAMES_RIVER_JEWELRY data and how it appears