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

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

For a complete list of videos, visit our video library