It is required to develop the normalization from the Relational Model for the clothing store: Modarte S.A.
Question:
It is required to develop the normalization from the Relational Model for the clothing store: Modarte S.A. de C.V.
-Step 1: Entity-Relationship Model
The clothing store Modarte S.A. de C.V. It has various products for women, men, boys and girls, which requires generating an Entity-Relationship Model for inventory control and sales management.
It is required to develop 3 tables: products, employees and customers.
In the Products table the following fields must be considered: product code, product name, type, size, purchase date, sale date and quantity in stock.
In the Employees table, the following fields must be considered: Employee ID, Employee Name, Address, Telephone and CURP.
In the Clients table, the following fields must be considered: client number, Client name, address, e-mail, payment method, and RFC for billing.
In the Sales table the following fields must be considered: sales code, sale date, payment method and total to pay.
The Products-Sale Relationship contains the following fields: product code and sales code
- Step 2: First normal form.
- Step 3: Second normal form.
- Step 4: Third normal form.
Expert Answer:
Table with fields Products productCodePKproductNametypesizepurchaseDatesaleDatequantity Employees employeeIdPKemployeeNameaddressphonecurp Clients cli... View the full answer
