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

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

For a complete list of videos, visit our video library