Author Question: When referential integrity is in effect you can enter anything you want on the foreign key side of ... (Read 150 times)

WWatsford · **on:** Jul 7, 2018

When referential integrity is in effect you can enter anything you want on the foreign key side of the relation.

Indicate whether the statement is true or false

Question 2

What are the main differences between a transaction database and a management information system?

What will be an ideal response?

kusterl · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

FALSE

Answer to Question 2

A transaction database is optimized to handle as many transactions as necessary in real time. That means its primary concern is processing speed. A management information system is optimized for running queries and creating summaries that are useful to business managers. A management information system does not have to be as fast as a transaction database. Often the management information system uses the data copied from a transaction database, since the reports typically don't have to be accurate to the current moment.