Hello.  Can you see if you could do this for me?  It is the "CSC316Module 4-Case Assignment Instruction."  The other attachment "Normalization of Data Module 3" was the last assignment done.

 

MUST BE ORIGINAL WORK, NOT COPIED FROM OTHER WORK.

School is using Turintin to check work that are copied from other sources. Thank you.

 

MUST BE ORIGINAL WORK, NOT COPIED FROM OTHER WORK.School is using Turintin to check work that are copied from other sources. Thank you.Module 4 - CaseRELATIONAL ALGEBRA AND SQL DML STATEMENTSAssignment OverviewDeveloping a Database System: Populate the TablesIn the Case Assignment of this module, you will write SQL statements toquery and modify the PC Store database. You will insert initial data into thedatabase, update the database when necessary, and query the databaseto produce various reports required by the store owners.Case AssignmentUse SQL command to:1.Create related tables to capture sales data and sales transactions.2.Populate all tables with the related data.3.Update the database when new products arrive.4.Update the database when a sale is made.5.Describe (in at least a half page) the major points you learned in the readings(especially on SQL) and what lessons you have learned in this exercise.6.Include an explanation of all that you did in this assignment (2-3 pages).Assignment Expectations1.Successfully use SQL for data manipulation, mainly insertion, and update.2.Communicate effectively with your audience.

Running head:Normalization of Data `1Normalization and its importanceNormalization is a procedure of arranging the information in the database to maintaina strategic distance from data access, insertion abnormality, upgrade peculiarity andcancellation inconsistency.Normalization is critical for DBMS since it is a procedure ofbreaking down the given link outlines in light of their “Functional Dependencies” (FDs) andessential core to accomplishing the properties minimizing excess, reducing insertion,cancellation and upgrade irregularities. It highlights requirements and reliance on theinformation and henceforth helps the comprehension the way of the information.Normalization controls data access to decrease stockpiling prerequisite and standard upkeep.It gives one of a kind recognizable proof to records in a database[Rob992].Normalization of Sales Order DatabaseDirectories Normalization shall provide as a an authentic way of taking care of thegiven information in the repository. It is an accurate methodology of simplifying tables toobtain information repetition and undesirable qualities like Insertion, Update, and DeletionAnomalies. It really is a multi-step prepare that places information in to the even platform byexpelling copied information from the partnership desks. For the given set of tables fromModule 2 database schema design, all the tables are already in 3rdnormalized form.For the data to be in 1stNormalized form, no two rows of data in the tables mustcontain any repeating group of information. Each set of columns must have their own uniquevalues. This is important so that multiple columns do not become the candidate to fetch thesame record from a table or a group of tables. For the tables Employee, Customer, Product,SaleOrder, SalesOrderDetail, the data has been organized into rows and each table is having