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

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.


Step by Step Solution

3.40 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Table with fields Products productCodePKproductNametypesizepurchaseDatesaleDatequantity Employees employeeIdPKemployeeNameaddressphonecurp Clients cli... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!