Create a folder named RollNo_Name_DB1202_PaperNo,se01245_LongNT_DB1202_01. All file created will be located in the above folder.e.g.
For each question, you are required to write a database script. Create a file with the name corresponding to the index of the question. For example, for question 1, we will create a file named Q1.sql and create a file Q2.sql for question 2. These files contain only the required workflow commands that do not include other commands including the database context switch (not including use [database name]).
- On completion, import your work by browsing to the above folder.
From the 2nd question, you should use the database provided in the DBscript.sql file which has the following database diagram. Please, run the provided script to create tables and insert data into your database.
Customer
OrderDetails
OrderiD
ProductiD
SalePrice
Quantity
Discount
Profit
CustomerName
Segment
Country
City
State
Postal Code
Region
SubCategory
70
SubCategoryName
Category D
Zoom
+ 100%
Close
