Relational Database Design and SQL

Using Microsoft SQL Server, write the SQL statements for each question necessary to generate the required result set.

Answer the following three questions

Entity Relationship Diagram Orders PK OrderlD PK,FK2 Productio CompanyName ContactTitle City FK1 CustomerlD FK2 EmployeelD UnitPrice Quantity Discount -has--H ShipAddress ShipPostalCode Country Phone has FK3 ShipperiD RequiredDate Freight FK1 SuppierlD PK EmployeelD LastName FirstName MiddleName EnglishName UnitPrice City UnitsOnOrder ReorderLevel Discontinued PK ShippertlD Phone BirthDate CompanyName has PK SupplierlD Name City