Question

Employee (Eid,Ename,Estreet,Ecity)

Company (Cid,Cname,Ccity)

WorksOn (Eid,Cid,Salary,DateofJoining)

1. Write the all DDL commands for a given schema?

2. How to add MobNo attribute in employee table and remove the MobNo from

employee table?

3. Define a check integrity constraint on salary that value must be between 5000

to 50000.

4. Explain the concept of referential integrity constraint for given schema.​

Answer 1

Answer:

we do not any imformation