Consider the following business scenario: An employee can work on many projects, while each project can...
Consider the following business scenario: An employee can work on many projects, while each project can involve many employees. What is the minimum number of tables that would be necessary in order to implement this scenario in a relational database?
Select one:
a. 1
b. 2
c. 3
d. 4
Homework Answers
answer) c.3
For every entity we need to create one relation .Here Employee and Project are two entities.so we need two table to represent
employee and project.
: An employee can work on many projects, while each project can involve many employees is a many to many relationship.
we need to create table for many to many relationship.so total 3 tables are required.
Add Answer to:
Consider the following business scenario: An employee can work
on many projects, while each project can...
Projects Case Study A construction company requires a database to record details about building projects. Each...
Projects Case Study A construction company requires a database to record details about building projects. Each project has its own project number, name and employees assigned to it. Each employee has an employee number, name and job classification, such as engineer or computer technician. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent upon the employee's position. For example, one hour of a computer technician's time is billed at a...
Consider the following relational schemas: Employee (eid: integer, ename: string, Job_title: string, Years_of_experience: integer) Project (pid:...
Consider the following relational schemas: Employee (eid: integer, ename: string, Job_title: string, Years_of_experience: integer) Project (pid: integer, pname: string, parea: string, mid: integer, budget: integer) Works_on (eid: integer, pid: integer) Manger (mid: integer, mname: string, deptid: integer) The meaning of these relations is straightforward; for example, Works_on has one record per Employee-Project pair such that the Employee Works_on the Project. 1. Write the SQL statements required to create these relations, including appropriate versions of all primary and foreign key integrity...
Consider the relational database schema for a company below. EMPLOYEE/NAME, SSN, BDATE, ADDRESS, SEX, SALARY, SUPERSSN,...
Consider the relational database schema for a company below. EMPLOYEE/NAME, SSN, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNA) TA DEPARTMENT(DNAME, DNUMBER. MESSINS, MGRSTARTDATE) DEPT_LOCATIONS(DNUMBER. DLOCATION PROJECT(PNAME, PNUMBER. PLOCATION, DNLIM) WORKS_ONCESSN.PNG, HOURS) DEPENDENTESSN, DEPENDENT-NAME, SEX, BDATE, RELATIONSHIP) Write SQL statements for the following queries: a) List the names of those employees who work in the "Production" department (6 marks). b) Find the maximum salary, minimum salary, and the average salary among employees who work for the "Production department (6 marks). Count the...
Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn,...
Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn, dnumber) Department (dname, dnumber, mgrssn, mngrstartdate) Project (pname, pnumber, plocation, dnumber) Works_On (ssn, pnumber, hours_per_week) Dependent (ssn, dependent name, bdate, relationship) The above relations store information about a company. The meaning of most of the relations and attributes is straightforward. For example, the first relation stores information about employees. The mgrssn is the SSN of the manager (supervisor) of the given employee. A manager...
10. For each employee in the department with code ACCNT, find the employee ID and number...
10. For each employee in the department with code
ACCNT, find the employee ID and number of assigned hours that the
employee is currently working on projects for other departments.
Only report an employee if she has some current project to which
she is assigned more than 50% of the time and the project is for
another department. Report the results in ascending order by
hours.
11. Find all departments where all of their employees
are assigned to all of...
Part I (60 Pts.). Please answer questions (a) and (b) using the following tables held in...
Part I (60 Pts.). Please answer questions (a) and (b) using the following tables held in a Relational Database Management Systems. Employee (eupllName Wane, address, DOB, sex, position, deptNo Department (deptNe, deptNane mgrEupID Project where Employeecontains employee details and empll is the key Department contains department details and deptNe is the key mgrEplD identifies the employee who is the manager of the department. There is only one manager for each department. contains details of the projects in each department and...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department,...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department, ProjectName) EMPLOYEES(Number, Surname, FirstName, Department) ALLOCATIONSEmplovee, Project, Function, Date) NOTE: relation ALLOCATIONS stores the registration number (attribute Employee) of employees that are assigned to a given project (attribute Project is the number of the project, not the name of the project), the function the employee has in that project (i.e., technician, manager, etc.) and the date when the employee has been assigned to that...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
Project Database Description After the requirement collection and analysis phase the software project of a database...
Project Database Description After the requirement collection and analysis phase the software project of a database application about a company is described as follows: The company is organized into departments. Each department has an unique name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have multiple locations(cities). A dept controls a number of projects, each of which has a unique...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission:...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler. Database scenario: Assume that...
Projects Case Study A construction company requires a database to record details about building projects. Each project has its own project number, name and employees assigned to it. Each employee has an employee number, name and job classification, such as engineer or computer technician. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent upon the employee's position. For example, one hour of a computer technician's time is billed at a...
Consider the relational database schema for a company below. EMPLOYEE/NAME, SSN, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNA) TA DEPARTMENT(DNAME, DNUMBER. MESSINS, MGRSTARTDATE) DEPT_LOCATIONS(DNUMBER. DLOCATION PROJECT(PNAME, PNUMBER. PLOCATION, DNLIM) WORKS_ONCESSN.PNG, HOURS) DEPENDENTESSN, DEPENDENT-NAME, SEX, BDATE, RELATIONSHIP) Write SQL statements for the following queries: a) List the names of those employees who work in the "Production" department (6 marks). b) Find the maximum salary, minimum salary, and the average salary among employees who work for the "Production department (6 marks). Count the...
Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn, dnumber) Department (dname, dnumber, mgrssn, mngrstartdate) Project (pname, pnumber, plocation, dnumber) Works_On (ssn, pnumber, hours_per_week) Dependent (ssn, dependent name, bdate, relationship) The above relations store information about a company. The meaning of most of the relations and attributes is straightforward. For example, the first relation stores information about employees. The mgrssn is the SSN of the manager (supervisor) of the given employee. A manager...
10. For each employee in the department with code
ACCNT, find the employee ID and number of assigned hours that the
employee is currently working on projects for other departments.
Only report an employee if she has some current project to which
she is assigned more than 50% of the time and the project is for
another department. Report the results in ascending order by
hours.
11. Find all departments where all of their employees
are assigned to all of...
Part I (60 Pts.). Please answer questions (a) and (b) using the following tables held in a Relational Database Management Systems. Employee (eupllName Wane, address, DOB, sex, position, deptNo Department (deptNe, deptNane mgrEupID Project where Employeecontains employee details and empll is the key Department contains department details and deptNe is the key mgrEplD identifies the employee who is the manager of the department. There is only one manager for each department. contains details of the projects in each department and...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department, ProjectName) EMPLOYEES(Number, Surname, FirstName, Department) ALLOCATIONSEmplovee, Project, Function, Date) NOTE: relation ALLOCATIONS stores the registration number (attribute Employee) of employees that are assigned to a given project (attribute Project is the number of the project, not the name of the project), the function the employee has in that project (i.e., technician, manager, etc.) and the date when the employee has been assigned to that...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
Most questions answered within 3 hours.
-
The following temperatures show the (fictional) daily low
measured at O'Hare airport every January 1st from...
asked 18 minutes ago -
Your friend is interested in the characteristics of fast tree
planters. He searched through the records...
asked 25 minutes ago -
. 0.67 g of Ag is deposited electrolytically from
AgNO3 after a certain period of time...
asked 26 minutes ago -
assuming that the boric acid, h3po3 present at the end of the
borax tritation has a...
asked 25 minutes ago -
When a carbonate solution is acidified, carbon dioxide is
produced.
2H+(aq) + CO32-(aq) → H2O(l) +...
asked 1 hour ago -
A reaction has the following rate law: Rate =
kr[A][B]2. In experiment 1, the
concentrations of...
asked 1 hour ago -
king owns a large number of public pay phones. as rhe use of
payphones decline deamatically,...
asked 1 hour ago -
3.7 - A book is sitting on a table. The mass of the book
is 1...
asked 1 hour ago -
Which term describes the process by which a single strand of DNA
serves as a template...
asked 1 hour ago -
LAB FOOD DRING
ANSWER THE QUESTIONS:
Q1. What value is the moisture content versus time and...
asked 1 hour ago -
You are told that an object has zero acceleration. Two forces on
the object are: F_1...
asked 1 hour ago -
The usual starting point for preparing a master budget is
forecasting or estimating:
Multiple Choice
Sales....
asked 1 hour ago