Need help for DATABASE OUTPUT IN ORACLE. The requirements for a company database

Question

Need help for DATABASE OUTPUT IN ORACLE.

The requirements for a company database and The company is organized into departments. Each department has a name, a number, that We of the start date when an employee who manages the department may have several locations employe started managing the department. d birth on security. salary, an based We store each technicians, engineers, or secretaries several Employees are classified into managers, may work on their functions. An employee is assigned to one department, but projects, which are not necessarily controlled by the same department. We keep track of works on each project. Each project is the number of hours per week that an supervisor of each employee located in a specific city. We also keep track of the direct benefits purposes We We want to keep of the dependents of each employee for track relationship to the employee keep dependent's name, s birth, date, and For any unspecified requirements, add your appropriate assumptions to make the Hint specifications complete. composite attribute, and multi-valued You may identify multi-value attributes. 1. 2. composite attributes. Answer the following queries: 1. List all the relations in the database for each table 2. List all the attributes and type definitions 3. List all the tuples in each table. and name, the number of 4. For each department, retrieve the department number employees, total average salary of the employees. works on 5. For each employee, list the projects the employee 6. For employee, list the projects the employee manages. 7. List the employees that each supervisor supervises 1. Using the types of entities found in a distribution environment (sales reps, customers, orders, parts, etc.), create an example of a relation that is in INF but not in 2NF and an

Explanation / Answer

1. The tuples in the company database are:

2. The attribute information for the tuples listed above are:-

3. The sample tuples for each table is shown below.

Employee:-

Department:-

Project:-

Works_On:-

Dependents:-

4. select Deptno,DName,count(Emp_ID),avg(sum(Salary)) from Employee,Department where Employee.Dept_no= Department.Deptno group by Deptno;

Emp_ID E_FName E_LName SSN Salary Address sex birth_date HireDate Dept_No 001 James Smith 123456 10000 Toronto M 12/02/1982 23/04/2008 10

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.