Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
How is association rules mined from large databases? Write Apriori algorithm to discover all frequent itemsets from large databases.
Describe two types of Priority Queue and the operations performed on them. Give two advantages and two disadvantages of a Linked List over an Array.
Describe knowledge discovery in databases process. Bring out the block diagram of KDD process and explain the components of KDD process. Describe generalized Bayes decision model. Describe decision t
Describe the features and advantages of SANCopy as a Data Migration Tool. Describe the different logs used in MirrorView.
How can you store the XML data in relational databases using tree representation? Describe. How the various geometric constructs can be represented in a database in a normalized fashion?
With essential examples, define the following: Super Key and Primary Key. How the EER diagram can be reduced to relations? Describe.
Data replication is an important mechanism commonly employed in a distributed database environment. Replication provides a number of benefits in terms of enhanced system performance.
an overloaded constructor with three parameters to assign values to the humidity, air_pressure, atmospheric_temperature.
Describe briefly the three components of a Client/Server Architecture, and use a fully labelled diagram to show the interaction between the components.
Air Mauritius Ltd publishes a weekly flight log report, which tracks each aircraft and the number of hours which were flown by an individual pilot in each aircraft.
Suppose that for each query, you could create up to two index structures to make the query faster. What index structures would you create, and how would this change the evaluation plans and running
What are the main differences between primary key and foreign key? Describe it in detail with the help of appropriate examples. Define logical database model. What are its types? Describe it in detail
How are relationships between tables expressed in relational database?
What do you understand by Primary Key and Foreign Key? Describe with example. What is Normalization? Why it is essential?
Create database schema for the tables given below using the CREATE TABLE command.
List the First Name, Last Name and telephone number of all employees who were appointed in the year 1995. List all details of employee who is not managed by any employee.
Draw Entity-Relationship model for the relational schema given in Appendix. Show all the entities, relationships names, relationship, and attributes and also underline the primary key for each and e
Write the SQL code that will create ALL the tables as given in the appendix. Your answer should not contain the primary key and foreign key constraint declaration.
Describe centralized and client server database architectures. Describe transaction server system in detail. Compare and contrast speedup and scaleup.
Explain Query Processor and Storage manager components of DBMS. Describe advantages and disadvantages of DBMS approach.
Objective of this project is to develop complete data centric application. Representing the requirements into logical design using Entity Relationship (ER) or/and Enhanced Entity Relationship (EER) mo
Distinguish between Single Attribute and Multivalued Attribute.
What do you understand by Decomposition of Relation Scheme? Distinguish between Weak Entity and Strong Entity with appropriate example.
State rules to convert E-R diagram into tables. Explain different File Organisations and describe Heap File Organisation in detail.
Define deadlock? How deadlock can be managed? Describe the problems why DBMS bypass OS buffer manager and manage the disk & main memory.