Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
The questions in this exam are based on the Baxter Aviation scenario that you used for the first exam. Please read the following narrative carefully, as many of the rules have changed!
Design two views for the database which you have designed and implemented. One view must be for the University Vice Chancellor who is interested in knowing about performance of students in different
Compare primary, secondary and clustering indexes. Which of these indexes are dense and which are not? What is difference between B tree and B+ tree? Why B+ tree is the better tree structure than B tr
Departmental store maintains inventory of goods about its sections. Each section could sell a number of items. Item sold by one section might be part of other section also. Design appropriate RDBMS