Question: I posted this cod in my SQL and keep getting error: Create Table Specialty ( SpecialtyNumber Char(10) Not Null, SpecialtyNameChar (50) Not Null, CONSTRAINT pk_sn

I posted this cod in my SQL and keep getting error: Create Table Specialty ( 

SpecialtyNumber Char(10) Not Null, 

SpecialtyNameChar (50) Not Null, 

CONSTRAINT pk_sn PRIMARY KEY (SpecialtyName), 

CONSTRAINT uq_sn Unique (SpecialtyNumber) 

); 

My  code is: 

Create Table Specialty ( 

SpecialtyNumber Char(10) Not Null, 

SpecialtyNameChar (50) Not Null, 

CONSTRAINT pk_sn PRIMARY KEY (SpecialtyName), 

CONSTRAINT uq_sn Unique (SpecialtyNumber) 

); 

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:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

Assignment 5: Hash Table implementation andconcordance There are three parts to this assignment. In the first two parts,you will complete the implementation of a hash map and aconcordance program. In...

Q:

TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...

Q:

Here is a incomplete pos server program, receiving input from posclient, inserting traction detail data into sql database. create a database Client Server Program Search TMA02 in POSServer.java, to...

Q:

Feel free to edit the code below to answer questions 1-13 Please note for question 2-8 , this the error message am getting (20:52:54 INSERT INTO PROJECT VALUES('ProductA', 4, 'Bellaire', 2) Error...

Q:

I keep getting an error trying to create a database. Please see below: CREATE TABLE MOVIE( MOVIE_ID VARCHAR(100), DIRECTOR VARCHAR(100) NOT NULL, NAME VARCHAR(100) UNIQUE NOT NULL, TYPE CHAR(1) CHECK...

Q:

I posted this code in my Sql and keep getting error (5: Unexpected token: DATABASE in statement [create database]) create database mydatabase; create table book( iSBN_number int primary key, title...

Q:

I need help with this SQL I keep getting error the information is not found. These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the...

Q:

I need some help. I have exported the regions table out of access to sql but keep getting the error code Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match...

Q:

Below is code for creating a canvas of falling, bouncing particles (balls), when mouse is dragged over canvas. I have learned the following about collision detection: Point is inside circle: If...

Q:

P (A1) 5 .20, P (A2) 5 .40, P (A3) 5 .40, P (B1A1) 5 .25, P(B1A2) 5 .05, and P(B1A3) 5 .10. Use Bayes theorem to determine P (A3B1).

Q:

Changing Times sells 185,000 bottles of TempeTingler nail polish each year. The product, which is very popular with teens, sells for $13 per bottle, and variable cost per unit is $5.50. Total annual...

Q:

Discuss the definition and the source of agency problem between shareholders and managers.

Q:

Seawater containing 3.50 wt % salts passes through a series of 10 evaporators. Roughly equal quantities of water are vaporized in each of the 10 units and then condensed and combined to obtain a...

Q:

Air is heated from 25C to 150C prior to entering a combustion furnace. The change in specific enthalpy associated with this transition is 3640 J/mol. The flow rate of air at the heater outlet is...

Q:

One thousand kilograms per hour of a mixture containing equal parts by mass of methanol and water is distilled. Product streams leave the top and the bottom of the distillation column. The flow rate...

Q:

A variation of the indicator dilution method (see preceding problem) is used to measure total blood volume. A known amount of a tracer is injected into the bloodstream and disperses uniformly...

Q:

If a system expands in volume by an amount V (m 3 ) against a constant restraining pressure P(N/m 2 ), a quantity PV(J) of energy is transferred as expansion work from the system to its surroundings....

Q:

Despite the various countries of origin of Hispanic Americans, this subcultural group is often considered by some people as a single market based on _ _ _ _ _ _ _ _ . Question 2 6 options: A )...

Q:

Add a new method in AbstractGraph to find a cycle in the graph with the following header: public List getACycle(int u); The method returns a List that contains all the vertices in a cycle starting...

Q:

Section 22.10.2 introduced Graham?s algorithm for finding a convex hull for a set of points. Assume that the Java?s coordinate system is used for the points. Implement the algorithm using the...

Q:

Design a class named MyInteger. The class contains: An int data field named value that stores the int value represented by this object. A constructor that creates a MyInteger object for the...

Q:

What are the main benefits of JIT/lean? Name a company using JIT/lean, and describe how JIT/lean contributes to the company *s competitive advantage.

Q:

Is tire service system of WestJet JIT/lean?

Q:

What is value stream mapping and why is it important?