What are data warehousing and data mining

Assignment Help Database Management System

Reference no: EM133498633

Problem: DBMS Components

Question A. Explain the main differences between a file processing system and a database system.

Question B. What is a DBMS? Briefly describe the components of a DBMS.

Question C. Describe a primary key, candidate key, secondary key, foreign key, and common field.

Question D. What are entity-relationship diagrams and how are they used? What symbol is used to represent an entity in an ERD? What symbol is used for a relationship? What is cardinality, and what symbols do you use in the crow's foot notation method?

Question E. What are data warehousing and data mining? Are the terms related?

Question F. What is the criterion for a table design to be in first normal form? How do you convert an unnormalized design to 1NF?

Question G. What are the criteria for a table design to be in second normal form? How do you convert a 1NF design to 2NF?

Question H. What are the criteria for a table design to be in third normal form? How do you convert a 2NF design to 3NF?

Question I. Explain the difference between a logical record and a physical record.

Question J. How would a specific date, such as September 1, 2011, be represented as an absolute date?

Reference no: EM133498633

Questions Cloud

Creating a matrix allows the policy analyst to view : analyzing possible policy alternatives and selecting what criteria will be necessary to give your client your best advice to answering their problem

What were the signs the experience was not going well : Reflect upon a time you had a negative recruiting/ hiring experience. What were the signs the experience was not going well?

How creating an inclusive working culture : How creating an inclusive working culture which encourages belonging can support improvements to increase employee commitment and performance

Discuss how much innovation should be done : Make this post a recommendation on the pluses and minuses of leveraging external innovation using three examples. Lastly, discuss how much innovation should be

What are data warehousing and data mining : Explain the main differences between a file processing system and a database system. What are data warehousing and data mining?

How a past personal and professional experience : How a past personal and professional experience would make you a quality candidate for CHILD DEVELOPMENT ASSOCIATE position

What are some of your long term investment goals : What are some of your long term investment goals? Should you be investing for the long term or short term? What is your investment horizon (# years) for

What you found interesting in writing about guest speakers : Discuss what you have learned this semester. What you found interesting in writing about the guest speakers in your GreenTalk assignments?

What can be the canadian healthcare system : What lessons can be learned from the Canadian healthcare system?

User Account

All Pages