Question

6. Code a statement that assigns the value “Test” to a scalar variable named (can not insert the at sign, but it should be here)Name that’s declared with the varchar data type.

8. A parameter passes a value from the calling program to the stored procedure, unless you code the ______________________________ keyword.

9. Unless a database system supports declarative referential integrity, the only way to enforce referential integrity is to use ______________________________.

10. Code a statement that returns the value of a variable named (can not insert the at sign, but it should be here)InvoiceCount from a stored procedure named spInvoiceCount.

Observe the simplified E-R diagram below, write the relationships as you see it.