I need help with this assignment. I need to populate my database with sample data and create views to support end-user use of the database for forms and/or reports. Each table must have a minimum of three records of sample data. Each table must be represented somewhere within the completed views. Each view must include joins correctly linking the included tables and must show sample data when run. Generate (or dump) an SQL script with your completed physical database, including data. I need will populate your database with sample data and create views to support end-user use of the database for forms and/or reports. Each table must have a minimum of three records of sample data. Each table must be represented somewhere within the completed views. Each view must include joins correctly linking the included tables and must show sample data when run.

Here is my database, which I created. I already did PK, FK, and the design. I need help with this step.

CategoryID int Unchecked not null CategoryName varchar(255) null CategoryDescription varchar(255) null

CityID int Unchecked CityName varchar(255) Checked

CustomerID int Unchecked FirstName varchar(255) Checked LastName varchar(255) Checked Email varchar(255) Checked Phone varchar(20) Checked Address varchar(255) Checked CityID int Unchecked SateID int Unchecked Zip varchar(5) Checked

EmployeeID int Unchecked FirstName varchar(255) Checked LastName varchar(255) Checked Email varchar(255) Checked Phone varchar(20) Checked Position varchar(255) Checked Address varchar(255) Checked CityID int Unchecked StateID int Unchecked Zip varchar(15) Checked

OrderID int Unchecked OrderDate date Checked CustomerID int Unchecked ShippingID int Unchecked ProductID int Unchecked EmployeeID int Unchecked

OPID int Unchecked OrderID int Unchecked

PaymentID int Unchecked Amount decimal(18, 0) Checked Payment date Checked PaymentID int Unchecked PaymentDate date Checked Amount decimal(18, 0) Checked

ProductID int Unchecked ProductName varchar(255) Checked ProductDiscription varchar(255) Checked

CategoryID int Unchecked Price decimal(18, 0) Checked Quantity int Unchecked

ShippingID int Unchecked ShippingName varchar(255) Checked Phone varchar(20) Checked

SOID int Unchecked ShippingID int Unchecked ShippingDate date Checked TrackingNumber varchar(255) Checked

StateID int Unchecked StateName varchar(255) Checked