|
|
Objective:
To create Business rules that put into English the one to many relationships of
the database ERD. Describe additional validity rules that could be enforced
y the database.
Assignment:
Write business rules for all relationships on your ERD. Write 6 or more business
rules that describe validity checks that the database is to perform prior to
storing new or revised data.
If possible use very specific
examples. (see problems at the end of text Chapter 5, # 18 page 279, and #22
page 280 for examples)
Details:
- Study how E-R diagrams depict connectivity and cardinality graphically, while
Business Rules communicate these in English. By using specific examples:
(page 281) - "Each consultant has one or more area of expertise, and each
area of expertise can have many consultants in it" (this is said by the E-R
diagram) but elucidated by the example - "For example, a consultant might
be classified as an expert in database and networking, and the consulting
company might employ many experts who are networking experts."
- Describe validity checking that could (should) be performed by the
database including by C++ or VB routines that are trigged by database
updates. For example,
 | the hire date for an an employee must be at least 14 years after
his/her birth date
|
| there might be a limited number of values a field can have such as salutation
of "Mr"., "Mrs.", "Dr",
"Prof.", "Senor", etc
|
| certain values might to required or have a range of valid values such
as salary must be 5.15 (minimum wage) or greater.
|
Using MS Word, write sufficient, 6 (six) or more, business rules, each explained by examples, that clarify
your E-R diagram. Either upload them to your directory on virtual
disk drive or copy then and paste them on the bottom of your ERD.
Procedure:
- Create Business Rules that describe your E-R diagram in English.
- Create Business Rules that will require validation of input such as valid
values, required fields, attributes that have certain values
contingent on the value or existence of an attribute in a different table.
- Write all rules in an MS word document.
- Either upload them to your directory on virtual
disk drive or copy then and paste them on the bottom of your ERD.
Create a new thread in the Business Rules topic that announces where your
rules are and that they are ready for class review.
- Review Rules posted by classmates
- Post suggestions on the Bulletin Board as replies to their post that announced
avalablity
- Imitate good ideas in your business Rules
- Look for suggestions to your E-R Diagram and/or Business Rules
| incorporate suggestions into your design and upload to MySpace again
then note improvement on the Bulletin Board or
|
| post reasons you think suggestions won't work
|
Continue to do steps 6 to 9 as often as needed.
Submit for assignment for final grade
|
