[HW 3.4B] Understanding a Database Schema Chart

mysql-sample-database

 

Using the above picture of a database schema, please answer the following questions:

1. How many tables are there?
2. What is the primary key of the products table?
3. What is the longest primary key?
4. What is the primary key of the order details table?
5. Explain what the crows foot means which is on the dotted line between the customers table and the orders table means.
6. How many different data types are shown on this schema?
7. What is meant by the red diamond on the employees table next to “officeCode”?
8. What is the difference between the blue diamonds and the white diamonds?
9. What’s the difference between a solid line that connects tables and a dotted one?

Source:
http://www.mysqltutorial.org/mysql-sample-database.aspx

 

Advertisements

2 comments

  1. any suggestions on how we can figure out what the white diamond is? I’ve tried googling but cant seem to find any information on it

    Liked by 1 person

    1. I asked that question because I didn’t know the answer. I was hoping YOU would tell ME.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: