Author Question: When referential integrity is in effect you can only enter records in the foreign key side of the ... (Read 92 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?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

For a complete list of videos, visit our video library