☑Kizspy.me
Zoom
•
•
•
Entities Description
Book: Contains information about book, with each piece of book having a
unique identifier and related details.
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
+100%
Close
