ERM creation, please help?
Hi
I would be very grateful if someone could create an ERM for this task. I'm still having trouble with it. Or simply explain what the entities and relationships between them are. I thank everyone.
(1 rating, 1 votes, rated)You need to be a registered member to rate this.
Loading...
A customer (ID, name) can have many orders
An order (ID, CustomerID, OrderDate, InvoiceDate, PaymentReceipt) has exactly one customer but many models
A model (ID, name) can be present in many orders and has many components.
One component (ID, designation) can be used in many models
In relational databases, an auxiliary table is now always required for n:m relationships.
So many to many requires an extra table.
Order model (OrderID, ModelID, OrderQuantity, Deadline)
Model component (ModelID, ComponentID, ComponentQuantity)
Don't these extra tables have their own additional ID?
You don't have to, but you can. It's usually better if you want to edit the entries.
Congratulations!!!!! but give me a star for my answer 😉
Thank you very much. I passed my exam!