1 Identify Primary Keys Foreign Keys Null And Other Constraints Exist With The Table 2763251

1. Identify primary keys, foreign keys, NULL and other constraints exist with the tables. Documentthe identified constraints.Table 1. Identified Primary Key, Foreign key, Not null ConstraintsTable Name Primary Key Foreign Key ( referencestable A)Nott Nullcolumns2. Create all the tables with identified constraints on Oracle. (e.g. primary keys, foreign keys, NULLand other)NOTE: When you create tables you should decide the appropriate types for the attributes. Andalso you should add the screenshots of CREATE TABLE statements in the project Report3. Insert all the given values. You are feel free to insert new values to the tables.NOTE: You should add all INSERT INTO statements and screenshots in the project report.4. Write following queries on the tables.a. Print employee’s first name, last name, address and department number.b. Print employee full name and department and employee’s supervisors full name.c. Print employee information who works for project 3. (i.e. ProductZ).d. Print the employee and the number of dependant for an employee.e. Print information about employees working more than one project.f. Find the manager who earns the highest salary.g. Print for all the employees number of hours in total they have worked in the projects.h. Print project information of the projects which are managed by department 5 (i.e.research).i. Print the total number of projects controlled by the different departments and themanager of the project. (department manager is the project manager)j. Identify and print information about employees who have children less than 15 yearsold.k. Print details of mangers who have worked more than 20 years of the companyl. Create your own query. It must include a nested query. Submit the following:i. question your query is answeringii. the SQL queryiii. the mark for this question will depend on the complexity of the query.iv. higher marks will be given for queries that are more complex and/or innovative.v. if you do not provide a description of what question the query is answering, youwill get zero for this query.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"