sql homework

The following table represents the normalization of Brewton Enterprises, Inc. Order Form which identifies the unique attributes that enable various values to be distinguished from each other. Furthermore, the normalized order form comprises of four entities namely; customer details, products inventory details, sales agent information and the respective order details. An entity relationship diagram below the table depicts how the order details entity relies on field values from other entities for its relative attribute values (Noh, Bahari & Zakaria, 2018).

Customer number*

(Customer name)

(Customer address)

(Telephone Number)

Product number*

(Description)

(Category)

(Unit price)

Sales agent number*

(Name)

(Title)

(Gender)

(Telephone number)

(Address)

Order id *

(Order date)

(Customer name)

(Sales agent name)

(Product description)

(Quantity)

(Telephone number)

(Address)

The entity relationship diagram for normalized Brewton Enterprises, Inc. Order Form reveals that it is a one-to-many form or relationship since a customer can order multiple products and also different sales agents can serve the same customer however, under different circumstances which are distinguishable by their unique order numbers.

Reference

Noh, H. N., Bahari, M., & Zakaria, N. H. (2018). A Conceptual Model of Database Normalization Courseware Using Gamification Approach. In PROCEEDINGS OF NEW ACADEMIA LEARNING INNOVATION (NALI) SYMPOSIUM 2018 (p. 23).