Unfamiliar with Databases?
Think of a relational database as a collection of spreadsheets which share common meaning, without duplicating data, and have a comprehensive
set of rules defining types of data, data formats, and who can access it.
SQL Server is a modern relational database server developed by Microsoft.
- Allow users to store, sort, and filter data.
- Framework for 'regulating' data. (rules, constraints, defaults, permissions)
- Facilitates sharing data between offices(labs), locations, and applications.
Typical Case
- Multiple data formats in a single file.
- Hundreds or thousands (or more) of files.
- Files in John's directory, Jane's directory, Prof's directory.
- Duplicate data? Different versions of data? How can you tell?
A Case for the Database
| S-1 |
A |
B |
C |
1 |
2 |
3 |
| S-2 |
D |
E |
F |
4 |
5 |
6 |
| S-3 |
G |
H |
I |
7 |
8 |
9 |
