You are required to provide solution for the manufacturing company to automate their socks manufacturing process. It will bring effectiveness to production departments in production of socks from knitting to packaging process. Proposed System, will not only save time in recording counts of dozen of socks but also notify user about the stock and helps QC to add remarks against production. Thus, proposed system offers a good solution to maintain & track record of items while achieving effectiveness and efficiency.

1. Case Study Based Database Designing

 

You are required to provide solution for the manufacturing company to automate their socks manufacturing process. It will bring effectiveness to production departments in production of socks from knitting to packaging process. Proposed System, will not only save time in recording counts of dozen of socks but also notify user about the stock and helps QC to add remarks against production. Thus, proposed system offers a good solution to maintain & track record of items while achieving effectiveness and efficiency.

 

You’ll develop a requirement to propose a solution. What database you will be using and why, which architecture you will use to develop the solution. Try and answer the subsequent questions:

ÂÂ

• Who can use this info for what purpose? Keep in mind there could also be different types of users. E.g., administrator, Supervisor, QA.

ÂÂ

• What operations the system has to offer to support such purpose? Imagine yourself a client who will use the system.

ÂÂ

• What knowledge has to be hold on in info to support such operations?

ÂÂ

• What assumptions you’re creating once you design the info/database.
• The question that everybody asks is “how massive your application ought to be?â€Â�