databasedatabase-designschemarelationshiptable-relationships

Database schema for Customers, Products and Suppliers


I´m starting in database schema. I don´t have experience in it.

I am thinking of a platform for customers to have access to the types of products that suppliers offer.

So, I would like to know how to keep the database schema following the tables and their relationships.

The customer will be registered in the system and he will have access to suppliers and their products.

Costumer>>>>>>>>>Product>>>>>>>>>Supplier

I already thank anyone who can help.

greetings

Ed


Solution

  • Based on the data you've given.

    You would have a Product table, a product can be sold by one or more supplier. So you would have a Supplier table. Since this is a many to many relationship you would have a cross reference table

    Customer's wouldn't be related to Products or suppliers.

    Example Schema