Question: Database Design [ ER-Model ]: Please draw a ER-Model Diagram - A company has a number of employees. The attributes of EMPLOYEE include Employee_ID (identifier),

Database Design [ ER-Model ]: Please draw a ER-Model Diagram

- A company has a number of employees. The attributes of EMPLOYEE include Employee_ID (identifier), Name, Address, and Birthdate.

- Some employees are maintenance staff, while the rest are technical staff. An employee can be either a maintenance staff or a technical staff, but not both.

- The company also has several projects. Attributes of PROJECT include Project_ID (identifier), Project_Name, and Start_Date.

- Each technical staff 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 assigned, and may have any number of technical staffs assigned.

- A technical staffs billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate) for each technical staff when assigned to a particular project.

- There are a number of building, 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, and every 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...

DATABASE DESIGN CLASS 1. Draw an ER diagram for the following Company database (make sure you show all the cardinalities and participation ratios ): We need to store the SSN, name, birth_date,...

Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

Develop an EER model for the following situation. To refresh your knowledge learned from the chapter lecture, I append the procedure of developing an EER model after the description of the case. You...

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

E-R Model - Entities The modeling, design and creation of a databse is an iterative, top-down process. First, the designer must gather information to define specific requirements. This will involve...

***PLEASE DRAW A ER/EER DIAGRAM. BE SURE THAT DIAGRAM INCLUDES COMPOSITE AND MULTI-VALUED ATTRIBUTES, TERNARY RELATIONSHIPS AND WEAK ENTITIES, AND EER PART OF GENERALIZATION.*** Database Design Using...

Homework 2 Please develop an EER Model for the following situation. Your EER diagram must be complete, meaning that all necessary information must be presented. Make appropriate assumptions if...

Present arguments for and against using advertising agencies. Are there lessons to learn from the experiences of Alex Bogusky (CP+B), featured in the Marcom Insight?

Draw the new category management cycle

Suppose that the Japanese yen is selling at a forward discount in the forward - exchange market. This implies that most likely Yen is strengthening relative to the dollar. Yen has low exchange - rate...

On December 1, Martin Company signed a $4,200, 3-month, 8% note payable, with the principal plus interest due on March 1 of the following year. What amount of interest expense is accrued at December...

8. One way to diagnose transfer of training problems or to ensure that transfer of training occurs is to complete the matrix shown below. This matrix considers the responsibilities of the manager,...

5. This assignment relates to Application Assignment 2 in Chapter 4. You now receive the following e-mail from the vice president of operations. Prepare an answer. Thanks for your recommendations...

2. Identify and choose outcomes to evaluate a training program.