Solved

70-100 Exam

Posted on 2000-03-09
5
247 Views
Last Modified: 2010-05-02
I recently failed the 70-100 exam and I am giving it another try today. I'm aware that calculated fields should not be included as a field but how about the # of something. On the test there was a scenario on an insurance company. The premium is calculated on many fields including the # of Violations. This was listed as one of the fields to choose from. The #of Violations can be derived by doing a count on the driver violations table. Should it be included in the drivers table or would this be considered a calculated field? Also there is a driverflag field that could be used based on the #of Violations for a driver. Should this be added since it is must be derived from the #ofViolations? Help!AnyOne?????
0
Comment
Question by:bufordk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 14

Accepted Solution

by:
wsh2 earned 200 total points
ID: 2601622
To make # of Violations a field.. then you must find a way to maintain integrity between the Driver and Violation tables.

ie.. Whenever/whereever a user Adds/Deletes a Violation Record, code must be executed to increment/decrement the Driver.#OfViolations field to reflect the proper count. If an  Add/Delete occurs and the posting is somehow omitted, then the Driver.#OfViolation field count becomes corrupted.. and the error is carried ad infinitum within the Driver record.. in effect referential integrity is lost.. and could only be recovered by a user written synchronization process.

In the question you pose, because of all the additional overhead needed to keep the #OfViolations field / Violations Table synchronized, you arte much better off leaving referential integrity to the guiles of the System. One would be best served by making #OfViolations a calculated variable.. primed with a SELECT COUNT SQL statement.. 'cause then.. what you see.. is what you get.. <smile>.





0
 
LVL 14

Expert Comment

by:wsh2
ID: 2601724
Now.. Lets talk the real world.. <wink>.

Depending on how VOLATILE your Violation data is and how precisely you have to know the number of violations (ie.. timing and quantity), summarizing referential information can improve application performance dramatically and greatly simplify data retrieval programming. Yes, referential errors may occur (and hence incorrect output), but one has to balance the risk of this with the value of data accuracy. When working with limited resources, there is some wisdom to the old saying.. "Close enough for Government work".

To greatly reduce the risk of bad data, the developer should always provide easily accessible and/or routinely timed table referential integrity audits.. to assure that the data is accurate at a given moment or predetermined interval. "Good Housekeeping" is a must practice, and a very popular magazine.. <smile>.

0
 
LVL 14

Expert Comment

by:wsh2
ID: 2601728
PSsssst.. Let me know how you make out.. k?
0
 

Author Comment

by:bufordk
ID: 2601982
Thank You ........I Passed!
By a whole......FIVE POINTS!
0
 
LVL 14

Expert Comment

by:wsh2
ID: 2602043
Atta B!!!... <huge smile>
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month7 days, 20 hours left to enroll

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question