10MN73 Computer Applications in Mining B.E Question Paper : drttit.gvet.edu.in

Name of the College : Dr T Thimmaiah Institute of Technology
University : Visvesvaraya Technological University
Department : Mining Engineering
Degree : B.E
Subject Code/Name : 10MN73/Computer Applications in Mining
Sem : VII
Year : Dec.2013/Jan.2014
Website : drttit.gvet.edu.in
Document Type : Question Paper

Download Model/Sample Question Paper : https://www.pdfquestion.in/uploads/drttit.gvet.edu.in/5857-10MN73%20Dec%2013.pdf

Drttit Computer Applications in Mining Question Paper

Seventh Semester B.E. Degree Examination,
Time: 3 hrs.
Max. Marks: 100

Related : Dr T Thimmaiah Institute of Technology 10MN45 Mine Surveying-I B.E Question Paper : www.pdfquestion.in/5858.html

Note : Answer FIVEfull questions, selecting atleast TWO questions from each part.

Dec. 2013/Jan. 2014

PART-A :
1 a. Define computer aided design and explain the fundamental reasons for computer aided design. (05 Marks)
b. Explain the design process in computer aided design? (05 Marks)
c. Explain the benefits of computer aided design. implementing (10 Marks)

2 a. What are the hardware components used in CAD systems. Explain briefly the graphics terminal. (10 Marks)
b. Explain the central processing unit and secondary storage used in computer aided design? (10 Marks)

3 a. List the ground rules that should be considered in designing graphics software and explain _constructwg the geometry. (J 0 Mlt.rks)
b. Explain in detail, wire frame and solid modeling. (10 Marks)

4 a. Explain the algorithm for SBOVEL DUMPER COMBINATION equipment selection? (10 Marks)
b. Explain the algorithm for belt conveyor material handling equipment. (10 Marks)

PART-B :
5.a.Explain the ground vibration prediction using blasting and give the algorithm. (10 Marks)
b.Explain the algorithm for blast design. (10 Marks)

6.aBriefly discuss the advantages of using the DBMS. (10 Marks)
b.Explain the difference between logical and physical data independence. (04 Marks)
c.Describe the three schema architecture. What are the problems associated with it? (06 Marks)

7.a.Explain the various joining operations, with examples. (10 Marks)
b.Explain unary and set theory relational operations, with examples. (10 Marks)

8.a.Explain second and third normal forms, with examples. (10 Marks)
b. How is view created and dropped? What problems are associated with updating of views? (10 Marks)

June/July 2016

Seventh Semester B.E. Degree Examination, :
Computer Application in Mining :
Time : 3 hrs.
Max. Marks : 100
Note : Answer FIVE full questions, selecting at least TWO questions from each part.
Part-A :
1. Write a detailed note on application of computers for design.
2. Write a detailed note on the graphics terminal.
3. a. Explain about the functions of graphics package.
b. Distinguish between wire frame and solid modeling in detail.
4 a. Write an algorithm for Ore reserve estimation.
b. Write an algorithm for Bulk material handling equipment.

Part-B :
5. a. Write an algorithm for ground vibration prediction.
b. Write an algorithm for ventilation network analysis.
6 a. Define DBMS. Explain in detail about the advantages of DBMS.
b. Draw and explain ER diagram for company database.

7 a. Explain the following relational operations
i) Select ii) Project iii) Rename
iv) Cartesian product v) Division (10 Marks)

b. Consider the following relational and wrote relational algebra querries:
EMPLOYEE (Name, SS ,Salary, Dno, SuperSSN, gender, Address)
DEPARTMENT (Dname, Dnumber, MgrSS )
Project (Pname, Pno, Dnum)
DEPENDENT (ESSN, Dependent_name)

i) Retrieve SSN of all employee who either work in department 4 or directly supervise an employee who work in department 4.
ii) Retrieve Iist of names of each female employee’s dependent.
iii) Retrieve the names ofthe manager of each department.
iv) Retrieve each department number, the number of employees in the department and their average salary.
v) Retrieve the highest salary of an employee. (10 Marks)

8.a. Define normalization. Explain INF, 2NF and 3NF in detail. (10 Marks)
b. Consider the data given below and write querries in SQL.
EMPLOYEE (Name, SSN, Salary, Dno, SuperSSN, gender, Address)
DEPARTMENT (Dnam, Dnumber, MgrSSN)
PROJECT (Pname, Pno, Dnum)
DEPE DE T (ESSN, Dependent_name)

i) Retrieve names of all employees whose salary is greater than 50000.
ii) Retrieve name and address of all employee who work for the research department.
iii) Retrieve the salary of every employee.
iv) Retrieve all employees whose address is in Bangalore, Kamataka.
v) Retrieve all employees in department 5 whose salary is between 30000 and 40000.