Aptech Computer Educationis a training institute located in Karachi, Pakistan. The institute provides training in various courses in field of Computer Science such as, CPISM,DSIM and so on. Recently, the institute started using a primitive database system in which it stores the student and staff details. In the current database, there is only one table to store the student details and another to store the staff details. However, the users are finding it very difficult to trace student and staff records since, all the details are in the same table. (Assumption: Database is already created.) You as a database developer have to accomplish the following tasks: 1. Create separate tables to store student details, marks details, employee details, salary details, and course details. 2. Create required columns in each table to store the relevant details. 3. Use appropriate data types for the columns to store the different type of data such as name, phone, email, salary, fees, and so on as per requirement. 4. Apply appropriate check constraints on the type of data to be stored in the respective columns. 5. Set the primary and foreign key constraints on appropriate columns to relate the relevant tables. 6. Insert new records in each table and verify that all the check constraints are working properly. 7. Update and delete records in the table to ensure primary and foreign key constraints are working properly. 8. Identify columns that may hold null value and apply constraints accordingly. A Study Help Dashboard - Solution x A Lab 07 G Lab 07.pdf - Google Drive A classroom.google.com/c/NjlxNTY2NzgxMTVa/m/NZQ3NDY5OTA2MDBA/details SP2020 DB Lab EM/CM LAB ASSIGNMENT Question No 01 1. Create the following tables and show their structures: Employees(employeelD, firstName, lastName, birthCity, hiringDate, deptID, joblD), Departments(deptID, deptName, locationID), Jobs(iobID, jobTitle, salary), Locations(locationID, city, country). Job IDs should have the format "ENG123" for an engineer, "MAN456" for a manager etc. 2. Ensure that all numerical IDs increment automatically. Show the relevant table structures. 3. Set the location field to hold the value "Islamabad, Pakistan" unless otherwise specified. Show the relevant table structures. 4. Insert least 6 relevant records in each table. Display all the data. 5. Ensure that employee names and department names are never empty. Show the relevant table structures. 6. Delete any location and ensure that all departments at that location are also deleted. Show all relevant queries, table structures, and data. Question No 02 Activate Windows Go to Settings to activate Windows. Aptech Computer Educationis a training institute located in Karachi, Pakistan. The institute provides training in various courses in field of Computer Science such as, CPISM,DSIM and so on. Recently, the institute started using a primitive database system in which it stores the student and staff details. In the current database, there is only one table to store the student details and another to store the staff details. 4:46 PM O Type here to search A O d) 4/10/2020