Question

Consider the following relational scherna:
Employee (Emp No, Ename, Age)
Project ( Prj No, Prj_name, Prj Leader no)
Alloted (Prj No, Emp No) Write appropriate DDL commands to create the above tables.
ii Retrieve employee names working on project with Prj No P1 or P2 (write appropriate
SQL query)
iii) Write appropriate SQL query to delete the column Age' from employee table.​

Answer 1

The Andromeda Galaxy (IPA: /ænˈdrɒmɪdə/), also known as Messier 31, M31, or NGC 224 and originally the Andromeda Nebula (see below), is a barred spiral galaxy approximately 2.5 million light-years (770 kiloparsecs) from Earth and the nearest major galaxy to the Milky Way.