Solved

Helping in make ERD diagram

Posted on 2013-05-30
16
422 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
  • 10
  • 5
16 Comments
 
LVL 84
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:drtopserv
Comment Utility
0
 

Author Comment

by:drtopserv
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 3

Expert Comment

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

Author Comment

by:drtopserv
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
thnx 0Doc,
you have helped me out to start the project.it worth it:}
thnx.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

763 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now