Question: Which constraint is would be useful in this table? Foreign key (SalesRepPhone) referencesSalesRepAddrs SalesRepName VARCHAR(20) UNIQUE SalesRepGender CHAR CHECK(SalesRepGndr IN('M','F')) Primary key ( SalesID ,SalesRepName)

Which constraint is would be useful in this table?

  1. Foreign key (SalesRepPhone) references SalesRepAddrs
  2. SalesRepName VARCHAR(20) UNIQUE
  3. SalesRepGender CHAR CHECK(SalesRepGndr IN('M','F'))
  4. Primary key (SalesID, SalesRepName)

Please state the number and explain the answer.

SalesID

SalesRepName

SalesRepGndr

SalesRepPhone

AS0001

Anna Smith

F

0404040404

SF1021

Sam Fox

M

0444000444


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 operating system typically provides each process with the illusion that it runs in a contiguous piece of memory. State the problem of external fragmentation in memory where processes have...

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:

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

Q:

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

Q:

(1) Install MySQL in your computer. You may select to install XAMPP instead. XAMPP contains a package of server software, including MariaDB, which can be considered as the same as MySQL in this...

Q:

Your task is to create a database trigger in your database schema to maintain the data integrity in "PARTS" and "ITEMS" tables. Specifically, the following business rules need to be applied: Language...

Q:

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Q:

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE PhysicianSpecialties (SpecialtyID integer, SpecialtyName varchar(50),...

Q:

Step ladie creatki Create a new database and execute the code below in SQL Server's query window to create the database tables. CREATE TABLE PhysicianSpecialties. (Specialtvik integer, Specialty Name...

Q:

Step 1: Lapte creation Create a new database and execute the code below in SQL Server's query window to create the database tables. CREATE TABLE PhysicianSpecialties. (Spesialt in integer,...

Q:

An investment of $1,230 has the following expected cash returns: Year Net Cash Flow 1 $800 2 200 3 400 Calculate the internal rate of return for this project.

Q:

Eric and Susan just purchased their first home, which cost $136,000. They purchased a homeowner's policy to insure the home for $126,000 and personal property for $78,000. They declined any coverage...

Q:

A carved - out production payment in money is considered as a loan from both the perspective of the oil and gas company and the lender. True False

Q:

There are two distinct lines passing through (-3/2, -3) that are tangent to the parabola y !! a? + 4x + 7. Find an equation of the line with the larger slope.

Q:

A line L is tangent to the curve y = x4 - z at the point P(s, t). If L also passes through (0, -3) and (1, 8), then s is (a) 1 (b) -1 (c) -1/2 (d) 2 (e) none of these

Q:

Suppose that f is a function with f'(2) = -5. If u is very very close to 0, then f(2 + u) is approzimately (a) f(2) 5+ u (b) f(2) + 5u () f(2) -5- () f(2) 5 (e) none of these

Q:

Suppose that f'(0) = -1 =f(0). Then f(t3 + 2t2 t - 2) +3 lim is t+1 t2 1 (a) 3 (b) 2 (c) -1 (d) impossible to determine without additional information (e) none of these

Q:

Choose the best option from the following (V=-v= lim VI - 2 00 () -2 (b) 2 (c) -o (d) 1 (e) none of these

Q:

A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and D are 50 kg, 40 kg and...

Q:

What are the main similarities and differences between conceptual database modeling techniques and knowledge representation techniques?

Q:

How does clustering differ from classification?

Q:

What are the parallel implementations of join?

Q:

d. What was learned from this exercise that can be applied in real-life group situations?

Q:

e. (Optional) What effect did the controversial subject have on the ability to paraphrase?

Q:

4. Each member is asked to talk about the best thing that happened this week. One member starts by telling the person to the right in the group the best thing that happened. The second person...