Populate your database with sample data and create views to support end-user use of the database for
Question:
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.
Generate (dump) an SQL script with your completed physical database, including data.
Customer (CustomerID PK, FirstName, LastName, Email, Phone, address1, address2, city, stateID (FK), zip)
Order (OrderID PK, OrderDate, CustomerID, ShippingID, EmployeeID)
Product (ProductID PK, ProductName, ProductDescription, CategoryID, Price, Quantity)
Payment (PaymentType, PaymentDate, Amount)
OrderPayment (OPID, OrderID (FK), PaymentID (FK), Amount, PaymentDate)
Category (CategoryID PK, CategoryName, CategoryDescription)
Employee (EmployeeID PK, FirstName, LastName, Email, Phone, Position, address1, address2, city, stateID (FK), zip)
ShippingOrder(SOID, ShippingID (FK), ShippingDate, TrackingNumber)
City(CityID (PK), CityName)
i need help with this assignment
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull