Small Advertising Company ERD

Availability: In stock

Regular Price: $15.00

Special Price: $12.00

OR

Small Advertising Company ERD

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

The purpose of this assignment is to allow you to practice designing and developing an ER diagram by using an appropriate tool.


This assignment requires you to develop an ER Diagram for a database that is used to maintain basic information concerning the hours spent on projects by employees in a small advertising company. A customer may have many projects and an employee may have worked on many projects. Each project is for just one customer.


The tables needs to include the following:
• Customer(id, name).
• Employee(id, name, department id, salary).
• Project(id, title, customer id).
• EmpProj(employee id, project id, hours).


Primary keys and foreign keys need to be identified as well. Draw the ER Diagram using any tool that you want. The easiest is probably a word processor, but you could also use a drawing tool such as Visio.

Regular Price: $15.00

Special Price: $12.00

Details

The purpose of this assignment is to allow you to practice designing and developing an ER diagram by using an appropriate tool.

This assignment requires you to develop an ER Diagram for a database that is used to maintain basic information concerning the hours spent on projects by employees in a small advertising company. A customer may have many projects and an employee may have worked on many projects. Each project is for just one customer.

The tables needs to include the following:
• Customer(id, name).
• Employee(id, name, department id, salary).
• Project(id, title, customer id).
• EmpProj(employee id, project id, hours).

Primary keys and foreign keys need to be identified as well. Draw the ER Diagram using any tool that you want. The easiest is probably a word processor, but you could also use a drawing tool such as Visio.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.