Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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.
Illustrate out the method to create windows application. Illustrate out the term arrays? Describe one dimensional array with appropriate illustrations.
Illustrate out any two (2) full text search functions. Illustrate out any five (5) Flow Control Constructs.
Illustrate the key properties of the long duration transactions? How does the concurrency protocol influence the long duration transactions?
What do you mean by the primary goal of normalization? Illustrate how the concepts of functional dependency and multi valued dependency related with the normalization? Give an illustration for the s
Find out the names of pilots who can operate planes with a range more than 3,000 miles, however are not certified on any Boeing.
With respect to the relational data model, illustrate the concept of primary and foreign key constraints. Explain why are primary and foreign keys used? Describe your answer with illustration.