هل العلاقات والمابينج صحيحة لقاعدة البيانات هذه ؟

Author (AuthorId, Name, OtherNames)

Primary Key AuthorId

Book (itemNo, authorId, pubInfo, description, notes, edition, contents , isbn)

Primary Key itemNo

Foreign Key authorId references Author(authorId) ON UPDATE CASCADE, ON DELETE NO ACTION

Video (itemNo, authorId , title, pubInfo, description, notes, Credits, cast, summary, equipment, idNo, audience)

Primary Key itemNo

Sound (itemNo, authorId, title, pubInfo, description, notes, contents, summary, equipment, idNo)

Primary Key itemNo

Foreign Key authorId references Author(authorId) ON UPDATE CASCADE, ON DELETE NO ACTION

E_Journal (itemNo, title, pubInfo, description, notes, frequency, abbrTitle, mainseries, issn)

Primary Key itemNo

Thesis (itemNo, authorId, title, pubInfo, description, notes, callNumber)

Primary Key itemNo

Foreign Key authorId references Author(authorId) ON UPDATE CASCADE, ON DELETE NO ACTION

Online_DB (itemNo, title, pubInfo, description, notes, contents)

Primary Key itemNo

OtherAuthors (authoreId,itemNo)

Primary Key authoreId, itemNo

Foreign Key authorId references Author(authorId) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references Book(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references Thesis(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references E_Journal(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Ph_Item_copy (copyNo, ItemNo, CollectionId, Status)

Primary Key copyNo

Foreign Key itemNo references Video(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references Book(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key Sound references Sound(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Collection (CollectionId, Name, Desc, copyNo)

Primary Key CollectionId

Foreign Key copyNo references ph_item_copy(copyNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Subscription (resNo, copyNo, memNo, dtReservatoinMade, dtReservationExpires, status)

Primary Key SubscriptionId

E_Item_copy (ID, subId, itemNo, locationId)

Primary Key ID

Foreign Key subId references subscription(subId) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references online_DB(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key itemNo references E_journal(itemNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Privilege(ID, CollectionId, Name, Description, Granted, LoanPeriod, MaxRenewals, MaxItems)

Primary Key PrivilegeId

Foreign Key CollectionId references Collection(ID) ON UPDATE CASCADE, ON DELETE NO ACTION

Member_Type (typeNo, privilegeId, name, description)

Primary Key ID

Foreign Key privilegeId references Privilege(ID)

ON UPDATE CASCADE, ON DELETE NO ACTION

Member (id, typeNo, PrivilegeId, pin, name, username, password, dob, homeAddress, homePhone, email, mobile, dateJoined, expDate, status)

Primary Key id

Foreign Key typeNo references MemberType(typeNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Short_loan (resNo, copyNo, memNo, dtReservatoinMade, dtReservationExpires, status)

Primary Key resNo

Foreign Key copyNo references ph_copy_item(copyNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key memId references Member(ID) ON UPDATE CASCADE, ON DELETE NO ACTION

Loan(LoanId, memId, copyNo, dtLoaned, dtReturned, dtDue, numOfRenewals)

Primary Key LoanId

Foreign Key copyNo references ph_copy_item(copyNo) ON UPDATE CASCADE, ON DELETE NO ACTION

Foreign Key memId references Member(ID) ON UPDATE CASCADE, ON DELETE NO ACTION