<commit_before>---
year: inf3
semester: 1
credits: 20
archived: false
title: DBS -	Database Systems
course-acronym: dbs
links:
  - name: info
    url: http://course.inf.ed.ac.uk/dbs
---

- **EXAM in December diet**
- [Official exam papers and solutions - 2005 to 2010](https://www.dropbox.com/sh/qqd05o7mw7watz7/eF0YYWcI9X?v=1swn)
- Unofficial/Official solutions to past papers can be found in the drive! 
- Questions and answers from the DBS textbook - [link](http://pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/solutions/ans3ed-oddonly.pdf)
<!--- NEED TO UPDATE THE DOCUMENTS [Unofficial solutions - 2011 & 2012](http://docs.google.com/document/d/1Ir_z-F6uWDXmYVomfJdL1hlsWfgbPW8c0gx6bHmTHxo/edit)
[May 2013](https://docs.google.com/document/d/188xL9h_Gs4vBvYiTsBbDMLR66GZBKQqxz9R1Nf0rx1I/edit?usp=sharing)
[August 2013 resit](https://docs.google.com/document/d/1rzK29pfwig18WOvdQmh131nR2Hhqtj5tFI5Qu1hMgaI/edit?usp=sharing)
[May 2014](https://docs.google.com/document/d/1H_kUYAsc1XaDT6BSHiUk69SWi-ydGWjCTPgh1YzwzNA/edit?usp=sharing)
[August 2014 resit](https://docs.google.com/document/d/1dlCLqABcEtYYxMtrtlj7QPXJdjXMDsw_dmfXqTP3fiI/edit?usp=sharing)  --->
<commit_msg>Add new link to dbs.md<commit_after>---
year: inf3
semester: 1
credits: 20
archived: false
title: DBS -	Database Systems
course-acronym: dbs
links:
  - name: info
    url: http://course.inf.ed.ac.uk/dbs
---

- **EXAM in December diet**
- [Official exam papers and solutions - 2005 to 2010](https://www.dropbox.com/sh/qqd05o7mw7watz7/eF0YYWcI9X?v=1swn)
- Unofficial/Official solutions to past papers can be found in the drive! 
- Questions and answers from the DBS textbook - [link](http://pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/solutions/ans3ed-oddonly.pdf)
- [Normal Form checker (both BCNF and 3NF)](http://raymondcho.net/RelationalDatabaseTools/RelationalDatabaseTools)
<!--- NEED TO UPDATE THE DOCUMENTS [Unofficial solutions - 2011 & 2012](http://docs.google.com/document/d/1Ir_z-F6uWDXmYVomfJdL1hlsWfgbPW8c0gx6bHmTHxo/edit)
[May 2013](https://docs.google.com/document/d/188xL9h_Gs4vBvYiTsBbDMLR66GZBKQqxz9R1Nf0rx1I/edit?usp=sharing)
[August 2013 resit](https://docs.google.com/document/d/1rzK29pfwig18WOvdQmh131nR2Hhqtj5tFI5Qu1hMgaI/edit?usp=sharing)
[May 2014](https://docs.google.com/document/d/1H_kUYAsc1XaDT6BSHiUk69SWi-ydGWjCTPgh1YzwzNA/edit?usp=sharing)
[August 2014 resit](https://docs.google.com/document/d/1dlCLqABcEtYYxMtrtlj7QPXJdjXMDsw_dmfXqTP3fiI/edit?usp=sharing)  --->

{'fraction_non_alphanumeric': 0.13397901533494755, 'fraction_numerical': 0.06739305891848264, 'mean_word_length': 5.422279792746114, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 10, 'lorem ipsum': 0, 'www.': 2, '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': '1317590', 'n_tokens_mistral': 1209, 'n_tokens_neox': 1044, 'n_words': 151}