QI. The following stock-in records keep information of products supplied by various vendors. Each product may be supplied by many vendors. Each vendor may supply many products. However, a vendor would deliver products to the warehouse once a day only. Products received are stored in named storage slots. Certain products must be stored in “Cold dock" storage slots while other products are free to be stored anywhere. Date Vendor # | Vendor Name 13 May LF25 13 May YW18 13 May KY38 | 15 Мay ЕК82 15 May LF25 |18 Маy |KҮЗ8 | 19 Мay |KҮ38 Product # |Product Label Quantity Storage # |Storage Slot Li & Fung Corp W533T2 Winchester Saw 250 pcs NE62 W533T2 Winchester Saw 80 pcs NE63 Dry shelf 62 Dry shelf 63 Cold dock 4 Dry shelf 63 Lock rack 28 Yiu Wing Co Kingfisher Yew M450K6 Medicine #450 25 pcs SL04 Edward Kelly Ltd P924G8 Powered Drill 120 pcs NE63 Li & Fung Corp H825B3 Roller Bearings 700 pcs SR28 Kingfisher Yew P924G8 Powered Drill |Kingfisher Yew G392H3 Gold Hammer 68 p 15 pcs NE76 Dry shelf 76 SR32 |Lock rack 32 With the use of dependency diagram, show all functional, partial, and transitive dependencies of the STOCK-IN table as described above. (6 marks) а. b. Normalise the table from your answer in (a) to the 2nd normal form (2NF). (4 marks) с. Normalise the tables from your answer in (b) to the 3rd normal form (3NF). (3 marks) Recently, the warehouse found that some products that do not need to be stored in “Cold dock" have occupied these limited slots. You are requested to refine the database design in order to support controlling the use of "Cold dock" storage slots. d. Taking care of the request and additional assumptions you may have, add new attributes or entities to your database design. Briefly explain how the new components serve the purposes. Draw a Crow's Foot ER diagram for your new database design including all attributes, relationships, primary keys, and foreign keys. (12 marks)

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Please help!!!!!!!   database question!!!

The following stock-in records keep information of products supplied by various vendors.
Each product may be supplied by many vendors. Each vendor may supply many products.
However, a vendor would deliver products to the warehouse once a day only. Products
received are stored in named storage slots. Certain products must be stored in “Cold dock"
storage slots while other products are free to be stored anywhere.
QI.
|Vendor # |Vendor Name
13 May LF25
13 May YW18
|13 Мay |KҮЗ8
|15 Мay ЕK82
15 May LF25
| 18 Мay |KY38
Product # |Product Label Quantity Storage #|Storage Slot
Dry shelf 62
Dry shelf 63
|Cold dock 4
Dry shelf 63
Lock rack 28
Date
Li & Fung Corp W533T2 Winchester Saw 250 pcs NE62
W533T2 Winchester Saw 80 pcs
NE63
Kingfisher Yew M450K6 Medicine #450 25 pcs
120 pcs NE63
Li & Fung Corp H825B3 Roller Bearings 700 pcs SR28
NE76
Yiu Wing Co
SL04
Edward Kelly Ltd P924G8 Powered Drll
Kingfisher Yew P924G8 Powered Drill
Kingfisher Yew G392H3 Gold Hammer
15 pcs
68 pcs
Dry shelf 76
|19 Мay |KY38
SR32
Lock rack 32
With the use of dependency diagram, show all functional, partial, and transitive
dependencies of the STOCK-IN table as described above. (6 marks)
a.
b.
Normalise the table from your answer in (a) to the 2nd normal form (2NF). (4 marks)
Normalise the tables from your answer in (b) to the 3rd normal form (3NF). (3 marks)
с.
Recently, the warehouse found that some products that do not need to be stored in “Cold
dock" have occupied these limited slots. You are requested to refine the database
design in order to support controlling the use of "Cold dock" storage slots.
d.
Taking care of the request and additional assumptions you may have, add new attributes
or entities to your database design. Briefly explain how the new components serve the
purposes. Draw a Crow's Foot ER diagram for your new database design including all
attributes, relationships, primary keys, and foreign keys. (12 marks)
Transcribed Image Text:The following stock-in records keep information of products supplied by various vendors. Each product may be supplied by many vendors. Each vendor may supply many products. However, a vendor would deliver products to the warehouse once a day only. Products received are stored in named storage slots. Certain products must be stored in “Cold dock" storage slots while other products are free to be stored anywhere. QI. |Vendor # |Vendor Name 13 May LF25 13 May YW18 |13 Мay |KҮЗ8 |15 Мay ЕK82 15 May LF25 | 18 Мay |KY38 Product # |Product Label Quantity Storage #|Storage Slot Dry shelf 62 Dry shelf 63 |Cold dock 4 Dry shelf 63 Lock rack 28 Date Li & Fung Corp W533T2 Winchester Saw 250 pcs NE62 W533T2 Winchester Saw 80 pcs NE63 Kingfisher Yew M450K6 Medicine #450 25 pcs 120 pcs NE63 Li & Fung Corp H825B3 Roller Bearings 700 pcs SR28 NE76 Yiu Wing Co SL04 Edward Kelly Ltd P924G8 Powered Drll Kingfisher Yew P924G8 Powered Drill Kingfisher Yew G392H3 Gold Hammer 15 pcs 68 pcs Dry shelf 76 |19 Мay |KY38 SR32 Lock rack 32 With the use of dependency diagram, show all functional, partial, and transitive dependencies of the STOCK-IN table as described above. (6 marks) a. b. Normalise the table from your answer in (a) to the 2nd normal form (2NF). (4 marks) Normalise the tables from your answer in (b) to the 3rd normal form (3NF). (3 marks) с. Recently, the warehouse found that some products that do not need to be stored in “Cold dock" have occupied these limited slots. You are requested to refine the database design in order to support controlling the use of "Cold dock" storage slots. d. Taking care of the request and additional assumptions you may have, add new attributes or entities to your database design. Briefly explain how the new components serve the purposes. Draw a Crow's Foot ER diagram for your new database design including all attributes, relationships, primary keys, and foreign keys. (12 marks)
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY