Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Critically discuss in detail about the objects of Access database. Write down the steps which are involved in the modifying the fields in a table.
Define the tern distributed database. Distinguish between distributed and parallel databases. As well illustrate some merits of distributed databases.
Write down the Apriori algorithm for discovering frequent item sets for the mining Boolean association rules.
Explain OLAP operations in the multidimensional data models.
Describe the various strategies for data reduction throughout the data pre-processing?
What do you mean by shadow page recovery scheme? Explain how does it compare and contrast with the log-based recovery methods in terms of ease of implementation and overhead costs?
Write down the relational algebra expression for the given:
Write down the fundamental operations in the Relational Algebra? Describe different joins in relational algebra with the help of appropriate illustrations.
Describe the recoverable and cascadeless schedules with the help of an illustration.
Describe the difference between dimensional data modeling and relational data modeling.
Describe the term Normalization in data warehouse. List all its merits.
Describe how the system development life cycle for data warehouse is just opposite to the classical SDLC.
Explain Floating horizon algorithm for the hidden surface removal. Illustrate the merits and demerits of the Floating horizon algorithm.
Write down the name of four hidden-surface algorithms.
Describe the different concurrency control measures which are used in DBMS.
The account holder can enquire regarding the balance in his account. Draw the ER Diagram for the bank.
Describe the different levels of abstraction in the DBMS with the help of a diagram. Explain why do we require mappings between various schema levels?
Describe the main steps of Extraction Transformation and Loading process (ETL).
Describe the Basic Concepts and Output Knowledge Representation of Data categorization.
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.