Question

Pages File Edit Insert Format Data CSCI 4333 Assignment 8_ Data Import and DML(1) 2 - Edited 125% Zoom Insert Table Chart Text Shape Media Comment Collaborate Format Doc CSCI 4333 Assignment 8 | Spring 2017 Data Integrity and SQL DML Section 1. Data Integrity As we have observed in the class, the sisemp.csv data file, which contains the sales employee data for the organization has 988 records. When imported this data to Sales Reporting MySQL Database, we observed that only 939 records were inserted successfully. We observe the same issue with slstraux.csv file. This file contains 382 records, but only 379 records were inserted successfully. Please explain the reason(s) for these discrepancies. 584 words Note: We have imported the .csv file The source .csv files and DDL code to build this database is located on Blackboard at the SQL Comments ase study in 3/29/2017 class.

          Pages
File
Edit
Insert
Format
Data
CSCI 4333 Assignment 8_ Data Import and DML(1) 2 - Edited
125%
Zoom
Insert
Table
Chart
Text
Shape
Media
Comment
Collaborate
Format
Doc
CSCI 4333 Assignment 8 | Spring 2017
Data Integrity and SQL DML
Section 1. Data Integrity
As we have observed in the class, the sisemp.csv data file, which contains the sales
employee data for the organization has 988 records. When imported this data to
Sales Reporting MySQL Database, we observed that only 939 records were
inserted successfully. We observe the same issue with slstraux.csv file. This file
contains 382 records, but only 379 records were inserted successfully. Please
explain the reason(s) for these discrepancies.
584 words
Note: We have imported the .csv file
The source .csv files and DDL code to build this database is located on Blackboard at the
SQL Comments
ase study in 3/29/2017 class.

Pages
File
Edit
Insert
Format
Data
CSCI 4333 Assignment 8 Data Import and DML(1) 2 - Edited
125%
Zoom
Insert
Table
Chart
Text
Shape
Media
Comment
Collaborate
Format
Doc
CSCI 4333 Assignment 8 | Spring 2017
Data Integrity and SQL DML
Section 1. Data Integrity
As we have observed in the class, the sisemp.csv data file, which contains the sales
employee data for the organization has 988 records. When imported this data to
Sales Reporting MySQL Database, we observed that only 939 records were
inserted successfully. We observe the same issue with slstraux.csv file. This file
contains 382 records, but only 379 records were inserted successfully. Please
explain the reason(s) for these discrepancies.
584 words
Note: We have imported the .csv file
The source .csv files and DDL code to build this database is located on Blackboard at the
SQL Comments
ase study in 3/29/2017 class.

Added by Laura D.

Question

Please give Ace some feedback