Suppose the Park Administration decided that it wanted to allow more than one Sponsor to sponsor a
given area.
(1) Would they need to redesign the database? If so, propose a new relational schema that can allow
more than one sponsor to sponsor an area. (Note that this may require the creation of new relations.)
(2) Suppose they also decided not to have more than one sponsoring group working in a given area on the
same date. How could a re-design of the database allow this?
(HINT: think about the purpose of the Primary Key.)

Question

Suppose the Park Administration decided that it wanted to allow more than one Sponsor to sponsor a
given area.
(1) Would they need to redesign the database? If so, propose a new relational schema that can allow
more than one sponsor to sponsor an area. (Note that this may require the creation of new relations.)
(2) Suppose they also decided not to have more than one sponsoring group working in a given area on the
same date. How could a re-design of the database allow this?
(HINT: think about the purpose of the Primary Key.)

jean-luc · Answer

Please find attached relation

rebeccaxhawaii · Answer

$\Huge\boxed{\boxed{\boxed{\huge\mathbb{WELCOME~TO~OPENSTUDY} }}}$ Hey i have made this to hopefully answer any questions you may have. But if it doesn't feel free to pm me c: http://openstudy.com/users/rebeccaxhawaii#/updates/56f5205ce4b07a8c82287f75 Good Luck with your studies! $\Huge\heartsuit$