Exam 98-364 Topic 6 Question 64 Discussion
Actual exam question for Microsoft's 98-364 exam
Question #: 64
Topic #: 6
Question #: 64
Topic #: 6
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.
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.
Suggested Answer: A,B,C,D Vote an answer
While converting the conceptual model to a logical model, the following steps are to be followed:
Convert the entities defined in the ER-diagram to tables. The attributes of entities are represented as columns in the table. In the above mentioned ER-diagram, there will be two tables, Employee and Project. Define the primary keys for both the tables, EmpID for the Employee table and ProjectID for the Project table.Migrate EmpID, i.e. the primary key of the Employee table, to the Project table to maintain referential integrity constraint between the two tables.Migrate the attribute Start Date of the "works on" relationship in the same direction as the primary key, i.e. in Project table. The process is shown below as a logical diagram:
Note: The relational model does not support "relationship" data structure like the hierarchical model; therefore, the information that was defined in the relationship attribute should be migrated to an existing or associative entity. The Start Date attribute of "works on" relationshipis therefore migrated to the Project table.
Convert the entities defined in the ER-diagram to tables. The attributes of entities are represented as columns in the table. In the above mentioned ER-diagram, there will be two tables, Employee and Project. Define the primary keys for both the tables, EmpID for the Employee table and ProjectID for the Project table.Migrate EmpID, i.e. the primary key of the Employee table, to the Project table to maintain referential integrity constraint between the two tables.Migrate the attribute Start Date of the "works on" relationship in the same direction as the primary key, i.e. in Project table. The process is shown below as a logical diagram:
Note: The relational model does not support "relationship" data structure like the hierarchical model; therefore, the information that was defined in the relationship attribute should be migrated to an existing or associative entity. The Start Date attribute of "works on" relationshipis therefore migrated to the Project table.
by Belle at Jan 18, 2025, 02:07 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).