Question: Using SQL statements. Given the following table descriptions, write a sql statement that will generate a foreign key constraint on the sales bid attribute that

Given the following table descriptions, write a sql statement that will generate a foreign key constraint on  Using SQL statements.

Given the following table descriptions, write a sql statement that will generate a foreign key constraint on the sales bid attribute that references the books bid attribute. MariaDB [ugc1201]> desc books; Field | Type | Null | Key | Default | Extra | | int(10) | YES 1 bid title | varchar (10) | YES | author | varchar(15) | YES subject | varchar(10) | YES 4 rows in set (0.006 sec) MariaDB [ugc1201]> desc sales; Field | Type sid | int (10) | YES | bid | int(10) | YES price | int (10) int (10) | YES 3 rows in set (0.006 sec) NULL NULL NULL NULL Null | Key | Default | Extra | NULL NULL NULL

Step by Step Solution

★★★★★

3.32 Rating (143 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Syntax ALTER TABLE ADD CONSTRAIN... View full answer

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:

A children?s beanbag game is set up as follows: Two children toss beanbags at the board as shown. They hit the board with a probability of 1/2 and score a 0 for a miss. When they hit the board, they...

Q:

How will the new operations fit with the firms global strategy? How will you manage the entry mode? Provide rationale for managing the entry mode Some questions I wanted to be covered: ? What is the...

Q:

a) Find the set of solutions of each of the linear congruence: i. 8x = 12 (mod 28). ii. 7x = 1 (mod 9). b) Hashing Function is used to assign a memory location for the records in the computer (For...

Q:

As of November 2019, Tom served as the design and execution engineer at PAIBEAM Company, responsible for designing a 6-story residential building. The architectural design included five residential...

Q:

can you help me with final entity list and thier relations base on these instruction a SQL database Problem (requirements): Wannacureu Medical Clinic has a need for a database to store data on their...

Q:

Write a query to find each customer who has an account at every branch located in Brooklyn Consider the bank database schema given below, where the primary keys are underlined. Write the SQL DDL...

Q:

Hi i need a help with this question please For the question: make sure to report the SQL code for each and every exercise, thank you! You are given the following table, representing authorship of...

Q:

You are given the following table, representing authorship of books: 1 CREATE TABLE A BID VARCHAR (40) NOT NULL, AID VARCHAR(40) NOT NULL, CONSTRAINT PK PRIMARY KEY (BID, AID) ); Attribute BID...

Q:

Indemnities 4 ya llsjunk Insurance Company has a need for a database to store data on their customers, the policies of which their customers have purchased, the agents their customers have purchased...

Q:

You are given the following table, representing authorship of books: CREATE TABLE AC BID VARCHAR(40) NOT NULL, AID VARCHAR(40) NOT NULL, CONSTRAINT PK PRIMARY KEY (BID, AID) ); Attribute BID...

Q:

2 Use the results from part 1 to allocate costs from each of the three cost centers to both the general landscaping and the custom design landscaping units Compute total cost and average cost per...

Q:

Kline Manufacturing Company uses a worksheet in preparing financial statements. The following accounts are included in the adjusted trial balance: Finished Goods Inventory $28,000, Work in Process...

Q:

Evaluate 7 x - 9 x 2 - 9 d x Select one: a . 5 l n | x 3 | - 1 2 l n | x - 3 | C b . 5 l n | x 3 | - 2 l n | x - 3 | C c . 5 l n | x 3 | | 2 l n | x - 3 | c | d . 5 l n | x 3 | 2 l n | x - 3 | c

Q:

Europium is a lanthanide element found at parts per billion levels in natural waters. It can be measured from the intensity of orange light emitted when a solution is illuminated with ultraviolet...

Q:

Show that for all a > 0 and all k such that 0 k-1 k a'

Q:

Use the ideal-gas air Table A.7 to evaluate the heat capacity Cp at 300 K as a slope of the curve h(T) by h/T. How much larger is it at 1000 K and at 1500 K?

Q:

What are the disadvantages of the standard deviation as a measure of risk?

Q:

A quasar 10 billion light-years from Earth appears the same brightness as a star 50,000 light-years away. How do the power outputs of quasar and star compare?

Q:

CPA Kara Rambo is the auditor of Ajax Corporation. Her audit independence will not be considered impaired if she Has a sister who is the financial vice president of Ajax.Owns $1,000 worth of Ajax...

Q:

What are PHP auto-global variables? Give some examples of PHP autoglobal arrays, and discuss how each is typically used.

Q:

Algorithm 17.1 outlines the procedure for searching a nondense multilevel primary index to retrieve a file record. Adapt the algorithm for each of the following cases: a. A multilevel secondary index...

Q:

Describe the workings of the JobTracker and TaskTracker in MapReduce.

Q:

What price should Vencap offer for the investment opportunity described in Problem 1 if it requires a 17% return on investment? In Problem 1 Vencap Enterprises is evaluating an investment opportunity...

Q:

Wildcat Drilling Contractors Inc. is considering the acquisition of a new deep-drilling rig at a cost of $12 million. With this added drilling capability, the companys net operating profits would...

Q:

A college can purchase a telephone system for $30,000 or lease a system for five years for a front-end charge of $3000 and regular payments of $1500 at the beginning of every quarter (including the...