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 42 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
YES! Correct, THANKS for helping me on my review

Jossy

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

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

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

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
Cultures Ideal Body Types Cultures Ideal Body Types
The disaccharides sucrose, maltose, and lactose are created from the monosaccharides The disaccharides sucrose, maltose, and lactose are created from the monosaccharides
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 = ...
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Individuals from highly divergent lines created by artificial selection Individuals from highly divergent lines created by artificial selection
Video: Introduction to Photolithography - WC, BLF, PA, Hard and Soft baking

For a complete list of videos, visit our video library