Prepare ER models, the ER models should have entities, attributes and relations and the database designs should have primary and foreign keys. Comment on what normal form your 4 databases are in. If you make any assumptions, then write them below the models.

A company operates a warehouse parts supply business. The company has several warehouses located in Toronto which each store several hundreds of automotive parts. We need to keep a record of how many parts are "on hand" - meaning inventory levels that tell us how many we have for each part. To help us organize our parts, each part is assigned a specific classification. There are 4 classifications that we use to organize hundreds of parts.