PHP and MySQL Library Tutorial

General
Site Root
Database Home
Conect to MySQL
MySQL_Login.php
nav.php
dump.php

Clean Up resets the
database to contain
a few sensible
records.

Download Tutorial

Database
Create
Drop

Person Table
Create
Drop

Insert
Delete
Update
Search
Date-Search

Row Dump
Better View 
Table View 
Form View

Book Table
Create
Drop

Insert
Delete
Update
Search




Table View 
Form View

Loan Table
Create
Drop

Insert
Delete

Search




Table View

Documentation
Data Requirements
User Interface Design
Entity Relationship Diagrams
Data Flow Diagrams
Data Dictionary
Implementation Notes
Table Designs
Goals, Testing and Appraisal

Note - Create, Drop and Clean Up would be hidden on a real life system.
Contact - nbauers at samphire dot demon dot co dot uk
Copyright © - You may use and reproduce this material in a "not for profit" setting.

Data Requirements

  1. People borrow books.
  2. The people, books and loans are recorded in the database.
  3. Books can not be reserved.
  4. When a book is borrowed, this is recorded in a loan record in the database.
  5. When a book is returned, the loan record is deleted.
  6. To create a loan record, the book and the person must both exist.
  7. A person can be added to the database without making any special checks.
  8. A book can be added to the database without making any special checks.
  9. A person can not be removed from the database if there is a related loan record.
  10. A book can not be deleted from the database if there is a related loan record.
  11. A loan can be removed from the database without any special checks.
  12. People in the database can be viewed.
  13. Books in the database can be viewed.
  14. Books on loan can be viewed along with who borrowed the book.
  15. Books available for loan can be viewed.
  16. Books overdue for return can be viewed along with who borrowed them.