Database Management Systems-AN1-2015
Database Management Systems-AN1-2015
Database Management Systems
Only TWO Questions Solution will provide
Q1: A university registrar’s office maintains data about the following entities:
a) Courses, including member, title, credits, syllabus and prerequisites
b) Course offerings, including course number, year, semester, section number, instructor, timings and classroom
c) Students, including student- ID, name, and Program; and
d) Instructors, including identification number, name, department and title. Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.
Construct and E-R diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
Q2: Explain in detail about Relational Algebra, Domain Relational Calculus and Tuplr Relational Calculus with suitable examples.
Q3: Describe about the Multi-Valued Dependencies and Fourth normal form with suitable examples.
Q4: Construct a B+ tree to insert the following key elements (order of the tree is 3) 5,3,4,9,7,15,14,21,22,23.
Data Warehousing and Data Mining-AN1-2015
Data Warehousing and Data Mining-AN1-2015
Only TWO Answers
Q1. What is a multiprocessor architecture? List and discuss the steps involved in mapping a data warehouse to a multiprocessor architecture.
Q2. Discuss the typical OLAP operation and types of OLAP server with an example.
Q3. Explain the advantages and disadvantages of decision tree over the classification technique and briefly outline the major steps of decision tree classification.
Q4. With an example, explain the two-category Bayesian classification in data mining.
Business Mathematics and Statistics-AN1-2015
Business Mathematics and Statistics-AN1-2015
ATTENTION: ONLY TWO ANSWERS WILL PROVIDE
Business Mathematics and Statistics
Q1. A random sample of 1000 workers from south India shows that their mean wage is Rs. 47 per week with a standard deviation of Rs. 28. A random sample of 1500 workers from North India gives a mean wage of Rs. 49 per week with a standard deviation of Rs. 40. Is there any significant difference between their mean levels of wages?
Q2. A tea company appoints four salesmen A, B, C, D and observes their sales in three seasons – summer, winter and monsoon. The figures ( in lakhs ) are given in the following table:
Test whether there is any significant difference in the salesman and in the seasons, so far as sales are concerned.
Q3. Fit a straight line trend by the method of least squares to the following data concerning the sales of a certain firm.
Year
2005
2006
2007
2008
2009
2010
2011
2012
2013
Sales Rs(‘000)
48
55
63
65
72
84
90
87
82
Make an estimate of sales for the year 2015.
Q4. A sample of 400 students of undergraduate and 400 students of postgraduate classes is taken to know their opinion about autonomous colleges. 290 of the undergraduate and 310 of postgraduate students favoured the autonomous status. Present these facts in the form of a table and test at 5% level, that the opinion regarding autonomous status of colleges is independent of level of classes of students.
Database Management Systems-AN1-2015
Database Management Systems
Only TWO Questions Solution will provide
Q1: A university registrar’s office maintains data about the following entities:
a) Courses, including member, title, credits, syllabus and prerequisites
b) Course offerings, including course number, year, semester, section number, instructor, timings and classroom
c) Students, including student- ID, name, and Program; and
d) Instructors, including identification number, name, department and title. Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.
Construct and E-R diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
Q2: Explain in detail about Relational Algebra, Domain Relational Calculus and Tuplr Relational Calculus with suitable examples.
Q3: Describe about the Multi-Valued Dependencies and Fourth normal form with suitable examples.
Q4: Construct a B+ tree to insert the following key elements (order of the tree is 3) 5,3,4,9,7,15,14,21,22,23.
Data Warehousing and Data Mining-AN1-2015
Data Warehousing and Data Mining-AN1-2015
Only TWO Answers
Q1. What is a multiprocessor architecture? List and discuss the steps involved in mapping a data warehouse to a multiprocessor architecture.
Q2. Discuss the typical OLAP operation and types of OLAP server with an example.
Q3. Explain the advantages and disadvantages of decision tree over the classification technique and briefly outline the major steps of decision tree classification.
Q4. With an example, explain the two-category Bayesian classification in data mining.
Business Mathematics and Statistics-AN1-2015
Business Mathematics and Statistics-AN1-2015
ATTENTION: ONLY TWO ANSWERS WILL PROVIDE
Business Mathematics and Statistics
Q1. A random sample of 1000 workers from south India shows that their mean wage is Rs. 47 per week with a standard deviation of Rs. 28. A random sample of 1500 workers from North India gives a mean wage of Rs. 49 per week with a standard deviation of Rs. 40. Is there any significant difference between their mean levels of wages?
Q2. A tea company appoints four salesmen A, B, C, D and observes their sales in three seasons – summer, winter and monsoon. The figures ( in lakhs ) are given in the following table:
Test whether there is any significant difference in the salesman and in the seasons, so far as sales are concerned.
Q3. Fit a straight line trend by the method of least squares to the following data concerning the sales of a certain firm.
Year
2005
2006
2007
2008
2009
2010
2011
2012
2013
Sales Rs(‘000)
48
55
63
65
72
84
90
87
82
Make an estimate of sales for the year 2015.
Q4. A sample of 400 students of undergraduate and 400 students of postgraduate classes is taken to know their opinion about autonomous colleges. 290 of the undergraduate and 310 of postgraduate students favoured the autonomous status. Present these facts in the form of a table and test at 5% level, that the opinion regarding autonomous status of colleges is independent of level of classes of students.
No comments:
Post a Comment