Database Design and SQL

1. The BookStor database containing the Authors table:
BookStor database



2. The Project Management database - version 1
Project Management version 1



3. The Project Management database - version 2 (with Master/Detail format)
There is some data included.
Project Management version 2



In Access 97 format:
Project Management 97 ver. 1



Project Management 97 ver. 2

MySQL area     

To download MySQL samples, save the .zip file in folder C:/mysql/data and extract the files there.

Every MySQL database is represented as a folder in mysql/data. To copy a database all you have to do is copy the folder, always making sure it is located in mysql/data .

The Bids Management database (see Lesson 5)
Extract and install the bidsmgt folder in mysql/data
Bids management



The Editor database (see Lesson 7)
Extract and install the Editor folder in mysql/data
The Editor project

---