Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with Assumptions and Summary. Please help me. You will create an Entity Relationship diagram (ERD) from the database design model. This is not

Need help with Assumptions and Summary. Please help me.

You will create an Entity Relationship diagram (ERD) from the database design model. This is not as easy as it sounds since while there may be a one-to-one correspondence between each database table and each entity in the ERD, the logical relationships between the entities in the ERD may well NOT be the same as those between the table in the database table - of necessity every DBMS can impose implementation constraints on inter-relationships that do not reflect the real life data structure relationships (i.e. exactly what an ERD tries to capture). You will attempt to write a case narrative that describes the data entities as well as the activities performed in this business situation as supported by the database (you can assume this database is in use by some kind of an organization) Based on the narrative you wrote you will now create a Swimlane diagram to describe the actors/roles and the flow of activities you have inferred. You then make a list of the assumptions (for each diagram) you have made about the case (for example ) as you developed these models and the case narrative. You will then make a list of follow-up question to ask users to fill in gaps in your knowledge about this case in the wake of creating your models. As a team you will check your work for logical consistency across the narrative and requirements models you have created, editing where necessary.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach To Design Implementation And Management

Authors: THOMAS CONNOLLY

6th Edition

9353438918, 978-9353438913

More Books

Students also viewed these Databases questions

Question

Provide examples of Dimensional Tables.

Answered: 1 week ago