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

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

For a complete list of videos, visit our video library