Questions 15 are based on the Employee Assignment Table Assu

Questions 1-5 are based on the Employee Assignment Table. (Assume that the table represents the complete listing of all the data) Employee Assignment Table Emp IdEmp_Name Emp Barker Barker Brown Emp Name Project_ $5,000 $10,000 $10,000 $8,000 $5,000 $10,000 Dept Project Id Project Name ProjectProj_ Name MIS Location Director Location Budget H104 H317 H317 IST350 Chestnut Chestnut Chestnut Clover Clover Clover Web Development Database Design Database Design Account Management Marketing Strat Online Marketin David Green Green 100 IST463 IST463 ACC201 100 MIS 200 300 400 400 MIS Jones Smith Smith ACC MKT MKT320 MKT MKT430 Miller Blake RodriquezP240 P202 P231

Solution

5.We wanted to remove all anomalies from the employees assignment table in that case we should remove unneccesary information like project director,project location,project budget,depatment name,project id.In that way we remove all anomalies.

6.The different types of entities and attributes are as follows

Entities

.1.An object with a conceptual existence.

2.List of several activities.

3.Identify the subject areas.
Attributes
1.Candidate key
2.Set of attributes
3.Particular attribute of an entry

7.There are 4 main components included in an ERD which are as follows

a.entity

b.relationship

c.attribute

d.cardinality