Windows 10 
Access 2016
Hi, I am completely new to making databases, but I'd like to make a small one to manage my project. The tasks on my project are being tracked as schedule items, which are fairly granular, and also tracked as timesheet items, which tend to be groupings of schedule items. However, some schedule items are things which appropriately do not have an associated timesheet item (such as milestones), and some timesheet items do not have an associated schedule item (such as project management hours). I need to maintain the associations of schedule to timesheet items where they exist. I thought of having a table for schedule items and a table for timesheet items, and connect them with key IDs. However, every item, be it schedule or timesheet, needs to be assigned release number 1, 2, 3, or NotApplicable. How do I store the release number associations in a single table so I’m not duplicating that information? I can’t put release number in the schedule table because some timesheet items don’t have an associated schedule item to inherit a release number from, and vise versa. Do I need to store everything in one table with true/false columns for Schedule and Timesheet, and also a column with release number? Or as 3 tables, one of which somehow has the release associations?
Thanks for any advice regarding this. I’m trying to pick up fundamentals and standards of practice for building good databases along the way.
Reply With Quote
