Database Design for Business Concepts
Added on 2019-09-22
6 Pages281 Words128 Views
|
|
|
STUDENT27 SEPTEMBER, 2016DATABASE DESIGN AND IMPLEMENTATION FOR BUSINESSCONCEPTSASSIGNMENT 3
ContentsPART 1: SUNSET ZOO.............................................................................................................................2BUSINESS RULES................................................................................................................................2CONCEPTUAL ER DIAGRAM...............................................................................................................3PART 2: SPORTS FANS............................................................................................................................3BUSINESS RULES................................................................................................................................3EXTENDED ER DIAGRAM....................................................................................................................4
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.
End of preview
Want to access all the pages? Upload your documents or become a member.