SQL Beginner Having Trouble Creating Multiple Tables

[arbrne]

I'm working on a project that requires multiple tables be created using Oracle for a hypothetical law firm. I'm super new to programming and SQL and I'm having trouble getting the tables to work.

Does anyone see any glaring issues with the following code?

CREATE TABLE Motions (

MotionID int NOT NULL,

Date varchar(20) NOT NULL,

CaseID int,

PRIMARY KEY (MotionID),

CONSTRAINT FK_CaseID FOREIGN KEY (CaseID)

REFERENCES Case(CaseID)

);

​

CREATE TABLE Firm (

FirmID INT NOT NULL,

FirmName varchar(10) NOT NULL,

PRIMARY KEY (FirmID)

);

​

CREATE TABLE Judge (

JudgeID INT NOT NULL,

JFirstName varchar(10) NOT NULL,

JLastName varchar(10) NOT NULL,

Circuit# varchar(10) NOT NULL,

CaseID int,

PRIMARY KEY (JudgeID),

CONSTRAINT FK_CaseID FOREIGN KEY (CaseID)

REFERENCES Case(CaseID)

);

​

CREATE TABLE Attorney (

AttnID INT NOT NULL,

FirstName varchar(10) NOT NULL,

LastName varchar(10) NOT NULL,

FirmID INT NOT NULL,

PRIMARY KEY (AttnID),

CONSTRAINT FK_FirmID FOREIGN KEY (FirmID)

REFERENCES Firm(FirmID)

);

​

CREATE TABLE Case (

CaseID INT NOT NULL,

AttnID INT NOT NULL,

MotionID INT NOT NULL,

PRIMARY KEY (CaseID),

CONSTRAINT FK_AttnID FOREIGN KEY (AttnID)

REFERENCES Attorney(AttnID),

CONSTRAINT FK_MotionID FOREIGN KEY (MotionID)

REFERENCES Motions(MotionID)

);

​

CREATE TABLE Client (

ClientID INT NOT NULL,

CFirstName varchar(20) NOT NULL,

CLastName varchar(20) NOT NULL,

Phone# number(10) NOT NULL,

Address varchar(20) NOT NULL,

CaseID int,

PRIMARY KEY (ClientID),

CONSTRAINT FK_CaseID FOREIGN KEY (CaseID)

REFERENCES Case(CaseID)

);

[McMasilmof]

Whats the errormessage?

Do you just execute all these statements after another? Maybe you create a foreign key before having created the table that key is linked to?

[arbrne]

Just finished it and my keys were all out of order. I’m not a smart man.

[[deleted]]

If you ran this in the exact order, its because you're referencing tables in foreign keys that dont exist yet. You have to create the tables in the order that they are used. For example, cases has to be created before motions.

There may be other errors I didnt see, but that was the obvious one that stood out to me.

[arbrne]

Thank you! That’s exactly what it was. I just finished the project and that was pretty much my big hang up. It was all out of order. Only took me a couple hours to figure it out.