K
Kizspy.me
-Your response must contain only necessary commands for answering the question. Do not include any
other command. For example, if you are required to create a trigger/procedure, then your response
should contain only commands for creating the corresponding trigger/procedure; all commands for
testing the created trigger/procedure are forbidden.
-On completion, import your work by b owsing to the above folder.
- Note that:
+ You could use only SQL Server, SQL Server Management Studio, and paper or offline
document in your computer.
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the .sql file which has the following
database diagram. Please, run the provided script to create tables and insert data into your database.
Zoom
customers
customer d
first name
orders
order d
customer_id
last name
phone
email
street
city
state
zip code
order status
order date
required date
shipped date
storeid
stores
stored
phone
+ 100%
order items
order d
od
productid
quantity
price
products
product
product name
category.id
discount
Close
