MANUFACTURING INFORMATION SYSTEM
Time: Three hours Maximum : 100 marks
PART A
(1-10*1 mark = 10 marks ; 11- 15*2 marks = 10 Marks)
Answer all questions. First 10 questions carry one mark each and the remaining 5 questions carry 2 marks each
1. Which among the following is not a type of inventory
a) Work in process c) Finished goods
b) Raw material d) Nodal
2. Which is an order evaluation technique
a) ABC analysis c) PERT
b) Net working d) CPM
3. Physical arrangement of data is called
a) Schema c) entity
b) Sub schema d) all the above
4. Logical arrangement of data is called
a) Schema c) entity
b) Sub schema d) all the above
5. What is the use for hierarchical data model
a) Clear understanding of the system by understanding hierarchy
b) To segregate un wanted data
c) To increase redundancy
d) None of the above
6. What is the use of Network model
a) To understand clearly the network and the dependency of information
b) To increase redundancy
c) To improve communicational error
d) None of the above
7. Which among the following is not a type of production
a) Continuous c) seasonal
b) Batch d) all the above
8. Inventory control is possible by
a) Forecasting c) Planning the activity
b) Proper data maintenance d) All the above
9.On line production control reduces
a) Scrap c) tooling
b) Flexibility d) none of the above
10. Inputs required for Production scheduling
a) Complexity c) due date
b) Forecasting d) None of the above
11. Difference between MRP and MRPII
12. What is entity relationship diagram
13. Define virtual parent child relationships.
14. Define functional dependencies.
15. List out the advantages of lean manufacturing.
PART – B (5*6 marks = 30 marks)
16. What is the role of production organization
17. Explain about hierarchical data model
18. Explain about parent child relationships in data.
19. Explain in detail about ABC analysis.
20. Explain the functions involved in master production schedule planning.
PART C ( 5*10 marks = 50 marks)
(Answer all questions. Each question carries 10 marks. Answer must not exceed 3 pages)
21. a) Explain in detail about operations control
(or)
b) Explain in detail about the evaluation of order policies
22.a) Explain in detail about data independence and importance of Entity relationship diagram
(or)
b) Explain in detail about the trends in database
23.a) What are the various constraints in the network model? Explain each in detail.
(or)
b) Briefly explain about the queries in SQL.
24.a) What are the elements in inventory? Explain each in detail
(or)
b) Explain the functions of shop floor control in detail
25.a) Explain about the structure of on line production control system.
(or)
b) Explain about the optimal solution of group scheduling
Time: Three hours Maximum : 100 marks
PART A
(1-10*1 mark = 10 marks ; 11- 15*2 marks = 10 Marks)
Answer all questions. First 10 questions carry one mark each and the remaining 5 questions carry 2 marks each
1. Which among the following is not a type of inventory
a) Work in process c) Finished goods
b) Raw material d) Nodal
2. Which is an order evaluation technique
a) ABC analysis c) PERT
b) Net working d) CPM
3. Physical arrangement of data is called
a) Schema c) entity
b) Sub schema d) all the above
4. Logical arrangement of data is called
a) Schema c) entity
b) Sub schema d) all the above
5. What is the use for hierarchical data model
a) Clear understanding of the system by understanding hierarchy
b) To segregate un wanted data
c) To increase redundancy
d) None of the above
6. What is the use of Network model
a) To understand clearly the network and the dependency of information
b) To increase redundancy
c) To improve communicational error
d) None of the above
7. Which among the following is not a type of production
a) Continuous c) seasonal
b) Batch d) all the above
8. Inventory control is possible by
a) Forecasting c) Planning the activity
b) Proper data maintenance d) All the above
9.On line production control reduces
a) Scrap c) tooling
b) Flexibility d) none of the above
10. Inputs required for Production scheduling
a) Complexity c) due date
b) Forecasting d) None of the above
11. Difference between MRP and MRPII
12. What is entity relationship diagram
13. Define virtual parent child relationships.
14. Define functional dependencies.
15. List out the advantages of lean manufacturing.
PART – B (5*6 marks = 30 marks)
16. What is the role of production organization
17. Explain about hierarchical data model
18. Explain about parent child relationships in data.
19. Explain in detail about ABC analysis.
20. Explain the functions involved in master production schedule planning.
PART C ( 5*10 marks = 50 marks)
(Answer all questions. Each question carries 10 marks. Answer must not exceed 3 pages)
21. a) Explain in detail about operations control
(or)
b) Explain in detail about the evaluation of order policies
22.a) Explain in detail about data independence and importance of Entity relationship diagram
(or)
b) Explain in detail about the trends in database
23.a) What are the various constraints in the network model? Explain each in detail.
(or)
b) Briefly explain about the queries in SQL.
24.a) What are the elements in inventory? Explain each in detail
(or)
b) Explain the functions of shop floor control in detail
25.a) Explain about the structure of on line production control system.
(or)
b) Explain about the optimal solution of group scheduling
