Page 2 - How do I Use Compass Database Organization

How do I Use Compass Database Organization

Shear Styles uses two additional tables in its database containing information related to the Pet Table.
These are the

• Customer Table
• Appointment Information Table.

Customer Table
Owner Name Address Phone Pet Name

Watkins, George 1378 First Street, Livermore 925-838-2367 Duke

Strudler, Ari 48 Juniper Court, San Ramon 925-583-9074 Agnes

Hayes, William 96 Sprint Street, Pleasanton 925-893-0621 Scout

Appointment Information Table
Appt. Date Pet Name Owner Name Shampoo Cut Types Perfume Fleas

5/21/16 Duke Watkins, George Coat and Tail Trim No No

3/14/16 Agnes Strudler, Ari Burts Bees’ Classic No No

4/24/16 Scout Hayes, William Earthbath Fluff n Buff No No

You can easily retrieve information from different tables in a relational database, in the combination of
your choice, using key fields.

Key

Page 2 of 5

Emory Confidential and Proprietary Last Revised on 4/13/2017 Return to Table of Contents