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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!