Distributed database:
Assignment No 1:
Your assignment must be a /handwriten and copy paste assignment must be
consider 0 marks:
Take any table, convert it to sql and normalize it, remove redundancy and
convert it in algebraic form.
1. %what is all DDL commands from the DDL.sql file in the sql
2. %Run all DML commands from the small Relations Insert File.sql file in the
sql terminal
a)consider the following query. Find the name of employee who have been
working on a project p1 for 12 month to 24 month.
b) Write an SQL query to fetch the different projects available from the
Employee Salary table.
c) Delete all courses that have never been offered (that is, do not occur in the
section relation).delete from course
d)Write an SQL query to find the maximum, minimum, and average salary of
the employees
e) Write an SQL query to find the employee id whose salary lies in the range
of 9000 and 15000.
f)%Write an SQL query to fetch common records between two tables.
g) Write an SQL query to fetch the employee’s full names and replace the
space with ‘-’
h) Write an SQL query to fetch the Employs ds that are present in Employee
Details but not in Employee Salary.
i) find the name of employee other than j. Doe who worked on the
CAD/CAMI project for either 1 0r 2 years
deadline
Your assignment must be /submitted at 14/4/2023 12.00am
