Data Mining

Differentiate between the following terms: A. Independent data mart and dependant data mart B. Fact table and dimension table C. OLTP and OLAP Chapter 7 1. Differentiate between the following terms: A. Validation data and test set data B. Positive correlation and negative correlation C. Control group and experi ...continues

Relational schema and set of dependancy

Write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions and create new entities and attributes as necessary. I have attached a jpg of the table and problem I'm having trouble with number 9.

If you WERE to build a database for the data below, what would the ERD look like?

If you WERE to build a database for the data attached, what would the ERD look like? See attached file for full problem description.

What are the differences between how an application developer views a database vs.a database administrator or a data modeller?

What are the differences between how an application developer views a database vs.a database administrator or a data modeller?

Should we keep full copies of our production environment into the development and test databases?

I think we can grasp the need for why development and test databases are necessary. Should we keep full copies of our production environment into the development and test databases? Or do you create development and test data? What are some of the advantages and disadvantages to both?

Create the keys and relationships between tables for the Driver LOG

Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.

Designing a database

It is important to know the type of computer for running the database in order to ensure that the configurations of the computer are not too obsolete for the database to perform efficiently and properly. It is important for organizations to keep their hardware resources updated in order to maximize the usage of database manageme ...continues

Create the keys and relationships between tables

Using MS Access, I need to create the keys and relationships between the tables for the Driver LOG attached.

SSN as a Primary Key

If you were working on an EXISTING database that uses SSN as a Primary Key, what are some of the challenges you might face to add a new Primary Key?

Does anyone have any ideas of where flat-files are still used and why?

As far as flat-files go I think they really do have a place in some applications still. There are a couple of industries that rely on them heavily I am sure. Does any OTA's have any idea of where flat-files are still used and why?