Helping in make ERD diagram

Posted on 2013-05-30
Last Modified: 2013-06-15
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?
Question by:drtopserv
  • 10
  • 5
LVL 84
ID: 39207263
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.

Expert Comment

ID: 39207300
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.


Author Comment

ID: 39208345
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 .
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 39208347

Author Comment

ID: 39208369
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.

Author Comment

ID: 39208380
oh, i forgot to say thnx to LSMConsulting too,sorry i didn`t clear my Q, i hope i have clarify it better.

Expert Comment

ID: 39208775
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.

Author Comment

ID: 39209023
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).

Expert Comment

ID: 39209249
I believe I've incorporated your latest input into a revised ERD (attached).

Author Comment

ID: 39209924
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

Author Comment

ID: 39209951
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 .

Expert Comment

ID: 39210121
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.

Author Comment

ID: 39210128
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".

Author Comment

ID: 39210141
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.

Accepted Solution

0Doc earned 500 total points
ID: 39211141
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.


Author Closing Comment

ID: 39250198
thnx 0Doc,
you have helped me out to start the worth it:}

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

679 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