[Solved] Company ABC -small database Assignment 2

$25

File Name: Company_ABC_-small_database_Assignment_2.zip
File Size: 376.8 KB

SKU: [Solved] Company ABC -small database Assignment 2 Category: Tag:
5/5 - (1 vote)

Your client, The ABC Company, asks you to create a small database to keep the information of employees, departments, projects and dependants.Refer the data tables in the page 2 and write answers or perform actions for following questions.1. Identify primary keys, foreign keys, NULL and other constraints exist with the tables. Document the identified constraints.2. Create all the tables with identified constraints on Oracle. (e.g. primary keys, foreign keys, NULLand other)3. Insert all the given values. You are feel free to insert new values to the tables.4. Write following queries on the tables.a. Print employees first name, last name, address and department number.b. Print employee full name and department and employees 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 the manager of the project. (department manager is the project manager)j. Identify and print information about employees who have children less than 15 years old.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, you will get zero for this query.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
[Solved] Company ABC -small database Assignment 2
$25