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

Themember4 · **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

anyusername12131 · **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