Odi na moj site i klikni na dvije ikonice koje te upućuju na IBO_Objects i Firebird database.S ovim komponentama i bazom možeš raditi profi programe.Treba ti još IB_Expert za održavanje baze.
Za videoklub ti rebaju ove tabele:
CLANOVI
MEDIJI
ZANROVI
FILMOVI
POSUDBE
Tabele kreiraš ovako (pustiš kroz interactive SQL u IBExpert-u):
CREATE TABLE "CLAN"
(
"ID" INTEGER NOT NULL,
"BROJ_ISKAZNICE" VARCHAR(20) NOT NULL,
"IME" VARCHAR(50) NOT NULL,
"PREZIME" VARCHAR(50) NOT NULL,
"MBG" VARCHAR(13) NOT NULL,
"ADRESA" VARCHAR(50),
"TELEFON" VARCHAR(20),
"MOBITEL" VARCHAR(20),
"NAPOMENA" VARCHAR(200),
"AKTIVAN" VARCHAR(2) default 'DA',
"GODINA_RODJENJA" INTEGER NOT NULL,
UNIQUE ("BROJ_ISKAZNICE"),
UNIQUE ("MBG"),
CONSTRAINT "PK_CLAN" PRIMARY KEY ("ID")
);
CREATE TABLE "MEDIJ"
(
"ID" INTEGER NOT NULL,
"SIFRA" VARCHAR(20) NOT NULL,
"NAZIV" VARCHAR(50) NOT NULL,
"OPIS" VARCHAR(50) NOT NULL,
"AKTIVAN" VARCHAR(2) default 'DA',
UNIQUE ("SIFRA"),
CONSTRAINT "PK_MEDIJ" PRIMARY KEY ("ID")
);
CREATE TABLE "ZANR"
(
"ID" INTEGER NOT NULL,
"SIFRA" VARCHAR(20) NOT NULL,
"NAZIV" VARCHAR(50) NOT NULL,
"OPIS" VARCHAR(50),
"AKTIVAN" VARCHAR(2) default 'DA',
UNIQUE ("SIFRA"),
CONSTRAINT "PK_ZANR" PRIMARY KEY ("ID")
);
CREATE TABLE "FILM"
(
"ID" INTEGER NOT NULL,
"SIFRA" VARCHAR(20) NOT NULL,
"NAZIV_ORGINALA" VARCHAR(50) NOT NULL,
"NAZIV_HRVATSKI" VARCHAR(50) NOT NULL,
"FK_ZANR" INTEGER NOT NULL,
"FK_MEDIJ" INTEGER NOT NULL,
"OPIS" VARCHAR(200),
"AKTIVAN" VARCHAR(2) default 'DA',
"GODINA_SNIMANJA" INTEGER,
UNIQUE ("SIFRA"),
CONSTRAINT "PK_FILM" PRIMARY KEY ("ID")
);
ALTER TABLE "FILM" ADD CONSTRAINT "FK_MEDIJ" FOREIGN KEY ("FK_MEDIJ") REFERENCES MEDIJ ("ID");
ALTER TABLE "FILM" ADD CONSTRAINT "FK_ZANR" FOREIGN KEY ("FK_ZANR") REFERENCES ZANR ("ID");
CREATE TABLE "POSUDBA"
(
"ID" INTEGER NOT NULL,
"DATUM_POSUDBE" DATE NOT NULL,
"FK_FILM" INTEGER NOT NULL,
"FK_CLAN" INTEGER NOT NULL,
"DATUM_VRACANJA" DATE,
"NAPOMENA" VARCHAR(200),
"AKTIVAN" VARCHAR(2) default 'DA',
"KREIRAO" VARCHAR(20),
"IZMJENIO" VARCHAR(20),
"VRIJEME_K" TIMESTAMP,
"VRIJEME_I" TIMESTAMP,
CONSTRAINT "PK_POSUDBA" PRIMARY KEY ("ID")
);
ALTER TABLE "POSUDBA" ADD CONSTRAINT "FK_CLAN_POSUDBA" FOREIGN KEY ("FK_CLAN") REFERENCES CLAN ("ID");
ALTER TABLE "POSUDBA" ADD CONSTRAINT "FK_FILM_POSUDBA" FOREIGN KEY ("FK_FILM") REFERENCES FILM ("ID");
SET TERM ^ ;
[Ovu poruku je menjao escape:: dana 17.06.2006. u 00:00 GMT+1]
escape::