Question: What would be an SQL Script to add a new table to this Schema for Employee Background with a one to one relationship with the

What would be an SQL Script to add a new table to this Schema for Employee Background with a one to one relationship with the employee table. Add whichever fields are needed to this table, but be sure to include a primary key and if needed a foreign key. You do not need to enter data into this table. Please include one field named with your initials in it.

regions REGION_ID REGION NAME departments DEPARTMENT_ID DEPART NAME MANAGER ID LOCATION ID job_history EMPLO

regions REGION_ID REGION NAME departments DEPARTMENT_ID DEPART NAME MANAGER ID LOCATION ID job_history EMPLO E ID START_DATE END DATE JOB ID DEPARTMENT_ID NUMBER VARCHAR2(25) NUMBER VARCHAR2(30) NUMBER NUMBER NUMBER DATE DATE VARCHAR2(10) NUMBER 00 countries COUNTRY_ID CHAR(2) COUNTRY_NAME VARCHAR2(40) REGION ID NUMBER o employees EMPLOYEE ID FIRST NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB_ID SALARY COMMISSION_PCT MANAGER ID DEPARTMENT_ID NUMBER VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) DATE VARCHAR2(10) NUMBER NUMBER NUMBER NUMBER 00 locations LOCATION ID STREET ADDRESS POSTAL CODE CITY STATE PROVINCE COUNTRY_ID jobs NUMBER VARCHAR2(25) VARCHAR2(12) VARCHAR2(30) VARCHAR2(12) CHAR(2) JOB ID JOB TITLE MIN_SALARY NUMBER MAX_SALARY NUMBER VARCHAR2(10) VARCHAR2(35)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE TABLE Employee Background Employee BackgroundID int PRIMARY KEY AUTO INCREMENT EmployeeID int FOREIGN KEY REFERENCES Employees EmployeeID TSInitials VARCHAR 20 NOT NULL BackgroundCheckDate DATE ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Suppose we're currently in the middle of some unspecified sporting season and each of a set of n teams have some number of wins and losses (w; and li) accumulated in their played games so far....

Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...

You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...

Jake, a single taxpayer, has $100,000 of ordinary income, a $10,000 net short-term capital loss, and $7,000 of qualified dividends. What is the result?

Describe how flexible-budget variance analysis can be used in the control of costs of activity areas?

=+representation of employee interests to the main board of directors or other central decision-making body?

Use the Body Fat data set with Density as the response variable and Age, Height, Neck, Chest, Abdomen, Thigh, Ankle, Biceps, and Forearm as the explanatory variables to answer the following: (a) Fit...

Refer to problem S6.16. If the defective rate was 3.5 % instead of 1.5%, what would be the control limits (z = 3)? In problem S6.16, In the past, the defective rate for your product has been 1.5%....

The cost of goods sold budget integrates the direct materials purchases budget, direct labor cost budget, and factory overhead cost budget. Estimated and desired inventories for direct materials,...

On April 1, Cyclone Company purchases a trencher for $308,000. The machine is expected to last five years and have a salvage value of $54,000. Compute depreciation expense at December 31 for both the...

Which of the following are examples of a Central Bank? a. The Federal Reserve Bank b. The European Central Bank c. The Bank of England d. The Peoples Bank of China e. All of the above are Central...

3 7. JL. Industries Corp. is experiencing rapid growth. Dividends are expected to grow at 30 percent per year during the next three years, 18 percent over the following year, and then 8 percent per...

YOUR GM HAS CALLED YOU INTO THE OFFICE AND SHARED WITH YOU THAT YOUR HOUSEKEEPING AAA INSPECTION SCORE HAS FALLEN 5 POINTS BECAUSE OF CONSISTENCY ISSUES IN SERVICE AND THE HOTEL IS IN JEOPARDY OF...

Follow these steps for this discussion board: 1-Find an example of a business committing a tort (news article, law website, etc.). This could be from a court case or it may have been handled...

BlackBerry is dedicated to addressing the most important environmental issues facing the technology sector, fostering equality for all people, and having a positive influence on our local...

Lower-than-expected demand for Apple's new iPhones and the company's decision to offer more models have created turmoil along its supply chain and made it harder for Apple to predict the number of...

at 8 Dancing 5. EFN [LO2] The most recent financial statements for Assouad, Inc., are shown here: Income Statement Balance Sheet Sales $7.900 Current assets $ 3,900 Current liabilities $ 2,100 Costs...

A survey of 70 college freshmen asked whether students planned to take biology, chemistry, or physics during their first year. Use the diagram to answer each question. How many of the surveyed...

Write the SQL command to revoke user Stetsons privilege.

What are permissions? Explain the relationship between permissions and work groups.

What is context-sensitive help?

What is self-confidence? How is it related to expectations?

Describe five components that need to be considered when implementing an imagery training program.

describe the latest research on and theory of goal setting,