cardinality) for the following s? Draw an E-R diagram (including attributes, identifiers and mandatory/optional cardinality) for the following system description, stating any assumptions you make.
A company keeps records of the products it stores in its warehouses and the factories that make the products. Each product is identified by a unique product number and has a name and description. A product is made by a single factory but a factory can make more than one product. A factory is recognized by a factory code and has an address and telephone number. A product can be stored in one or more warehouses and a warehouse can stock a number of products. The quantity of a product stored at a warehouse needs to be recorded. A warehouse is identified by a warehouse code and the address is also held.
A company keeps records of the products it stores in its warehouses and the factories that make the products. Each product is identified by a unique product number and has a name and description. A product is made by a single factory but a factory can make more than one product. A factory is recognized by a factory code and has an address and telephone number. A product can be stored in one or more warehouses and a warehouse can stock a number of products. The quantity of a product stored at a warehouse needs to be recorded. A warehouse is identified by a warehouse code and the address is also held.