Final data base design II Project

1. In the following project, you have to define the problem statement to systematize according to the detected needs. (It must be clear and have at least 8 tables)

(Deliverable 1)

2. DO THE FOLLOWING:

2.1. Give a name to the database.

2.2. List of tables that the database will have. (Which ones are referential and which ones are movement tables).

2.3. Design the data dictionary of each table (field, field name, type, size and description).

2.4. Assemble or design the entity-relationship model.

2.5. Draw the Relational Diagram.

A. Create the DB and the respective tables in mysql (save evidence of the mysql code with which you solve this activity) (Deliverable 2).

B. Design exercises in which the different commands used during the section are applied with their respective analysis and results. (Delivery 3)

C. Submission

PRODUCTION MANAGEMENT SYSTEM

Food Brand Company, packs in its plant most of its star products, this requires a traceability system and packaging management of these products It is necessary to have the data of purchases, production, machine in which there are 3 operating, to obtain the quantity and cost of packaged product, for this we must identify:

Input products, Output products, Quantity, Machine, Operator, Shift and all this becomes ASSEMBLED with which we can model most of the necessary data.

DOCUMENTS TO BE DELIVERED:

Name of the Database and its Tables

Entity Relationship Model

Relational Diagram

Data Dictionary

Data and Relationship.

STORED PROCEDURE :

o You must create a stored procedure to enter purchases.

o Work with DATES: We need to know which operators are over 35 years old and show their complete information.

Work with TRIGGER BEFORE: We need to know the total of the purchase according to the quantity and the cost.

TRIGGER AFTER: We need it to sum the stock in the raw material when a purchase is made.