Database Administration

CSCI $342$

Lab Project Lab $1$

Q$1.$ Create a database with the following Design Specifications

Database Name: Company$\_$DENORMALIZED

Q$2.$ Create a table in the same database you created above with the following design specifications.

Table Name: SalesOrder

$\backslash$table$[[$Column Name,SalesOrderNo,Date,CustomerNo,CustomerName,CustomerAdd,ClearkNo,ItemNo,Description,Qty$,$UnitPrice$],[$Data Type,INT,DATE,INT,VARCHAR$(30),$VARCHAR$(100),$INT,INT,TEXT,INT,Money$],[$Null Constraint,NOT NULL,NULL,NOT NULL,NULL,NULL,NULL,$\backslash$table$[[$NOT$],[$NOT NULL$]],$NULL,NULL,NULL$]]$

Q$3.$ Load the following data into the table created above $($use INSERT Statement$)$

$\backslash$table$[[$SalesOrderNo$,$Date,CustomerNo,CustomerName,CustomerAdd,ClearkNo,ItemNo,Description,Qty$,$UnitPrice$],[43661,\frac{7}{1}\frac{?}{2005},13531,$Jon,MD$,21542,712,$Fruit,$4,5\mathrm{.}1865],[43661,\frac{7}{1}\frac{?}{2005},13531,$Jon,MD$,21542,743,$Liquor,$2,714\mathrm{.}7043],[43661,\frac{7}{1}\frac{?}{2005},13531,$Jon,MD$,21542,747,$Vegetable,$1,714\mathrm{.}7043],[43662,\frac{7}{2}\frac{?}{2005},11358,$Christy,VA$,2654,712,$Fruit,$10,5\mathrm{.}1865],[43662,\frac{7}{2}\frac{?}{2005},11358,$Christy,VA$,2654,715,$Bakery,$3,28\mathrm{.}8404],[43662,\frac{7}{2}\frac{?}{2005},11358,$Christy,VA$,2654,742,$Electronics,$1,722\mathrm{.}5949],[43663,\frac{7}{2}\frac{?}{2005},6229,$Janet,DC$,21145,775,$Electronics,$7,2024\mathrm{.}994],[43663,\frac{7}{2}\frac{?}{2005},6229,$Janet,DC$,21113,778,$Electronics,$1,2024\mathrm{.}994],[43663,\frac{7}{2}\frac{?}{2005},6229,$Janet,DC$,21113,712,$Fruit,$1,5\mathrm{.}1865],[43663,\frac{7}{2}\frac{?}{2005},6229,$Janet,DC$,21113,741,$Furniture,$2,818\mathrm{.}7],[43664,\frac{7}{2}\frac{?}{2005},6377,$Jacquelyn,MD$,2978,776,$Furniture,$2,2024\mathrm{.}994]]$

Q$4.$ Retrieve the SalesOrderNo, CustomerName, Description, and Qty for all sales

Q$5.$ Retrieve the SalesOrderNo, CustomerName, Description, and Qty for CustomerNo $6229$

$($Use the WHERE Clause to filter CustomerNo $6229)$