Problem with no matching unique or primary key

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Problem with no matching unique or primary key

Author

Topic

ana_jj
Starting Member

6 Posts

Posted - 2012-05-27 : 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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-27 : 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/

ana_jj
Starting Member

6 Posts

Posted - 2012-05-27 : 13:47:58

Thank you very much!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-27 : 13:57:12

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources