Question

Consider the following schema for Order Database and draw ER diagram. Also explain entity, relationship and attributes.

SALESMAN (Salesman_id, Name, City, Commission)

CUSTOMER (Customer_id, Cust_Name, City, Grade, Salesman_id)

ORDERS (Ord_No, Purchase_Amt, Ord_Date, Customer_id, Salesman_id)

Answer 1

Answer:

quite

Explanation:

Answer 2

The relationship between entity sets is depicted in an ER diagram. An entity in a database management system is a table or an attribute of a table, hence an ER diagram depicts the entire logical structure of a database by displaying relationships between tables and their characteristics.

Refer to ER diagram for the above schema.

Entity :

• An entity in a database management system is a table or an attribute of a table, hence an ER diagram depicts the entire logical structure of a database by displaying relationships between the tables and their characteristics.

Relationship :

• In a database management system, a relationship is basically the way two data items are joined. Datasets can share and store information in different tables thanks to connections. They also aid in the linking of diverse data sets.

Attributes :

• Features of an entity, the many connections, or a one-to-one relationship are all examples of attribute values.