Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Is data in the data warehouse homogenous or heterogeneous? Describe with an illustration.
Write down an SQL DDL definition of the database.
Define the term relational completeness? List all the five fundamental relational algebra operations. Explain why are they termed as the basic operations?
Transform the E-R diagram to the Relational Schema.
Describe the various types of cardinality ratios in the E-R diagram? Give some illustrations.
Describe wait-die and wound-wait protocols for the deadlock prevention.
Make a view comprising of the person name all along with their manager name and company name.
Write down a query in domain calculus to determine all customers who encompass a loan amount of more than 1200.
Write down the merits and demerits of the distributed databases.
Describe the Drill-Down Analysis and Event Mapping in the context of EIS.
Describe the Star Schema and snowflake schema with the help of illustrations.
Describe the problem associated to use and storage of unstructured data in the data warehouse.
By using the Armstrong’s axioms to prove the soundness of union, decomposition and pseudo transitivity rule with respect to the set of functional dependencies.
What do you mean by the term outer join? Describe the various types of outer joins with the help of illustrations.
Illustrate the various kinds of constraints imposed on the Generalization in an E-R diagram?
Describe the working of GROUP BY clause. Illustrate the difference between the WHERE and HAVING clause in the SQL?
Apply the hierarchical clustering algorithm for clustering the given eight points. Find out the clusters with their elements.
Describe the difference between the supervised and unsupervised learning with the help of a real world illustration.
Let consider the given relation schema for a COMPANY database
Describe the mapping of the given to the relational database schema.
Describe the two-phase locking protocol? Describe strict and conservative two-phase locking protocol? Which of them is favored and explain why?
List out the main responsibilities of a general purpose Database Manager (DBM)? What problems might take place if these responsibilities are not met by the DBM?
Describe the fundamental components or elements of the data warehouse with the help of a diagram.
Write down some of the reasons for the iterative development of data warehouse. As well describe the role of data model in the iterative development.
Describe primary and secondary data in the context of snapshots in data warehouse.