Help with table relationships

[Parts Manager]

TableName PrimaryKey Other Fields In
Table ----------------------------------------------------
tblTasks TaskId TaskCategory TaskMajor TaskMinor ItemId

tblBoats BoatId BoatOwner BoatSize BoatPurpose BoatName TaskId

tblEmployee EmpName TaskHours TaskId BoatId

tblParts ItemId ItemMfg ItemMfgPartNumber ItemPrice

Note that tblParts is not complete and is only here to make it easier to
understand the first 3 tables.

I am still developing the structure of a new database I need to build, so I
am writing here to ask for guidance.

With the above Tables, Primary Keys, Fields; Can I do the following and do I
have them linked correctly?

Number 1) TaskId is unique, but the Category/Major/Minor fields can be the
same as other entries such as:

J-04 Hull Hull Mold Prepare & Setup
J-09 Hull Hull Mold Bolt Up
L-02 Deck Cabin Shelf Layout
Q-95 Foyer Stairwell Prepare & Setup
W-107 Foyer Closets Prepare & Setup

Hull Mold may have the same Category/Major for 30 TaskId's; yet the
TaskMinor will always be different than another with the same Category/Major
data. Is this ok to have duplicates of a field data? My assumption is
yes, as this is the data and how it plays out.


Number 2) The goal with tblBoats is that I need to be able to report out All
Parts used in a TaskId or even go with all parts used on a BoatId. I also
need to be able to report all hours spent per BoatId and even per TaskId.


More tables to come, but I first need to be clear on how the relationships
work. If I understand how the tables have their fields and what fields are
needed; and what fields are duplicates and where I may need more study; then
I will proceed onward.


Tim