Well i have this homework and i dont know where to start i have to create a database called tBooks that is linked to tAuthors but using this code.
create table tBooks
(
BookID counter constraint tBook_PK primary key,
AuthorID int,
Title CHAR(30) NOT NULL,
PubDate DATE NOT NULL,
Notes CHAR(50),
Category INT NOT NULL,
constraint FKBooksAuthID FOREIGN KEY (AuthorID) References tAuthors
)
My problem is where do i put this code LOL do i put it somewhere into access or some kind of text file or what?
Thanks for you help
create table tBooks
(
BookID counter constraint tBook_PK primary key,
AuthorID int,
Title CHAR(30) NOT NULL,
PubDate DATE NOT NULL,
Notes CHAR(50),
Category INT NOT NULL,
constraint FKBooksAuthID FOREIGN KEY (AuthorID) References tAuthors
)
My problem is where do i put this code LOL do i put it somewhere into access or some kind of text file or what?
Thanks for you help