Database Design and Implementation: Assignment 3 - Business Concepts

This assignment focuses on database design and implementation, specifically addressing business concepts. The solution covers two scenarios: Sunset Zoo and Sports Fans. For Sunset Zoo, the assignment outlines business rules, a conceptual ER diagram, and addresses membership, events, and unique identifiers. The Sports Fans section details business rules, an extended ER diagram, fan relationships with teams and sports, and the use of separate tables for fan data. The document also includes the implementation of the BCNF in the ER diagram. The assignment is designed to help students understand the practical application of database design principles. The solutions also explain the use of unique identifiers, and relationships between entities.

Database Design and Implementation for BusinessConcepts ASSIGNMENT 3
STUDENT
27 SEPTEMBER, 2016

Contents
PART 1: SUNSET ZOO.............................................................................................................................2
BUSINESS RULES................................................................................................................................2
CONCEPTUAL ER DIAGRAM...............................................................................................................3
PART 2: SPORTS FANS............................................................................................................................3
BUSINESS RULES................................................................................................................................3
EXTENDED ER DIAGRAM....................................................................................................................4

PART 1: SUNSET ZOO
BUSINESS RULES
The business rules for the sunset zoo as per the given user requirements are as follows:
1. Each member will take up a membership plan level
2. Each membership plan level can be opted by one or more users
3. Each member will have membership info
4. A single membership info will belong to a single member
5. Members can attend zero or more events.
6. Events will be attended by one or members
7. Each member will have a unique id.
8. Each plan will have a unique id
9. Each event will have a unique id.
10. Payment info will be recorded in membership info table.

CONCEPTUAL ER DIAGRAM
PART 2: SPORTS FANS
BUSINESS RULES
The business rules for the sports fans as per the given user requirements are as follows:
1. People are fan of zero or more teams
2. Teams have zero or more fans

3. People are fan of zero or more sports.
4. A sport has one or more fans.
5. Each sport will have a unique id
6. Each person will have a unique id
7. Each team of a sport will have a unique id.
8. Fans of each sport will be recorded in separate table
9. Fans of each team will be recorded in a separate table.
EXTENDED ER DIAGRAM
The diagram below is an EERD and is in BCNF