Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLZ help with the following : Using the integrity enhancement features of SQL, please add the following constraints: Create the foreign keys for this database

PLZ help with the following :

  1. Using the integrity enhancement features of SQL, please add the following constraints:

    1. Create the foreign keys for this database and any missing primary keys.

    2. PTNG_PRICE values in PAINTING table must be greater than 100$ and less than a

      10000$

    3. No two titles with the same names in PAINTING table

sql file

CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8), GAL_RATE number ); INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37); INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 ); INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67); INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30);

/* -- */

CREATE TABLE PAINTER ( PTR_NUM char(4), PTR_LASTNAME varchar(15) NOT NULL, PTR_FIRSTNAME varchar(15) NOT NULL, PTR_AREACODE char(3), PTR_PHONE char(8) ); INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567'); INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112'); INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456');

/* -- */

CREATE TABLE PAINTING ( PTNG_NUM char(4), PTNG_TITLE varchar(35), PTNG_PRICE number, PTR_NUM char(4), GAL_NUM char(4) ); INSERT INTO PAINTING VALUES('1338','Dawn Thunder',245.5,'123','5'); INSERT INTO PAINTING VALUES('1339','A Faded Rose',6723,'123','1'); INSERT INTO PAINTING VALUES('1340','The Founders',567.99,'126','6'); INSERT INTO PAINTING VALUES('1341','Hasty Pudding Exit',145.5,'123',''); INSERT INTO PAINTING VALUES('1342','Plastic Paradise',8328.99,'126','6'); INSERT INTO PAINTING VALUES('1343','Roamin''',785,'127','6'); INSERT INTO PAINTING VALUES('1344','Wild Waters',999,'127','5'); INSERT INTO PAINTING VALUES('1345','Stuff ''n Such ''n Some',9800,'123','5');

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions

Question

Describe the purpose of ratio analysis.

Answered: 1 week ago

Question

What is a board of directors?

Answered: 1 week ago