Database Designing - ER

Ihussein

Registered User.
Local time
Today, 22:20
Joined
Nov 11, 2015
Messages
47
Hello,
Please your advice on the attached relationship,most of my transaction depends on AreaID, it's good bad? what is the way forward and what is best practice that I can follow?
Regards
 

Attachments

  • ER.JPG
    ER.JPG
    37 KB · Views: 323
Would need a description of what it is supposed to do. Please describe in plain english
 
Thanks for the initiate, I have 5 areas keeping their details under tblArea, I’m delivering some houses stuffs to these areas one time on monthly basis, I’m keeping the information of the houses that are receiving these stuffs in tblHH, may contacted vendor those whom are providing/delivering the stuff are kept under tblVednors. Monthly plan are to be prepared and approved prior to each dispatch as I said one time per month. Each area has it’s own rate that can be same or changed from month to month kept in tblMonthlyRate. I will be frequently updating tblplan and tblMonthlyRate, please note that I’m using ms access 2013.
Apology for the late replay, and hope it clarifies.
Regards
 
I suspect your layout is not right. Please can you clarify the following

I presume vendors are not exclusive to one area? i.e. they can supply more than one area?

What do vendors provide? is it the items in HH?

can more than one vendor supply the same HH?

Not sure what the monthly rate table does - is it related to the stuffs?
 

Users who are viewing this thread

Back
Top Bottom