Question: Database Design 1 : ProjectDB ( 2 0 points ) A company has a number of employees. The attributes of EMPLOYEE include Employee _ ID

Database Design

1

: ProjectDB

(20

points

)

A company has a number of employees. The attributes of EMPLOYEE include Employee

_

(

identifier

),

Name, Address, and Birthdate.

Some employees are maintenance staff, while the rest are technical staff. An employee can be either part of maintenance staff OR technical staff, but not both.

The company also has several projects. Attributes of PROJECT include Project

_

(

identifier

),

Project

_

Name, and Start

_

Date.

Each technical staff member may be assigned to one or more projects, or may not be assigned to a project.

A project must have at least one technical staff member, and may have any number of technical staff assigned.

Technical staff billing rates may vary by project, and the company wishes to record the applicable billing rate

(

Billing

_

Rate

)

for each technical staff member when assigned to a particular project.

There are a number of buildings, each having a unique ID and address.

An employee must work in at least one building.

Each building must be managed by one and only one maintenance staff member, and all maintenance staff must manage at least one building.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

. Database Design 1: ProjectDB (20 points) A company has a number of employees. The attributes of EMPLOYEE include Employee_ID (identifier), Name, Address, and Birthdate. Some employees are...

Database Design 1: ProjectDB (20 points) A company has a number of employees. The attributes of EMPLOYEE include Employee_ID (identifier), Name, Address, and Birthdate. Some employees are maintenance...

Using this table: CREATE TABLE department ( DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) NOT NULL UNIQUE, LOCATION VARCHAR2(20) NOT NULL); INSERT INTO department VALUES(10,...

Can I get some help with this? a brief description would be appreciated Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described above....

Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described above. Save and upload your Visio file. Denton Realtor is a real estate company...

Design an E-R diagram in the Crows Foot model for a real estate firm that lists property for sale: Specify: Entities, their attributes, primary key, and foreign keys; Relationships and their...

Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described below. South LA Inc. (SLA) is a company that provide maintenance services for...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described above. Save and upload your Visio file. Denton Realtor is a real estate company...

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (1) Earnings per share Return on common stockholders' equity Return on assets Current ratio Accounts receivable turnover Average collection period...

3. Solve the following linear program using the fundamental theorem. Specif- ically, find all vertices of the feasible region, calculate the values of the objective function at those points, and...

Please help me prepare an individual tax return. The financials must be inserted on the actual 2 0 2 1 Tax Form which can be found here: 2 0 2 1 Form 1 0 4 0 Show all images Show all images Show all...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. Develop a work sample test to screen applicants for a college professors job.

4. You are preparing to train managers to recognize and overcome their inherent biases. To prepare for this session, take the online Implicit Association Test to determine if you have any unconscious...

5. How would you conduct a complete background investigation on applicants for the job of school bus driver to minimize concerns about negligent hiring?