Question: Using the Entity - Relationship model ( extended if necessary with generalization ) , build a conceptual schema that captures the following natural language description
Using the EntityRelationship model extended if necessary with generalization
build a conceptual schema that captures the following natural language description
of the requirements of a bus company. Express your schema using an ER diagram;
it must be syntactically correct and readable.
Make clear what reasonable assumptions, if any, you are making. State concisely in
English, but referring to the elements of your schema any constraints that cannot
be expressed in the ER schema. Include all cardinalities. Do not submit separate
schema fragments.
Notation: You must make Use the notation developed in class. Add an asterisk on
relationship cardinalities to indicate that it is assumed.
A city is identified by its name and state; we also need to store its population and the names
of popular tourist attractions. A city must hav
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
