Database Design for Business Concepts
Added on 2019-09-22
6 Pages281 Words128 Views
|
|
|
STUDENT27 SEPTEMBER, 2016DATABASE DESIGN AND IMPLEMENTATION FOR BUSINESSCONCEPTSASSIGNMENT 3
![Database Design for Business Concepts_1](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Fd9bd0fef44fb4915b88c1c8ac7560e6b.jpg&w=3840&q=10)
ContentsPART 1: SUNSET ZOO.............................................................................................................................2BUSINESS RULES................................................................................................................................2CONCEPTUAL ER DIAGRAM...............................................................................................................3PART 2: SPORTS FANS............................................................................................................................3BUSINESS RULES................................................................................................................................3EXTENDED ER DIAGRAM....................................................................................................................4
![Database Design for Business Concepts_2](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2F9dd01a319fc24a44b08785d28902dfd7.jpg&w=3840&q=10)
PART 1: SUNSET ZOOBUSINESS RULESThe business rules for the sunset zoo as per the given user requirements are as follows:1.Each member will take up a membership plan level2.Each membership plan level can be opted by one or more users3.Each member will have membership info4.A single membership info will belong to a single member5.Members can attend zero or more events.6.Events will be attended by one or members7.Each member will have a unique id.8.Each plan will have a unique id9.Each event will have a unique id.10.Payment info will be recorded in membership info table.
![Database Design for Business Concepts_3](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2F2a94a0bfbf5d4c4ba92292fc0f69aa07.jpg&w=3840&q=10)
End of preview
Want to access all the pages? Upload your documents or become a member.