Kizspy.me
must contain only 10 files Q1.sql, Q2.sql, Q3.sql, Q4.sql, Q5.sql, Q6.sql, Q7.sql, Q8.sql, Q9.sql and
Q10.sql.
-Do not use any commands having the database name such as create database, alter database,
use [database name], etc.
-Your response must contain only necessary commands for answering the question. Do not
include any other command( GO, EXEC, USE,...). 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 browsing to the above folder.
- Note that:
+ You could use only SQL Server, SQL Server Management Studio, window explorer,
winzip.
+ 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
+ 100%
Close
