User Account

All Pages

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.

Reviews

Write a Review

Programming Languages Questions & Answers

  Write a procedure make-accumulator

Write a procedure (make-queue) that produces independent first-in-first-out queue objects, using a message-passing style.

  Program to swap values from variables

Given two int variables, firstPlaceWinner and secondPlaceWinner , write some code that swaps their values. Declare any additional variables as necessary.

  Compute and print annual salary of employee

Identify input, process and output to solves each problem. Compute and print the annual salary of employee. suppose the employee receive 6% increase in pay.

  Write a program takes input from a user in the phone

Program takes input from a user in the phone of a phone number, 7 digits plus the hyphen. It then checks whether a user has entered Q to quit, if 0 or 555 are the begging sequence of inputs (if they are the program alerts the user to an error with..

  Using a software program to create story books

submit a unit plan spanning Two to Four weeks. See this example of a unit plan, (or search the web for a unit plan example that best suits matches your needs). Technology should be integrated for assessment, instruction, and student engagement..

  Describe function work for array-based stack

Return number of items in stack. Describe how this function would work for array-based stack and what would change for pointer-based stack.

  Develop a simple rentalcarcompany program for a rental car

Develop a simple RentalCarCompany program for a Rental Car Company, call it whatever you like. We will have two classes, a Car class and aRentalCarCompany class

  Create the logic for a program that accepts an annual salary

Create the logic for a program that accepts an annual salary as input pass the salary to a method that calculate the highest monthly housing payment the user can afford assuming that the year's total payment is no more than 25 percent of the annua..

  Express javascript code that called to validate text-field

Write a JavaScript function to validate a text-field on a form that is to hold an email address.

  Technique of multiplexed switching of analogue signals

Explain briefly from what you notice about the digital output values in (a) why a digital output value of an A/D converter is rarely the exact same digital value as the analogue input value.

  Problem related to reading file and doing averege

First the program must read a text file (The user must be able to write the name of the text file) , the text file contains the following: the expenses the company is going to spend. Text file example: Keywords:, #best_project_ever, Expenses:, Equi..

  Weka answer in the file i upload and do the best this

answer in the file i upload and do the best. this assignment would need use weka on last question. please follow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd