WPE 303 question paper on Application of Computer in Wet Processing from BUTEX affiliated colleges' 2019 Level-3 Term-I finals. Topics include DBMS hierarchy, CAD and CAM workflows, SQL query writing, and the Beer-Lambert law of spectrophotometry.
Level-3 Term-I, Final Exám-2019
Subject: Application of Computer in Wet Processing (Code: WPE 303)
Time: 3.0 Hrs. Full Marks: 72
(Use separate answer script for Part: A and Part: B)
(All parts of a question must be answered consecutively)
Part: A
(Answer any three questions)
1. (a) Define data, information, database and database management system.
(b) What is meant by data hierarchy? Illustrate data hierarchy of DBMS.
(c) Differentiate between DBMS and file system.
[2+(1+4)+5=12]
2. (a) What is supply chain management? Write down the list of steps in investment and infrastructure analysis for computer based production unit. .
(b) Summarize the distinction between the traditional product development and the computer based product development process model.
(c) What are CAD and CAM? Show the working procedure of textile product development in context of CAD and CAM.
[3+4.5+4.5=12]
3. (a) What is SQL? How can values be entered in a relation using SQL statement?
(b) Distinguish between drop and delete statements. .