Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Connecticut Boating Organization needs a database to keep track of cities that have docks and it's members with boats. The E-R diagram in the figure

image text in transcribedimage text in transcribed Connecticut Boating Organization needs a database to keep track of cities that have docks and it's members with boats. The E-R diagram in the figure below illustrates the key entities of interest to the team and the relationships between them. Based on the figure, answer the following questions and explain the rationale for your response. For each question, identify the element(s) in the E-R diagram that may help you in determining your answer. a) Can a boat be docked at any dock? (Yes/No) Explain (why or why not) . b) Is it possible to intake several payments for the membership? (Yes/No) Explain (why or why not). c) Does the city keep track of the boats? (Yes/No) Explain (why or why not). d) Does the diagram show you that they keep track of any docking approvals? (Yes/No) Explain (why or why not). e) Characterize the degree and the cardinalities of the relationship that connects member, dock and payment. Explain its meaning

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_2

Step: 3

blur-text-image_3

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

Operations Management

Authors: William J Stevenson, Mehran Hojati

4th Canadian edition

978-1259270154, 1259270157, 978-0071091428

More Books

Students also viewed these General Management questions

Question

2 Describe the survey fieldwork/data collection process.

Answered: 1 week ago