do not copy from Google .do it by your own and write clearly.

1. Considering Employee (Ed. Ename, age Salary, Department) as a relation, Write Sol, commands to (5) a) Delete the employce info of senior employees (older than 60 yrs) b) Update the salary of sales department, c) Alter table by adding an additional field, d) Create a view (with three attributes only) under some condition 3) Find the average nye of employees of manufacturing department 2. What do you mean by Logical and Physical data independence in DBMS 3. Discuss the following operators of Relational Algebra, with example (10) (a) Union (b) Conditional join (e) Cross product (d) projection (e) Rename What do you mean by key Constraints? take two relations Student(uid, shame, DOB, Department) and Fellowship Adm_No. Amount, Course) and discuss the use of following key constraints (10) (1) Candidate Key (in) Super Key (l) Primary key (iv) Foreign Key 5. Use Primary key Foreign key" "Not-Nulland 'checkclauses to create two relations Students (Sid. Sname, Age, City) and Enrolled (Ed. Adm.No, Department, Course) in SQL and write the following queries as directed (a) Find the Sid and Sname of those who are either younger than 25 yrs OR lives in Pune' (Relational Algebra) (b) Find all the enrolment details of students of Mathematics department, enrolled in course M.Tech. (Relational Algebra) (c) Create a view Science Students to get the Sid, Sname, Eld und Course details of the students of Physics, Chemistry and Mathematics department (SQL) (d) Update the city info from Kolkata to Dhanbad for the student with Eid: MS_17-18_03 (SOL) (e) Delete all the details of those who are either enrolled for M. Phil. Course of Mathematics department, or older than 35 yrs. (SQL) Show the use of all five aggregate functions in both SQL und Relational Algebra, by taking suitable relation(s) (15) MN (15) Ny 9 SUM