Author Question: When referential integrity is in effect you can only enter records in the foreign key side of the ... (Read 37 times)

Davideckstein7

  • Hero Member
  • *****
  • Posts: 555
When referential integrity is in effect you can only enter records in the foreign key side of the relation if it relates directly to a record in the primary key table.
 
  Indicate whether the statement is true or false

Question 2

When gathering data for a new database what kinds of documents should you look at and why?
 
  What will be an ideal response?



flannelavenger

  • Sr. Member
  • ****
  • Posts: 322
Answer to Question 1

TRUE

Answer to Question 2

You should look at all the documents that are relevant. Forms are important because they are used to gather the data the database will need. Reports can reveal data that must be included in order to create the summaries that the business requires. Procedures and manuals can help understand how the data is acquired and processed and what rules are applied to it. Even memos and quarterly statements can be useful by providing context for the use and purposes of the data to be stored in the database.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

For a complete list of videos, visit our video library