CODEWITHSUNDEEP
databasedatabase-designschemarelationshiptable-relationships
Eduardo Sampaio
Eduardo Sampaio

Reputation: 1

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

Upvotes: -2

Views: 2630

Answers (2)

JoshBerke
JoshBerke

Reputation: 67128

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

Upvotes: 0

0b1
0b1

Reputation: 1

Customers generally don't have a direct relationship with Products. Generally, customers create orders, composed of multiple products.

So customers typically have a one to many relationship with an 'Orders' table. The Orders table has a one to many relationship with an OrderItems table. That table might store quantity, color, etc, and has a many to many relationship with the Products table.

Of course, that's just the typical entity relationship. Without more information, it's hard to know if it meets your needs or not.

Upvotes: 0

Related Questions