Do you have a lot of data in your database? Where did this data originate from? Was the data originally in a combination of paper and spreadsheets?
Do you have a lot of data in your database? Where did this data originate from? Was the data originally in a combination of paper and spreadsheets?
This is a very basic risk tracking database that I am doing for training purposes. It does not belong to a business project as such. The relationship in one-to-many. One employee can be a mitigation risk owner in many risks.
If you were trying to convince your boss to undertake this project, what would you say?
What will this do for us?
What is involved?
Who will use it? Why?
How will it work?
Here's a sample narrative:
ZYX Laboratories requires an employee tracking database. They want to track information about employees,
the employee's job history, and their certifications. Employee information includes first name, middle initial, last name,
social security number, address, city, state, zip, home phone, cell phone, email address. Job history would include
job title, job description, pay grade, pay range, salary, and date of promotion. For certifications, they want certification
type and date achieved.
An employee can have multiple jobs over time, (ie, Analyst, Sr. Analyst, QA Administrator). Employees can also
earn certifications necessary for their job.
I am not quite sure why you are asking me to write this but here it is.
This is a Risks tracking database. We will be able to track information about risks. Risks information includes Risk name, Risk Grade, Risk Probability, Risk Mitigation, Risk Mitigation Type, Impact on performance/cost/schedule, opportunities, Mitigation Owners (who is (are) responsible for the mitigation), Follow up owners (who is (are) responsible for the follow up on the risk mitigation), Risk Status, Reason for Change (the user would have to record the reason for making edits to an existing record) An employee can be the mitigation and/or follow up owner in many risks.
B66,
ItsMe has given you the direct answer -- the first step in modeling your data.
You seem too close to the problem to clearly communicate what you are trying to support with automation.
Let me try again.
What Risk? The Risk of catching fire? I could see this if you were an insurance company offering insurance to a remote cottage in the middle of the forest - 2 miles from the nearest water and 20 miles from the nearest fire station.
The risk associated with a first time pilot who has to take over the controls of a jet full of paying passengers.
The risk of someone who packed their own parachute and is attempting to jump from 8000 ft.
You do see how context helps the reader understand the statement.
You should review/work through this tutorial from RogersAccessLibrary re database design.
Walk through/work through the process and you'll understand the importance of knowing the business processes that you are tryiing to support with some automation and database.
I see what you are saying. I will start with your suggested review. Thank you again both!
BTW I opened the link and it dowloaded an invalid image. Nothing to show
What browser are you using? You should not be getting an image.
I am attaching the (zip) file involved.
Good luck.
Also a bit confused - your field riskmitigationtype does not appear to have an associated table
It's not working either. I am using google chrome version 52.0.2743.116 m. It's the latest update
What are yu seeing as file name?
Entity_Relationship
And when you try to open it?
You could try Firefox----I have seen issues in the past.
Ok I will try. Thank you!