ارغب في معرفه استاتمنت يمكن به ادخال بيانات لجدول فيه علاقه مجموعة لمجموعه
ارغب في تعبئة جدول الكتب
وجزاكم الله كل خيير
Firstly the books table it will contain;
Title – Author ID – Year – ISBN –Publisher ID
Relationships;
Book to Author (many to many)
Book to Publisher (many to one)
Then the Author table it will contain;
Author ID - First name -Last name –Phone number - Street Address – Email
Relationships;
Author to Book (many to many)
Author to Publisher (many to many)
Finally the Publisher table it will contain;
Publisher ID - Publisher name – Phone number -Street Address - Email
Relationships;
Publisher to Book (one to many)
Publisher to Author (many to many)
CREATE TABLE Book
(
ISBN VARCHAR(15) , NOT NULL,
Year VARCHAR(8) ,
Title VARCHAR(40) ,
Author_ID VARCHAR(20),
Publ_ID VARCHAR(20) ,
CONSTRAINT Book_id_pk
PRIMARY KEY(Book_ID),
CONSTRAINT Publ_Book_fk
FOREIGN KEY (Publ_ID)
REFERENCES Publisher(Publ_ID),
CONSTRAINT Author_Book_fk
FOREIGN KEY (Author_ID)
REFERENCES Author(Author_ID)
);
CREATE TABLE Author
(
Author_ID VARCHAR(5) NOT NULL,
First_Name VARCHAR(25) NOT NULL,
Last_Name VARCHAR(25) NOT NULL,
Phone_Number VARCHAR(20),
Street_Address VARCHAR(20),
Email VARCHAR(25),
CONSTRAINT Author_id_pk
PRIMARY KEY(Author_ID)
);
CREATE TABLE Publisher
(
Publ_ID VARCHAR(5) NOT NULL,
Publ_name VARCHAR(25) NOT NULL,
Phone_NUMBER VARCHAR(20),
street_Address VARCHAR(20),
Email VARCHAR(25),
CONSTRAINT Publisher_id_pk
PRIMARY KEY(Publ_ID)
);