A company has a number of employees. The attri- butes of EMPLOYEE include Employ

Question

A company has a number of employees. The attri-
butes of EMPLOYEE include Employee ID (identifier), Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Proj- ect ID (identifier), Project Name, and Start Date. Each employee may be assigned to one or more projects or may not be assigned to a project. A project must have at least one employee assigned and may have any number of employees assigned. An employee’s bill- ing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. Do you have any associative entities on your ERD? If so, what are the identifiers for those associative entities? Does your ERD allow a project to be created before it has any employees assigned to it? Explain. How would you change your ERD if the Billing Rate could change in the middle of a project?

Explanation / Answer

The complete guidelines for naming attributes in the given description has not been followed. The following attribute names can be suggested:

1.EMPLOYEE table:

Employee_ID (Since attribute names cannot have space.Either an underscore or hyphen must be used)

Name and Address can be used as it is.

Date_of_Birth (Since logical noun should be separated with underscore)

2.PROJECT

Project_ID (Since attribute names cannot have space.Either an underscore or hyphen must be used)

Name can be used instead of Project Name

Start_Date (Since space cannot be used)

Rate_of_Billing instead of Billing Rate (Since logical verb or noun must be separated by underscore or hyphen)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.