Conceptual Data Models
To create a wholesale store database, a conceptual model should initially be created. The conceptual model describes entities, attributes, and relationships between them. There is a supplier (Mr. Jackson) who supplies the goods (watches) and buyers (boutique and other retail stores) who directly purchase this product. Before the transaction process, Mr. Jackson purchases metal and glass from vendors. The conceptual model of the Batch Watch database will contain addresses and contacts of suppliers and buyers, as well as articles of goods and their quantity. This can be achieved through the manager who places these orders and who has all the data about both suppliers and goods.
Logical Data Models
The logical model will graphically represent database structures taking into account the accepted data model, independent of its final implementation. It will show what is stored in the database: the objects of the subject area, their attributes and the relationships between them. It will be possible to trace the purchase of glass and metal, as well as the watches made from them, and the profit received for the sale of wristwatches. However, the logical model does not demonstrate the data of vendors and buyers. This model can be achieved if Mr. Jackson focuses exclusively on goods, excluding the issue of logistics.
Physical Data Models
The physical data model model contains all the details needed to create a database. Its construction can be achieved by combining conceptual and logical databases. This data model requires the transformation of many-to-many relationships, so the relationship between the production, purchase and sale processes will be shown. It combines data types and relationships between them, so it will contain the names of materials and models of watches. The adjacent columns will contain the persons who interacted with them and their contacts.