Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Define and illustrate the concept of Data Mining.
Retrieve the names of all the senior students majoring in 'COSC' (that is, computer science).
Describe the anomalies in a relation which are addressed by the Normalization.
Define the term Relational completeness. Deduce the Natural Join and Division operator in terms of fundamental relational algebra operations.
Illustrate the procedural and non procedural languages? Which of them are simpler to learn and use? Describe your answer.
Explain Drill-Down Analysis and Event Mapping in context of EIS.
Describe the process of Normalization in the warehouses. List out all its advantages?
Describe at least four advantages of granularity of data in the warehouse design.
Write down the SQL DDL definition for the above schema.
Find out the names of sailors who have reserved the similar color boats as the sailor named ‘John’.
Describe the various levels of abstractions in the database management system.
Describe three various types of distributed data warehouse. Describe local and global data warehouses.
Describe Multidimensional DBMS. Describe the ways of implementing it by giving its strength and weaknesses. Explain how Multidimensional DBMS is distinct from the warehouse?
Describe how the system development life cycle for the data warehouse is precisely opposite to the classical SDLC.
Describe the various states of a transaction. Describe the ACID properties of transactions. Why concurrency control method is required? Illustrate the problems that take place when the transactions
Map the E-R diagram to Relational Model.
The projection operation of relational algebra is termed as Redundancy Elimination Operation? Explain why?
Illustrate the meaning of data reduction? Describe the strategies of the data reduction?
Describe the features of the Neural Network based categorization.
Transform the E-R diagram to normalized relational scheme.
Describe the various types of constraints on the Generalization or Specialization.
Write down the difference between the Database system and the File system.
Describe the system development life cycle of a data warehouse. What factors must be considered while designing a data warehouse.
List out all the differences between the operational data and Decision support system data?
Illustrate out the working of character recognition with an appropriate example. Illustrate out the theory and significance of Model complexity with an appropriate illustration.