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 41 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
Gracias!

cpetit11

  • Member
  • Posts: 321
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

The average adult has about 21 square feet of skin.

DNA analysis of phylogenetic relationships among modern and extinct flightless birds by Cooper and c DNA analysis of phylogenetic relationships among modern and extinct flightless birds by Cooper and c
Organisms exhibit a diversity of behaviours, which include (clockwise from upper left), foraging and Organisms exhibit a diversity of behaviours, which include (clockwise from upper left), foraging and
Species currently endangered in Canada include (a) the Burrowing Owl, Athene cunicularia; (b) Taylor Species currently endangered in Canada include (a) the Burrowing Owl, Athene cunicularia; (b) Taylor
Thick filaments are bipolar structures created by the association of many myosin molecules Thick filaments are bipolar structures created by the association of many myosin molecules
Noncoding regions include all the 5′UTR, 3′UTR and other noncoding RNA regions. UTR = ... Noncoding regions include all the 5′UTR, 3′UTR and other noncoding RNA regions. UTR = ...
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Phases of mitosis

For a complete list of videos, visit our video library