Note that:
+ You could use only SQL Server, SQL Server Management Studio, and paper or offline document in your computer.
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the sql file which has the following database diagram. Please, run the provided script to create tables and insert data into your database.
Loans
LoanID
MemberID
LoanDate
DueDate
Loan Details
LoanDetailID
LoanID
CopyID
ReturnDate
BookCopies
CopyID
BookID
8
Books
BookID
Title
AuthorID
Members
MemberID
MemberName
Address
Email
Sex
BirthDate
Authors
AuthorID
AuthorName
Country
Sex
YearOfBirth
8
Publication Year
ISBN
GenrelD
8
Genres
9 GenrelD
GenreName
Zoom
+ 100%
Close
