|
-
Reef Shark
Request for Access Database Structure Suggestions
This is a request for help in creating an ERD structure for an Access database.
I've found myself in a commitment to develop a scheduling database. By scheduling, I mean this: There are Stores and there are Merchandisers who must stock the shelves at the Stores on scheduled days during the week. I need to be able to efficiently store data about the stores and merchandisers and be able to print reports of the schedules on a week by week basis (mon-sun), showing which merchandiser works on which days, AND at what time of day (morning,afternoon,evening) the work. Additionally, i need to print daily schedules for each merchandiser, showing all the stores they are to visit. I have constructed two models; which of these is better, or is there a better model?
Store with foreign key (FK) in Week
Week with FK in Weekday (mon-sun)
Weekday with FK in Timeofday (morning,afternoon,evening, +more)
Merchandiser with FK in Timeofday
Week with FK in Weekly Schedule
Store with FK in Weekly Schedule
Merchandiser with FK in Weekly Schedule
Weekly Schedule includes fields Mon-Sun, each denoting an enumeration of timeofday
Please, any suggestions?
~ And that is my humble opinion.
When I was a boy I was told that anybody could become President. Now I'm beginning to believe it. - Clarence Darrow
The greatness of a woman’s power is measured in the size and amount of the balls she clutches in hand. -Nephalim
"Tink"
1700+ XP on A7N8X, 768MB PC2700 DDRRAM, Samsung 19" 900IFT, Radeon 64MB DDR VIVO, SB Live! MP3+, 42.9GB IBM HDD, Plexwriter 8/4/32, 3C905CTXM NIC
"Hermes"
Dell Inspiron 8200, 1.7 GHz P4, 512MB DDRRAM, 30GB HDD, DVDROM, Geforce4 Go 64MB
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|