|
ana_jj
Starting Member
Albania
6 Posts |
 Posted - 05/27/2012 : 13:21:03
|
Here is my problem:
when i'm trying to create this table, i was given the message for no matching unique or primary key>
CREATE TABLE REZERVACII(
PRID VARCHAR2(100) REFERENCES PROIZVODITELI(PRID) NOT NULL,
BUTIKID VARCHAR2(100) REFERENCES BUTICI(BUTIKID) NOT NULL,
OBLID VARCHAR2(100) REFERENCES PARCHINJA_OBLEKA(OBLID) NOT NULL,
DO_KOGA DATE NOT NULL,
KLID VARCHAR2(100) REFERENCES KLIENTI(KLID) NOT NULL,
KUPENO VARCHAR2(100)
CHECK (KUPENO LIKE 'N' OR KUPENO LIKE 'D'),
KUPENO_KOGA DATE,
PRIMARY KEY (PRID, BUTIKID, OBLID, DO_KOGA)
);
these are the previously created tables>
CREATE TABLE "TRGOVSKI_CENTRI"
( "TRCID" VARCHAR2(100),
"TRIME" VARCHAR2(100) NOT NULL ENABLE,
"TGRAD" VARCHAR2(100),
PRIMARY KEY ("TRCID") ENABLE
)
/
CREATE TABLE "BUTICI"
( "BUTIKID" VARCHAR2(100),
"BIME" VARCHAR2(100) NOT NULL ENABLE,
"SOPSTVENIK" VARCHAR2(100),
"WEB" VARCHAR2(100),
"BEMAIL" VARCHAR2(100),
"TRCID" VARCHAR2(100) NOT NULL ENABLE,
PRIMARY KEY ("BUTIKID") ENABLE
)
/
ALTER TABLE "BUTICI" ADD FOREIGN KEY ("TRCID")
REFERENCES "TRGOVSKI_CENTRI" ("TRCID") ENABLE
/
CREATE TABLE "PROIZVODITELI"
( "PRID" VARCHAR2(100),
"PRIME" VARCHAR2(100) NOT NULL ENABLE,
"POTEKLO" VARCHAR2(6) NOT NULL ENABLE,
PRIMARY KEY ("PRID") ENABLE
)
/
CREATE TABLE "PARCHINJA_OBLEKA"
( "PRID" VARCHAR2(100),
"BUTIKID" VARCHAR2(100),
"OBLID" VARCHAR2(100),
"OPIS" VARCHAR2(100) NOT NULL ENABLE,
"CENA" NUMBER(4,0) NOT NULL ENABLE,
"POPUST" NUMBER(4,0) NOT NULL ENABLE,
"ZABELESHKA" VARCHAR2(20),
PRIMARY KEY ("PRID", "BUTIKID", "OBLID") ENABLE
)
/
ALTER TABLE "PARCHINJA_OBLEKA" ADD FOREIGN KEY ("PRID")
REFERENCES "PROIZVODITELI" ("PRID") ENABLE
/
ALTER TABLE "PARCHINJA_OBLEKA" ADD FOREIGN KEY ("BUTIKID")
REFERENCES "BUTICI" ("BUTIKID") ENABLE
/
CREATE TABLE "KLIENTI"
( "KLID" VARCHAR2(100),
"KIME" VARCHAR2(100) NOT NULL ENABLE,
"KTELEFON" VARCHAR2(100),
"KEMAIL" VARCHAR2(100) NOT NULL ENABLE,
"KGRAD" VARCHAR2(100),
CHECK (KEMAIL LIKE '%@%.%') ENABLE,
PRIMARY KEY ("KLID") ENABLE
)
/
Please help me with this, I am studying for my exam.
please tell me where is the problem
|
Edited by - ana_jj on 05/27/2012 13:26:22
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 05/27/2012 : 13:37:24
|
the problem is this i believe
OBLID VARCHAR2(100) REFERENCES PARCHINJA_OBLEKA(OBLID) NOT NULL
the PARCHINJA_OBLEKA has pk only on composite combination of PRIMARY KEY ("PRID", "BUTIKID", "OBLID") ENABLE so it wont guarantee uniqueness of OBLID alone
try creating a unique constraint on it
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
Problem with no matching unique or primary key
