Question: CREATE TABLE Staff ( staffNo varchar ( 1 0 ) PRIMARY KEY, FName nvarchar ( 2 0 ) , LName nvarchar ( 2 0 )

CREATE TABLE Staff (
staffNo varchar(10) PRIMARY KEY,
FName nvarchar(20),
LName nvarchar(20),
position varchar(15),
gender char(1),
DOB datetime,
salary numeric(8,2),
branchNo varchar(10),
FOREIGN KEY (branchNo) REFERENCES Branch(branchNo)-- Referenced column specified here
);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!

Q:

CREATE TABLE Staff ( staffNo VARCHAR ( 5 ) PRIMARY KEY, lName VARCHAR ( 1 5 ) , branchNo VARCHAR ( 5 ) , salary DECIMAL ( 7 , 2 ) ) ; INSERT INTO Staff VALUES ( ' SC 1 3 ' , 'Smith', ' B 0 0 3 ' , 1...

Q:

Question 1: Triggers and Stored Procedures: Download the file named assignment4_database.sql from D2L. Run the file from MySQL workbench, putty or Terminal. If using Metrostate login via Putty or...

Q:

Modify the PLAYERS table, change id from a limit of 3 to a limit of 5. (Will use an Alter Statement) RENAME the TEAMS table to WS_TEAMS2014 and add a COMMENT to the table to indicate Teams are World...

Q:

Solve this query with SQL skills. Create a list of players who weigh less than 210 pounds, who are not pitchers, and who play for the Giants. -------- REM Script: Baseball Teams and Players REM...

Q:

Solve this query with SQL skills. Question: Create a list of all the Kansas City players whose last name start with C, and who are in-fielders. ------------------------ REM Script: Baseball Teams and...

Q:

Solve this query with SQL skills. Return all baseball players who are infielders and outfielders who play for San Francisco born before 01/01/1985. -------- REM Script: Baseball Teams and Players REM...

Q:

can you solve this ? I got some error from this query. Advanced SQL ... Continuation 1. SELECT LName, FName, AGE, ACCTNO, CASE CSTATUS WHEN 'S' THEN 'Single' WHEN 'M' THEN 'Married' END AS STATUS...

Q:

QUESTION 5 (10 marks) Write SELECT statements that implement the following queries. (1) (2) 3) (4) Find the first and the last names of all drivers who are not on leave. (1 mark) Find the...

Q:

NEED ANSWER FOR QUESTION 6 ASAP page 2: QUESTION 5 (10 marks) Write SELECT statements that implement the following queries. (1) (2) (3) Find the first and the last names of all drivers who are not on...

Q:

The problem As a Database Administrator (DBA), you have been provided with the following account detailing the access security criteria for a SQL database system. The database consists of three...

Q:

What are the functions of packaging?

Q:

L 1. 1. k. f. Following are the 17 UN Sustainable Development Goals (SDGs). Identify the SDG that each example would satisfy. Item Example JetBlue teaches its customers and crews about climate...

Q:

On November 2 5 , Year 4 , an explosion occurred at a Rex Co . plant causing extensive property damage to area buildings. By March 1 0 , Year 5 , claims had been asserted against Rex. Rex s...

Q:

Dell had its management buyout in 2013. Dell, as a private company, acquired EMC, a publicly listed company, for $67 billion; the deal closed in September 2017. What are the synergy benefits and...

Q:

1 Learning from some of the measures taken by Eskom, AECI and Germiston City Council, what could a foreign company like Colgate Palmolive do to contribute to the development of human potential within...

Q:

Achievementascription. Quite often more traditional societies accord status according to ascription. Again, this may influence recruitment and promotion policies that may be at variance with...

Q:

Indian managers at both middle and senior levels in organizations profess a belief in group-based, participative decision making, but have little faith in the capacity of workers for taking...