Solution-Define the primary keys and foreign keys for tables

Define the primary keys and foreign keys for tables

Assignment Help Programming Languages

Reference no: EM13930405

1.Give a list of hire dates of all employees in the following format. The output contains 3 columns so you'll need to select three

things.

ENAME Hired_On Hire Date
---------- ------------- ------------------------------
KING was hired on Tuesday , November 17, 1981.

BLAKE was hired on Friday , May 01, 1981.

CLARK was hired on Tuesday , June 09, 1981.

JONES was hired on Thursday , April 02, 1981.

MARTIN was hired on Monday , September 28, 1981.

ALLEN was hired on Friday , February 20, 1981.

TURNER was hired on Tuesday , September 08, 1981.

JAMES was hired on Thursday , December 03, 1981.

WARD was hired on Sunday , February 22, 1981.

FORD was hired on Thursday , December 03, 1981.

SMITH was hired on Wednesday, December 17, 1980.

SCOTT was hired on Thursday , December 09, 1982.

ADAMS was hired on Wednesday, January 12, 1983.

MILLER was hired on Saturday , January 23, 1982.

2.Give ordid and description of all products that were ever ordered in quantities of 100 or more.

Q14-Q17 HAVE TO BE COMPLETED in sequence. You also should do all of them on Oracle even though theoretically you can still

complete the problems without Oracle. But you may not get all problems right because you may not be minding integrity rules.

You may need to use multiple SQL statements in sequence in each problem.

Create these two tables with data types as befitting the data you see in the sample data. Do not define the primary key for

each table at this time. Do not insert data at this time either.

Worker

WorkerId LastName FirstName skillID

1001 PARKER AMY K1

1002 SMITH JANE K2

Skill

SkillId descrip HourlyMax ApprovedBy

K1 COMPUTING 50 1002

K2 MANAGEMENT 80 1002

Insert data as shown. You'll need to use multiple DML statements.

Define the following primary keys and foreign keys for these two tables. Use multiple DDL statements for this. Think carefully

about the sequence of SQL statements used here. Submit the SQL statements in the right sequence.

Worker: pk=workerid. Foreign key=skillid, referencing Skill

Skill: pk=skillid. Foreign key=ApprovedBy, referencing worker

Reference no: EM13930405

Questions Cloud

Determine the force p normal to the handle : The coefficient of friction for the threads is 0.20. Determine the force P normal to the handle at D required - 80 mm 100 mmto raise a mass of 500 kg from the position shown and (b) to lower the load from the same position

Accounting software-packages used in australia : The literature review would be on accounting software/packages used in Australia. The research would cover history, development and adoption, the current market size, identify the leaders in the market and what gives them the competitive advantage..

Sample means and variances : The sample mean and variance of this new variable are called y¯ and s2y, respectively. Use the definitions of sample means and variances (in summation notation) to prove the following statements.

How does one measure effectiveness of stress management : How does one measure the effectiveness of a stress management technique for cancer caregivers such as taking time away from the patient? Also, what are the benefits of providing multiple stress management techniques to these stress sufferers, and ..

Define the primary keys and foreign keys for tables : Define the following primary keys and foreign keys for these two tables. Use multiple DDL statements for this

Best-green balance sheet-income statement : a) What effect will predating the sales have on Best-Green's balance sheet, income statement, and statement of cash flows? Be specific about which accounts will be affected and why. b) How will this practice solve the company's problem with the ban..

How could clara incorporate corporate social responsibility : In your view, how could Clara incorporate Corporate Social Responsibility (CSR) into her business and marketing activities? Your answer needs to clearly demonstrate the benefits to her and to the wider community otter doing this

Calculate the moment m : Calculate the moment M which must be applied to the handle of the screw to raise the block - The coefficient of friction for the screw threads is 0.25, and the coefficient of friction for all mating surfaces of the block and wedge is 0.40. Neglect ..

List the steps in the decision-making process : List the steps in the decision-making process. Explain the term bounded rationality. Explain the term suboptimization.

User Account

All Pages

Define the primary keys and foreign keys for tables

Reference no: EM13930405

Reference no: EM13930405

Questions Cloud

Reviews

Write a Review

Programming Languages Questions & Answers

Write a haskell program to calculates a balanced partition

Create an application to run in the amazon ec2 service

Explain the process to develop a web page locally

Write functions

Programming assignment

Write a prolog program using swi proglog

Create a custom application using eclipse

Create a application using the mvc architecture

Develops bespoke solutions for the rubber industry

Design a program that models the worms behavior

Writing a class

Design a program that assigns seats on an airplane

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT