Question: Using the Entity - Relationship model ( extended if necessary with generalization ) , build a conceptual schema that captures the following natural language description

Using the Entity-Relationship 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!