Question 1 [20 Marks]View more random threads:
- MTH302 Business Mathematics & Statistics Assignment 2
- CS601 Assignment 4 Solution 12 July 2010
- CS201 Solution 2nd Assignment Spring 2010 May 4
- International Business (MGT520) Assignment No.1 Last Date...
- Allama IQbal Open University (Aiou) assignment solutions...
- mgt411 fall 2010 first assignment
- Special virtual university assignment solution
- CS501 Advance Computer Architecture Assignment No. 04...
- CS402 assignment-1 discussion and Solution fall 2014
- CS402 4th assignment, July, 2010
Sponsored Links
Read the two scenarios given below and identify the Entities and then identify Attributes related to these entities and hence draw the Entity Relationship Diagram (ERD) in both cases given below.
a) A company has a number of employees having their name, address and date of birth. The company has several projects having a code, description and start date. Some employees are given salary one hourly based work with fixed per hour rate while other are one payroll and have fixed per month salary plus residence allowance. Each employee is assigned one or more projects and he may not be assigned to any project. A project must have at least one employee and may have more than one employees assigned.
b) A laboratory has several chemists who work on various projects and who may use certain kind of equipment on each project, there are also different chemicals involved in a project that a chemist may use chemicals have a name, number and the quantity. Chemist has a name and phone number, while project has an id and start date. Equipment can have a number and its price.
There are currently 1 users browsing this thread. (0 members and 1 guests)