logo

Database Design and Implementation for Business Concepts: The sunset zoo

   

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.

Related Documents
STUDENT. 30 SEPTEMBER, 2016. ITERATION 4 ASSIGNMENT. ST
|7
|498
|238

Database Design and Table structure
|54
|5988
|17

Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations
|15
|1038
|412