☑Kizspy.me
•
Zoom
Category: Contains information about Category of book. A category can
contain many books, a book belongs to only one catalog (1-n).
BookLoanSlip: Contains information about book loan slip. A BookLoanSlip
can have many books, a book belongs to only one BookLoanSlip (1-n).
•
Reader: Contains information about Reader.
2. (2 points) Using the ERD from question 1, write SQL statements to create the
BookLoanSlip table for tracks the history of book borrowing and returning.
a) The table should include the maximum possible data constraints (primary key,
foreign key).
b) The Purpose column should only accept "At reading room" or "At home",
with "At home" as the default.
c) Insert three appropriate data rows into the newly created table.
d) Other tables are already available in the provided SQL file
|
3. (2 points) Write a stored procedure Sp_AddBorrowHistory to record the borrowing
history of book. If the book is in the status "Borrowed", borrowing is not allowed.
+ 100%
THD
11. the bak
Close
