Course Solutions Uncategorized (Solved) : Create Table Customers Customerid Char 5 Null Companyname Varchar2 40 Null Contactname Var Q30652683 . . . .

(Solved) : Create Table Customers Customerid Char 5 Null Companyname Varchar2 40 Null Contactname Var Q30652683 . . . .

June 27, 2024June 27, 2024| adminadmin| 0 Comment| 8:17 pm
Categories:

 

CREATE TABLE Customers

(

CustomerID CHAR(5) NOT NULL,

CompanyName VARCHAR2(40) NOT NULL,

ContactName VARCHAR2(30),

ContactTitle VARCHAR2(30),

Address VARCHAR2(60),

City VARCHAR2(15),

Region VARCHAR2(15),

PostalCode VARCHAR2(10),

Country VARCHAR2(15),

Phone VARCHAR2(24),

CONSTRAINT PK_Customers

PRIMARY KEY (CustomerID)

)

/

I have provided SQL code to create all tables and insertall data. There is an error in setting referential integrity: oneof the tables is missing references. Read the code and identify theproblem. You can either modify create table statement or add altertable statement to include missing references.

Expert Answer

An answer will be send to you shortly. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Solved) : Need Brief Answers Four Security Concerns Must Distributed Operating System Accommodate De Q26176482 . . . .(Solved) : Need Brief Answers Four Security Concerns Must Distributed Operating System Accommodate De Q26176482 . . . .

<p>I need very brief answers:</p><p>What four security concerns must a distributed operating systemaccommodate?</p><p>Define <em>principal</em> in the context of access controllists.</p><p>How is a public key distributed to agents on a network?</p><p>What

Read MoreRead More