This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain how relationships are created using SQL. Include an example. What will be an ideal ... (Read 44 times)

Themember4

  • Hero Member
  • *****
  • Posts: 538
on: Jul 7, 2018
Explain how relationships are created using SQL. Include an example.
 
  What will be an ideal response?

Question 2

PHP code is executed on a server and can generate HTML code that is sent to the client computer.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

anyusername12131

  • Sr. Member
  • ****
  • Posts: 327
Reply #1 on: Jul 7, 2018
Answer to Question 1

In SQL, relationships are created using a FOREIGN KEY constraint. This has the format:

CONSTRAINT ConstraintNameFK FOREIGN KEY(ForeignKeyColumnInC urrentTable REFERENCES ReferencedTableName(PrimaryKeyColumnInR eferencedTable)

The constraint thus names the foreign key column in the current table and its corresponding primary key in a referenced table. As an example, consider an advising relationship from STUDENT to FACULTY. The following constraint might appear in the SQL statement creating the STUDENT table:

CONSTRAINT AdvisorFK FOREIGN KEY (AdvisorID) REFERENCES
FACULTY (FacultyID)

Answer to Question 2

TRUE


Themember4

  • Member
  • Posts: 538
Reply 2 on: Jul 7, 2018
Excellent

rachel

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

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?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Key anatomical features of Homo habilis include reduced facial size, a parabolic palate, and some br Key anatomical features of Homo habilis include reduced facial size, a parabolic palate, and some br
Major features of Homo erectus include increased brain size, an angular vault, and cranial superstru Major features of Homo erectus include increased brain size, an angular vault, and cranial superstru
Upper Paleolithic stone tools include blade-based tools as seen here being produced from a blade cor Upper Paleolithic stone tools include blade-based tools as seen here being produced from a blade cor
Scattergrams are a mechanism used by political scientists to show patterns and relationships among v Scattergrams are a mechanism used by political scientists to show patterns and relationships among v
Relationships in Dyads and Triads Relationships in Dyads and Triads
Relationships among Jawed Vertebrates Relationships among Jawed Vertebrates
Video: Mechanisms of capillary exchange (transcytosis & bulk flow)

For a complete list of videos, visit our video library