This topic contains a solution. Click here to go to the answer

Author Question: In Oracle, if the primary key for the job table was client's email, employee's social security ... (Read 86 times)

burchfield96

  • Hero Member
  • *****
  • Posts: 610
In Oracle, if the primary key for the job table was client's email, employee's social
  security number, and job date, the script line defining this concatenated key would be:
  __________.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the script line used to define the foreign key in job table, creating a
  relationship with client table, would be: __________.
 
  Fill in the blanks with correct word



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

EAN94

  • Sr. Member
  • ****
  • Posts: 307
Answer to Question 1

primary key (email, SSN, date)

Answer to Question 2

email char(




burchfield96

  • Member
  • Posts: 610
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


softEldritch

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

 

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

For a complete list of videos, visit our video library