Introduction to Databases for Museums (Joseph Davis MSc.)
Channel: EXARC
Date: 27/03/2020

Do you want to participate in the conference question and answer session? Join our discord server at https://discord.gg/gygBMzK

*** Due to unforeseen technical difficulties we were unable to provide you with subtitles in the presentation. We apologise for the omission.***

Abstract: As an archaeologist and ICT specialist, Joseph Davis will give a presentation about this subject. This talk assumes no previous database experience, and is not dependent upon any specific database software. It is designed for complete beginners who may need to create databases for their own projects. 

Are you not a database developer? Have to build a database anyway? This talk will cover the fundamentals of relational databases, such as: What is a relational database, and how does it differ from a flat file (spreadsheet, CSV)? What is a primary key, and what is a foreign key? How does database normalization protect data integrity?

By the end of this talk, you should be able to look at your spreadsheets or other flat data and understand how to uniquely identify each row, what data should be broken out into a table of its own, and how to relate the tables to one another using primary keys and foreign keys.
#EXARCBerlin #ExperimentalArchaeology #conference