Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Explain why is metadata essential for using, for building and for administrating the data warehouse?
Describe at least four advantages of granularity of data in the warehouse design.
Describe the fragmentation transparency, replication transparency and location transparency in the distributed databases.
Describe the difference between the logical and physical data independence.
Building warehouse on the multiple levels is simplest scenario to manage, with fewest risks. Describe.
What do you mean by Partitioning of data? Describe with an illustration. Describe the ways to carry it out. Which is better and explain why?
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