Solved

Helping in make ERD diagram

Posted on 2013-05-30
16
505 Views
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:

safe=1
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?
0
Comment
Question by:drtopserv
[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
  • 10
  • 5
16 Comments
 
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.
0
 
LVL 3

Expert Comment

by:0Doc
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.

0doc
SampleSafeERD.xlsx
0
 

Author Comment

by:drtopserv
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 .
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:drtopserv
ID: 39208347
0
 

Author Comment

by:drtopserv
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.
0
 

Author Comment

by:drtopserv
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.
0
 
LVL 3

Expert Comment

by:0Doc
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.
0
 

Author Comment

by:drtopserv
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).
CleverLockerMap.xlsx
0
 
LVL 3

Expert Comment

by:0Doc
ID: 39209249
I believe I've incorporated your latest input into a revised ERD (attached).
SampleSafeERD2.xlsx
0
 

Author Comment

by:drtopserv
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
0
 

Author Comment

by:drtopserv
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
PackageType=1000
Quantity=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 .
0
 
LVL 3

Expert Comment

by:0Doc
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.
0
 

Author Comment

by:drtopserv
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".
0
 

Author Comment

by:drtopserv
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.
0
 
LVL 3

Accepted Solution

by:
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.

0doc
0
 

Author Closing Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

752 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