10.Consider the following Business Scenario and identify the relationships In a restaurant, a customer walks up to the counter and places their order. A customer can order for him or herself only, or for him/herself and others For example, a mother orders for herself and her children. We consider the mother to be the customer who owns the order and is responsible for payment. Over a period, a customer can place as many orders as he wants.
Introduction to the data model
Entities, or the items or ideas we wish to collect data about, are the building blocks of data models. These entities form the columns in a database. Possible organizations in a database schema include things like goods, suppliers, and clients. You may conceive of attributes as that of the column in a table since they are information about an entity that we want to keep track of. The name of the product may be an attribute if we have a business entity.
Relationships in a data model are the links between things, and relationships represent business rules. Entities can have one-to-one, one-to-many, or many-to-many relationships with one another.
A one-to-many connection can be shown through the link between items and sellers.
Step by step
Solved in 2 steps with 1 images
