Question: CREATE TABLE SALESREP ( table [ [ SalesRepNo , int,NOT NULL, ] , [ RepName , char ( 3 5 ) , NOT NULL,

CREATE TABLE SALESREP (
\table[[SalesRepNo,int,NOT NULL,],[RepName,char(35),NOT NULL,],[HireDate,date,NOT NULL,]]
CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo), CONSTRAINT SalesRepAK1 UNIQUE (RepName));
We know that
RepName is the primary key
RepName is a foreign key
RepName can be a primary key
the value of SalesRepNo is not unique
CREATE TABLE SALESREP ( \table[[SalesRepNo,int,NOT NULL,],[RepName,char(35),NOT NULL,],[HireDate,date,NOT NULL,]] CONSTRAINT SalesRepPK PRIMARY

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:

The SQL keyword MODIFY is used to change the structure, properties or constraints of a table. True False Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would...

Q:

PER THIS QUERY /* 1 =================================================================*/ CREATE TABLE EMPLOYEE ( FNAME CHAR (20) NOT NULL, MINIT CHAR (20) NOT NULL, LNAME CHAR (20) NOT NULL, SSN INT...

Q:

question? Create a view called product_info with columns pid, descr, revcnt, rating, rating6, and salecnt. The view includes for each product the product id, the description, the number of reviews,...

Q:

As in Quiz10, assume we have this database: CREATE TABLE 'country' ( 'Code' CHAR (3) NOT NULL DEFAULT" 'Name' CHAR (52) NOT NULL DEFAULT", CECS 535: Introduction to Database Fall 2023, Homework 5...

Q:

DROP TABLE IF EXISTS enrolled DROP TABLE IF EXISTS achedule DROP TABLE IF EXISTS Class DROP TABLE IF EXISTS atudent: DROP TABLE IF EXISTS professori DROP TABLE IFEXISTS majora DROP TABLE IF EXISTS...

Q:

1 . What is a Distributed Database? 2 . What are the advantages of using a Distributed Database? 3 . What are the types of Distributed Databases? 4 . What is Data Replication in Distributed...

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:

How do I fix this error? SQLQueryl.sql - o...UNT z1606988 (57)) X Create Table Units UnitNo Int Char(25) Numeric(5) Numeric(1) Numeric(1) Char (3) UnitNoPK BuildingNameFK Not Null IDENTITY (1,1) Not...

Q:

What is the correct order to CREATE the tables? Think about referential integrity. a . Owner, Pet Appointments, Treatment, Treatment _ Appt b . Pet, Treatment, Appointments, Owner, Ttreatment _ appt...

Q:

Create the SQL code for each of the tables. Below I have attached an attempt of the SQL code for the first table but I keep getting errors. Could you fix that and provide the revisisd code....

Q:

Superior Micro Products uses the weighted average method in its process costing system. The data from the Assembly Department for the month of May is shown below: Materials Labor overhead Work in...

Q:

The following email message contains numerous errors related to what youve learned about planning and writing business messages. Using the information it contains, write a more effective version. TO:...

Q:

On 1 2 / 3 1 / 1 1 , Hoover Company erroneously credited accounts payable ( Debit Cash; Credit Accounts Payable ) for a transfer of funds between two bank accounts that resulted in an overstatement...

Q:

QUESTION 17 bond. Abond that pays a variable amount of coupon interest over time is called a a. Zero-coupon Ob. Floating rate : O c. Junk. O d. Municipal Oe. Treasury. QUESTION 18 Which of the...

Q:

13-4 What are alternative methods for building information systems?

Q:

1. Review the discussion of business processes in Chapter 2 and Chapter 13 and the Chapter 14 discussion of IT project management and implementation. Be prepared to talk about any systems development...

Q:

13-1 How does building new systems produce organizational change?