Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started