x = x*3
THE ART GALLERY
Purpose of the Sample Project
The sample project sections included for many of the chapters of this book are intended
to provide models for applying the concepts covered in the chapters. The project is a continuing
Sample Project Chapter 3: Creating the E-R Diagram for The Art Gallery
Step 3.1: Make a list of all entities and their associated attributes.
This may take several attempts, and different designers will arrive at different solutions.
SAMPLE PROJECT Chapter 4: Initial Mapping of the E-R Model to Tables
for The Art Gallery
Step 4.1: Map the E-R model developed at the end of Chapter 3 to relational model,
using the guidelines presented in Section 4.7.
The E-R diagram developed at the end
SAMPLE PROJECT: Planning the Distribution of the Relational Database for The Art Gallery
We will assume The Art Gallery has expanded to three locations, Midtown, which is the original
gallery, plus Uptown and Downtown. We wish to distribute the database a
MySQL PHP Example
CSC 3800 Database Management Systems
Time: 10:00 to 11:15
Meeting Days: MF
Location: Oxendine 1202
Textbook: Databases Illuminated, Author: Catherine M. Ricardo, 2004, Jones & Bartlett Publishers