98-364 · Question #88
You work as a Database Designer for SoftTech Inc. You have developed the conceptual design of the database of an organization. Following is the ER-diagram, which you have designed. Now you have to…
The correct answer is A. Now migrate the Start Date attribute of "works on" relationship to the Project table. B. Create two tables, Employee and Project. C. Create a primary key for both the tables. D. Migrate the primary key of the Employee table to the Project table to maintain referential. See the full explanation below for the reasoning.
Question
You work as a Database Designer for SoftTech Inc. You have developed the conceptual design of the database of an organization. Following is the ER-diagram, which you have designed. Now you have to convert the following diagram to a logical model. Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.
Exhibit
Options
- ANow migrate the Start Date attribute of "works on" relationship to the Project table.
- BCreate two tables, Employee and Project.
- CCreate a primary key for both the tables.
- DMigrate the primary key of the Employee table to the Project table to maintain referential
- ECreate three tables, Employee, Project, and Manager.
How the community answered
(40 responses)- A70% (28)
- E30% (12)
Community Discussion
No community discussion yet for this question.