Thanks for clarifying-- much clearer.
I often ask posters to describe things as per the following scenario:
-pretend you are in a line up at McDonalds (or BurgerKing or your choice) and the person next to you,
who does not know you, does not know your business, has never heard of database
after a few general comments/chat, asks
-what do you do at work? You say building a database
-I have no idea what that is can you tell me more
Anyway your latest post has helped.
After a reading your description a few times, I have identified the following "business facts" that you could confirm or reject or modify.
Divisions are depts...
A Division is responsible for 1 or Many products
Products are made in Batches
A Product may have 0,1 or many Defects(products that have imperfections.)
A DefectiveProduct may be Repairable
A DefectiveProduct does not mean that all Products in the Batch are Recalled
A DefectiveProduct that is not repairable is Recalled
The Company wants to track RecalledProducts.
RecalledProducts are assigned/called an Incident
An Incident records why the Defect was recalled and failed, and whether it can be/was Resolved
A CDE is like a product tag assigned to each defect.
one Incident can have multiple Defects and one Defect can have multiple Incidents
Now I have more questions:
-What does Repairable mean?
-What does it mean to Resolve a Defect?
-Can you give some examples of a RecalledProduct and CDE to clarify what each means and makes them distinguishable?
I'm having difficulty with this one:
Again, perhaps examples would help.one Incident can have multiple Defects and one Defect can have multiple Incidents