build a data base on sql

2. Create three tables as given below EMPLOYEE Empld, EFname, ELname, Gender, Designation, Manager, Salary, Commission DEPARTMENT DeptNo, DeptName D_LOCATION CityId, CityName 3. In table Employee Change through script Name of the attribute 'Designation with new name Design 4. Add foreign keys: DepNo in Employee table AND Cityld in Department table 5. Make a relationship diagram and get its screen shot of the diagram pan on a word document 6. Insert at least Five Valid records in each of the three tables. These records must have to satisfy needs of the below given queries. 7. Write an SQL statement/command to display from the Employee table EmpId and Full Name of each employee 8. Write an SQL statement command which if executed would change the department number of all employees working in the dept#30 (software) to dept#10 (sales). 9. Write an SQL statement command which shows from the Employee table, the records of all employees whose name starts with the character 'S'. 10. Develop a query fetching data from two tables