Banner
Advanced Database

Click to view a sample of my work

Robotics Database Project

Business Rules
Constraints
Assumptions
1. This article, and the foregoing articles, shall be valid for all intents and purposes as to the Robotics Team 1885 database
2. The database shall consist of one or more entities
3. The year shall refer to a school-year, which shall consist of two calendar years, separated by a hyphen
4. Each member’s, mentor’s, and volunteer’s and sponsor’s first_name and last_name shall be displayed together as “name”
1. Each team shall have at least one type.
2. Each team shall have at least one member
3. Each member, volunteer, and mentor shall have only one email address in the database
4. Each member, volunteer, mentor, and sponsor shall have at least one email address in the database
1. All members of the robotics team are living human beings
2. The robotics team is not without members
3. The robotics team shall continue to exist forever, or until the end of time, whichever comes first
4. Should a company cease to exist, their company_id shall be deleted, but nothing in this article shall be construed as to forbid the robotics team from reusing a previously-deleted company_id


Click here to view a full version of the following work examples (pdf format):