Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

Helping in make ERD diagram

Well, I hope someone genius could help me out in this:}}}}

I don`t know how to start the question, I`ll try to explain with my week eng:}

I need to manage a virtual safe by using access , i have a virtual safe room like this:

shelf`s = 22
total cells in each shelf = 16
each cell can reach max of 3000 paper Money (3X1000 package, OR , 1x3000 Package, Unarranged mount of paper Money)

I need to put into the safe a money from different types (4-5 property) also when i put into safe i need to monitor date in , to be able to take out a money by FIFO .

how can i start my erd scheme?
  • 10
  • 5
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Strange question ... is this an academic exercise?

Entity Relationship Diagrams start with identifying the "entities" involved in the process. Some of your Entities here would be the Safe, the Shelf, the ShelfCell, etc etc.

Once you've identified the Entities, you then determine how each of those are related to the other - for example, since you have a single Safe with multiple Shelves, that would be a One-To-Many relationship.

There are software packages which can allow you to develop an ERD, but they're generally somewhat pricey. Also, Visio can do it, if it's part of your Office package.
There are different ERD diagramming methods and a variety of programs to create them.  For more information, Wikipedia has some pretty good information on ERD diagrams.  Here is a link:

I like to keep it simple.  I use Excel.  I have attached a simple diagram to help get you started.  I hope that helps.

drtopservAuthor Commented:
Well,thnx 0Doc, I have the relationship exactly as u said before i send this Q, my problem is that i don`t know how to build that relationship to be able to put out the free space (cells) for putting into them the packages of the paper money .
I attached a map of the safe in sheet1
and a cell properity for the cells inside the safe in sheet2 .
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

drtopservAuthor Commented:
drtopservAuthor Commented:
let say we have this map of the safe in sheet1 that contain 352 cells that can store a packages , the type of the package and the capicity of the maximuin amount of paper that can be stored in a cell, mentioned in sheet2.

at the first step i need to have this map into access db and then manage it through access, means i have to run a form that put data into the cells and a query to pull out data from that safe map.
drtopservAuthor Commented:
oh, i forgot to say thnx to LSMConsulting too,sorry i didn`t clear my Q, i hope i have clarify it better.
I have a question about the cell properties.  Does each individual cell have specific cell property or is the property for a cell determined by what is put into it?  

On the Cell property tab, what purpose does line 6 serve?  

Perhaps it would help if you could give me a couple examples of what goes into a cell.
drtopservAuthor Commented:
well i have attached update map, each cell have specific cell property which determined by what is put into it .
means if i dedicated a cell to contain : Not counted then it must hold only max of 3 packages of 1000 (3x1000).
and if i dedicated a cell to contain :Not suitable then it can hold or 1 package of 3000
(1x3000), or max of 3 package of 1000 (3X1000) , etc...
remember that the cell can hold only 3000 paper money no more.
On the Cell property tab, what purpose does line 6 serve?  <- it`s the type of the money to be hold into the cells(QualityPaperMoney field).
I believe I've incorporated your latest input into a revised ERD (attached).
drtopservAuthor Commented:
Oh, firstly Thnx alot 0Doc for helping me out,
Well, Is this ERD diagram will help me out when i want to answer the following question:

I want to input into the safe a 100 packages from a type of (1000) and a 50 packages of (3000) that are from the type of QualityPaperMoney=Not counted

i need the apps to tell me where should I put them in free cells of the specific type, and if the cells are (occupied) i need the apps to auto choose for me (give me) a free address cells from the type of varied
drtopservAuthor Commented:
for instance:
look at the CleverLockerMap.xlsx map

shelf 1
shelf 2
shelf 3
are from a type of Not counted
cells in shelfs (1+2+3) are empty .

now when i input the following request:

QualityPaperMoney=Not counted
Value = 100

system returns the address of cells where i should put the packages into:

safe = 1
all cells in shelfs 1 and 2  
and first cell in shelf 3    (than will contain only 1 package of (1000))

why :
Quantity=100 / 3 (3=the amount that the cell can host from a PackageType=1000) = 33 cells with 3X1000 for each and 1 cells with 1X1000 in it .
I'm still a little unclear about a couple things on your spreadsheet.  You have listed the following starting on A2:
Shelf->      1      Not counted
Shelf->      2      Not counted
Shelf->      3      Not counted
Shelf->      4      suitable
From this it appears that the cell 1 on shelf 1 is designated as "Not counted" and cell 1 on Shelf 4 is "suitable".  It seems that these cells are assigned as QualityPaperMoney regardless of their contents.  This appears to be at odds with your statement that the cwll property is determined by what it contains.  

It might be if you could show an example on the spreadsheet where of some cells that were full, with the quantities and properties and some cells that were empty.
drtopservAuthor Commented:
OK, i`ll post the example again , but i should clarify somethen.
before i start inserting packages into the cells, i have to pre define the the shelfs and what they will contain , as i show in the spreadsheet.
i pre-define the type of the QualityPaperMoney to be inserted into the cells (means i have to first determine what the type of QualityPaperMoney first)
except some cells (varied ones) that are not pre-defined, these are for the purpose that when   i came and wanna put packages (for instance 10 package of Not counted ) and the pre-defines cells for there type of cells are occupied , the system will notify me and tells me that there is no free cells to host the package and give me the apportinty to choose from the free varied cells to hold the these package into it (of course it will update the type of this varied cells to the type of "Not counted".
drtopservAuthor Commented:
also when i come to pre-define (design the cells) i have to tell the system (insert to the system) the property of the cell, like the CurrencyType,QualityPaperMoney,Values,PackageType,CellCapacity

except the "varied", which i get it`s property dynamically, depends of the QualityPaperMoney type that i`ll choose to put into.
I've got to move on from this issue.  I've done the best I could with it.  There may be parts of your request/design needs that I am not getting to the bottom of, but as far as I can tell ERD design I provided (SampleSafeERD2.xlsx) meets your specification.  It is a simplified design, due to what is easy in Excel, but conceptually I think it captures the gist of the project.

To wrap up, I'm going to try to answer the question about needing to input into the safe 100 packages from a type of (1000) and a 50 packages of (3000) that are from the type of QualityPaperMoney=Not counted.  Not Counted has a cell capacity of 3x1000 (or I assume 3000).  So you are going to need 100/3 cells for the 1000s and 50 for the 3000s for a total of 84 cells.  Now, how do you see if you have enough free cells?

First, you are going to need a query that shows only empty cells.  This would be a query on Cell where ContentsID Is Null

Then a second query, based on the results of the first, that list the free cells for
QualityPaperMoney=Not counted

Lastly, put a total on that query that show the total number of cells and compare that against the 84 that are needed to see if there is room

That's pretty much all I can give you on this project and hope that it as helped.

drtopservAuthor Commented:
thnx 0Doc,
you have helped me out to start the worth it:}
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 10
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now