Table Design

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • RE: Table Design
    ... So the OwnerID would link to the EmployeeID, ... and DivisionID based on the OwnerType? ... displays the asset would the sql have to be dynamically created for each ... table for employees, stores, and divisions. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Table Design
    ... and DivisionID based on the OwnerType? ... displays the asset would the sql have to be dynamically created for each ... by an employee the query would join the Assets table to the Employees ... table for employees, stores, and divisions. ...
    (microsoft.public.access.tablesdbdesign)
  • Return multiple characters within a text string
    ... I have a table with a field that stores the type of a particular asset. ... want to return only part of the text string in a query. ... KV2c 16K E ...
    (microsoft.public.access.queries)
  • RE: Clear a field by checking a box?
    ... If you use and employee, asset, and usage table like this --- ... AssetID - autonumber - primary key ...
    (microsoft.public.access.gettingstarted)
  • Re: MS Assets Management sample DB - History table?
    ... > Asset Assignments table for the subform. ... > to assign an employee. ...
    (microsoft.public.access.tablesdbdesign)