Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Describe Redundancy or overlap of data with respect to the global data warehouse and its supporting local data warehouses.
Illustrate the meaning of the term snapshot? Explain in brief the fundamental components of a data warehouse snapshot.
Distinguish between the terms Data Warehouse and Data Mart.
Describe the main methods for recovery from non-catastrophic transaction failure.
Describe the Trivial Functional dependencies with illustration.
Describe the entity integrity and referential integrity constraints. Why each is considered significant?
Illustrate the difference between logical data independence and physical data independence? Which one is harder to accomplish? Explain why?
What are the merits and demerits of Top-Down Approach and Bottom-Up Approach for the data warehouse design?
Distinguish between the data warehouse and operational database.
What do you mean by primary goal of normalization? How the concepts of functional dependency and multi are valued dependency related with the normalization? Give an illustration for the same.
Illustrate the responsibilities of the Database Administrator (or DBA)?
Consider a relational database regarding hotels, customers (or guests) and their bookings which is maintained by an online hotel booking company.
Consider the given employee database, where the primary keys are underlined. Give an expression in the SQL for each of the given queries:
Illustrate the key properties of long duration transactions? How does the concurrency protocol influence the long duration transactions?
List all the four significant differences between the file-processing system and DBMS.
Write down the uses of Distributed Databases. Explain. Write down the features of the heterogeneous services.
What do you understand by the term partition algorithm? Illustarte with the aid of appropriate illustration.
What is normalization? Explain 1NF, 2NF, 3NF with examples?
Write down the different types of partitioning methods. Discuss in detail. Illustrate out the concept of Type Inheritance and Hierarchies with illustrations. Also discuss multiple inheritances.
Write a program in FOXPRO to determine the average of any ten numbers.
Discuss and describe the classification of DBMS based upon location of database. Illustrate out the term functional dependency. Provide examples. Also describe 1st, 2nd and 3rd normal Forms.
Make a table student with attributes student roll number, name, total marks and percentage. Do the following operations:
Write down the difference between the random access and sequential access?
What are the various kinds of database end users? Explain the major activities of each.
Write down the SQL queries by using Data Manipulation Language (DML) statements. Make the payroll database considering table employee.