xercise 1. Create a data base (company) 2. Create two tables in the database: 3. employee no e name Salary phone d no an 1456 Ahmad 4000 0555558888 1 de 1457 Khaled „le 4500 0555553333 1458 Ahmad 3000...

IN SQL

1-Create a data base (company)
2-Create two tables in the database

3. Retrieve e_name ,d_no from Employee and d_name from department by Inner ,left and right join?

Extracted text: xercise 1. Create a data base (company) 2. Create two tables in the database: 3. employee no e name Salary phone d no an 1456 Ahmad 4000 0555558888 1 de 1457 Khaled „le 4500 0555553333 1458 Ahmad 3000 0555554444 3 1459 Mohamed 6000 0555555777 1460 Noor 5000 0555553334 1461 Waleed 7000 0555553222 NULL d no d name manager no CS 1457 2 IS 1459 3 SE 1444 NT 1433 SS 1411 Note: d no in Department is primary key. 4) EN 12 s米 f4 IOI fs