W
W
woodyJS2017-05-24 13:49:51
Database
woodyJS, 2017-05-24 13:49:51

How to improve the database model?

The actual picture will be below. And this is a task.
Description of the subject area. The bakery produces various bakery products, and then sells them. It is necessary to keep records of the production and sale of products. The list of bakery products produced at the bakery is stored in the directory. For each product, it is known: product name (for example, Darnitsky bread, Nareznoy loaf, etc.), weight, expiration date, cost, trade and selling price. The same product can be produced in different departments of the plant. Production information is stored in the following form: shop name, product name, release date, quantity. Products are sold on the basis of production data. At the same time, the date of sale, the name of the goods, the quantity, and the name of the workshop in which the goods were produced are recorded.
dee0687d2d3548ca9bb527205da64c98.jpg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2017-05-24
@Rsa97

Convert to at least third normal form.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question