Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Explain the steps involved in generation of CA. Write down at least one serializable and one Non serializable schedule for the transaction.
What is data mining? Describe the features and benefits of data mining in detail.
Explain the Concept of Conventional File Processing with and illustration in detail. Illustrate the pros and cons of it.
Discuss four major threats to database security. For each threat you identify, state at least one solution to that threat.
Discuss the characteristics of an organization for which a data warehouse would be suitable. Aside from huge amounts of money, what resources does an organization need to support a data warehouse or
Draw the ER diagram for the following situation:Real Estate Investment Company owns many shopping malls in different locations across the country.
Identify entities and their relationships. Then create the ERD for a reservation system.Create 3NF table designs for a system.
As a data acquisition specialist, what types of metadata can help you? Select one of the data acquisition processes and explain the role of metadata in that process.
Write down the difference between candidate key and super key. What is data abstraction? Describe the various level of data abstraction.
Describe the concept of CRM? Also describe the role of data warehouse in CRM. Describe the designing concept about relational database and OLAP cubes.
What are the problems and failures which might encounter with respect to the transactions in a database management system? Give illustrations.
What are the management functions of DBMS? What do you understand by relational algebra?
What do you mean by decision trees? How do decision trees work? Describe the CART algorithm.What do you understand by Neural Networks? How it works? How neural network techniques are applied in data m
Describe the best way to measure a data mining tool. Why we use data mining? What kind of information could be obtained from data mining?
Describe data integration and the extraction, transformation, and load (ETL) processes.
Describe relationship between OLAP and data mining. What are some of the major categories of data mining technologies? Explain at least three of them.
Describe the three problems of concurrent transaction in RDBMS with appropriate examples.
Explain the difference between hashing & indexing? What type of data structure might be implemented to support index-based search ensuring fast retrieval of information in a uniform fashion?
Clustering has been popularly recognized as a significant data mining task with broad applications. Give one application illustration for each of the given cases:
Find out all frequent item sets using Apriori and FP-growth, correspondingly. Compare the efficiency of the two mining processes.
With the help of examples describe about the nice domains and ugly domains?
How is a data warehouse distinct from a database? How are they similar?
What is normalization? Describe the advantages of normalization. Describe the first normal Form (1NF), second normal form (2NF) and the third normal form (3NF) with the suitable example.
Explain the role and importance of Database Management System in today’s business environment.
Report the corresponding algebraic expression and specify the cardinality of each node (representing an intermediate result or a leaf). If necessary, assume a data distribution. Analyze also the gro