Application of Computer in Fabric Manufacturing (FME 337) question paper from the 2018 Level-3 Term-II finals at BUTEX affiliated colleges, 70 marks. Includes DBMS, SQL statements, project scheduling with EST and LFT, and textile industry software.
Level-3 Term-II, Final Exám-2018
Subject: Application of Computer in Fabric Manufacturing (Code: FME 337)
Time: 2.0 Hrs. Full Marks: 70
(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) What are the reasons for using the Data Base Management System (DBMS)?
(b) List down the limitations of Data Base Management System (DBMS).
(c) Discuss data storage hierarchy and System Development Life Cycle (SDLC).
[5.5+6+6=17.5]
2. (a) Define the terms data, information and knowledge.
(b) What is primary key? 'Primary key can have NULL value' do you think the statement is correct?
(c) What is the basic structure of SQL queries? Explain
(d) What do you understand the INSERT and UPDATE statement? Explain with examples.
(e) Distinguish between the following:
i. Fixed and Tangible cost.
ii. Direct and Indirect cost.