Question: Implement the design for the Bookstore/Library system on MSAccess or on MYSQL. Each Table has to contain at least 5 rows. In other words, you

Implement the design for the Bookstore/Library system on MSAccess or on MYSQL. Each Table has to contain at least 5 rows. In other words, you need to generate random data and each table has to have at least 5 entity instances. Each student is supposed to implement considering only 3 tables. The table assignments is attached. If you use MsAccess you should submit the database file. The database file should include the referential integrity constraints (make sure "Relationships" tab displays all the referential integrity constraints). If you use MySQL, you need to submit the SQL script that both creates the database tables and inserts data into these tables. Hint for MySQL: first create the model, then use "Forward engineer" and create the SQL script that creates the database. Then disable referential integrity constraint checks for the insert into statements. MP6-BookStore3NF tables.pdf BOOKSTORE/LIBRARY MANAGEMENT SYSTEM BOOK_AVAILABILITY Date Number of Available Copies ISBN BOOK ISBN Title Publisher Year Edition Status Location 444 BOOK HISTORY Checkout No ISBN MemberID CheckOutDate ReturnDate IsLate Retum Penalty Fee CHECK OUT CheckOut No ISBN MemberID CheckOutDate DueDate MEMBER Membett FName Middle LName BirthDate Gender Phone No Address PUT_HOLD ISBN Member ID BOOK_AUTHOR ISBN Author
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
