<commit_before>
## My One to One relationship

![Schema](https://github.com/brianbier/phase_0/blob/master/week_8/images/Screen%20Shot%202016-01-29%20at%2011.22.20%20AM.png "My Schema")

A One-to-One relationship means that you have two tables that have a relationship, but that relationship only exists in such a way that any given row from Table A can have at most one matching row in Table B. The schema above is a very simple explanation. A person in the table Person can have only one drivers license but they can also not have a drivers license. The drivers licenses table will hold a license for each person who has one and it will not create one for those who do not have one. A drivers license does not exist without a person. Also, when creating the child table drivers license it will not have its own unique id, you will have to assign it the persons table id as its foreign key.

## My Many to Many relationship
![Schema](https://github.com/brianbier/phase_0/blob/master/week_8/images/Screen%20Shot%202016-01-29%20at%2011.22.20%20AM.png "My Schema")<commit_msg>Include correct image for many to many relationship<commit_after>
## My One to One relationship

![Schema](https://github.com/brianbier/phase_0/blob/master/week_8/images/Screen%20Shot%202016-01-29%20at%2011.22.20%20AM.png "My Schema")

A One-to-One relationship means that you have two tables that have a relationship, but that relationship only exists in such a way that any given row from Table A can have at most one matching row in Table B. The schema above is a very simple explanation. A person in the table Person can have only one drivers license but they can also not have a drivers license. The drivers licenses table will hold a license for each person who has one and it will not create one for those who do not have one. A drivers license does not exist without a person. Also, when creating the child table drivers license it will not have its own unique id, you will have to assign it the persons table id as its foreign key.

## My Many to Many relationship
![Schema](https://github.com/brianbier/phase_0/blob/master/week_8/images/many_to_many_relationship.png "My Schema")
{'fraction_non_alphanumeric': 0.06429232192414432, 'fraction_numerical': 0.03700277520814061, 'mean_word_length': 4.546153846153846, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 4, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2095214', 'n_tokens_mistral': 616, 'n_tokens_neox': 572, 'n_words': 308}