DATABASE COURS

Select a software application and select one module of that application Create the scenarios of using that module and determine the semantics of the information needed to be stored Create the ER diagram for the module (refine the relations if needed) including any integrity constraints Write the SQL queries that create the designed module.

Let us do about ( LIBRARY- BOOK MANAGEMENT DATABASE-> BORROWED BOOKS )

Menu: 1. Add a Book with the following details: a. Book ID b. Book Title c. Book Subject d. Book Publisher e. Book Status f. Author 2. Member Registration with the following details: a. Member ID b. First Name c. Last Name d. Member Status 3. New Borrow with the following details: a. Book Name b. Borrow Data c. Return Date d. Member Related to this Book e. Status (Borrowed/Returned) 4. Return the Book with the following details: a. Book Name b. Book ID c. Return Date d. Days of Late Return Check e. Fine (if any, in $)

5. Book Borrow Report:

Library Book Database : Database (Access 2007 - 2010) - Microsoft Access Database Tools