The Inventory_ID is NOT just a foreign key column in the Laptops table, but is also a primary key because the relationship is one-to-one.
We store inventory common data in the table Inventory (ID,Name,Type) and we store more data in the relevant table (e.g. Laptops, Monitors, Printers).This gives me the ability to store data relevant to the inventory item (e.g. I have a field 'Page' on the printers table to store the number of pages the printer can print).The field 'Type' in inventory table refers to the type of the inventory (e.g. 1=Laptop,2=Monitor and so on).
Here is my tables structure:
Type number (foreign key to a table Inventory_types which has ID and name)
Inventory_Id varchar2 (primary key and foreign key linking to the inventory table)
more fields here........
Another question: how can expose a 1-to-1 property on both sides (e.g. on the inventory entity, I would like to have a property called Laptop of type Laptop.On the Laptop entity, I need to have a property Inventory that points me to the inventory entity associated with the current entity.