How about:
Assets Table
AssetID
AssetDescription
OwnerID
OwnerType
Then when you link to it from the different tables that can be owners, you
filter it on the OwnerType for that table.
--
Dave Hargis, Microsoft Access MVP
"Weste" wrote:
> I am building an asset tracking database and have a design question. An
> asset can be owned by either an employee, store, or a division. I have
a
> table for employees, stores, and divisions. Each table with some of its
> fields is below. My question is about the Assets table. I need to
track the
> owner of the asset in the Assets table. Should I have 3 separate fields
in
> the table to indicate owner – EmployeeID, StoreID, or DivisionID where
only 1
> of the 3 can be populated for an asset? This doesn’t seem to be the
best
> solution for a normalized design. However, I am stumped as how to
improve it
> since the owners are so different. Any help would be greatly
appreciated.
>
> Assets Table
> AssetID
> AssetDescription
> EmployeeID
> StoreID
> DivisionID
>
>
> Employees Table
> EmployeeID
> LastName
> FirstName
> DepartmentID
> JobTitleID
> TerminationDate
>
> Stores Table
> StoreID
> StoreNumber
> StoreName
> DeparmentID
>
> Divisions Table
> DivisionID
> DivisionName
> DepartmentID
>
> Departments Table
> DepartmentID
> DepartmentNumber
> DepartmentName
>
|
