I am trying to create a simple inventory database that can be accessed in an intranet. I need help on creating the entities for this database. To begin with I have the following entities:
Equipment_Description, Department_Serial_No, Equipment_Serial_No, Model, Manufacturer, Status and Price.
My first entity or table consists of Department_Serial_No and Equpment_Serial_No. Department_Serial_No is the primary key because it functionallly determines the Eqiupment_Serial_No. I am stuck on how to model the entity types.