Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table knjiga(
- sifra varchar(50) primary key,
- isbn varchar(15),
- naziv varchar(50) not null,
- godina smallint not null check(godina>=1970 and godina<=2050),
- izdavac varchar(10) references izdavac on delete restrict on update cascade
- );
- create table autor(
- sifra varchar(10) primary key,
- ime varchar(20) not null,
- prezime varchar(20) not null
- );
- create table autor_knjige(
- knjiga varchar(10) references knjiga,
- autor varchar(10) references autor,
- primary key(knjiga,autor)
- );
- create table clan(
- sifra varchar(10) primary key,
- ime varchar(20) not null,
- prezime varchar(20) not null,
- adresa varchar(50) not null
- );
- create table posudba(
- clan varchar(10) references clan,
- datum_posudbe date,
- datum_vracanja date,
- knjiga varchar(10) references knjiga,
- primary key(clan,datum_posudbe,knjiga)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement