Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Microsoft Visual Basic 2008 Comprehensive Concepts And Techniques

Authors: Gary B. Shelly, Corinne Hoisington

1st Edition

1423927168, 978-1423927167

More Books

Students also viewed these Databases questions

Question

My opinions/suggestions are valued.

Answered: 1 week ago