Coffee and Code: Introduction to Database Design

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

In this session, we are going to dig a little deeper into databases as representions of systems and processes. A database with a single table may not feel or function much differently from a spreadsheet. Much of the benefit of using databases results from designing them as models of complex systems in ways that spreadsheets just can't do:

  • Inventory control and billing
  • Human resources
  • Blogging platforms
  • Ecosystems

There will be some more advanced SQL statements this time, though we will still be using SQLite. Concepts which will be discussed and implemented in our code include

  • Entities and attributes
  • Keys
  • Relationships
  • Normalization
Authoring Person(s) Name: 
Karl Benedict
Authoring Organization(s) Name: 
University of New Mexico Research Data Services
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons Attribution 4.0 International - CC BY 4.0
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
English
More info about
Keywords - short phrases describing what the learning resource is about: 
Data access
Data archiving
Data backup
Python
Structured Query Language (SQL)
Published / Broadcast: 
Friday, November 9, 2018
Publisher - organization credited with publishing or broadcasting the learning resource: 
University of New Mexico Research Data Services
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Presentation - representation of the particular way in which an author shows, describes or explains one or more concepts, e.g., a set of Powerpoint slides.
Contact Person(s): 
Karl Benedict
Contact Organization(s): 
University of New Mexico Research Data Services
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Learning Activity - guided or unguided activity engaged in by a learner to acquire skills, concepts, or knowledge that may or may not be defined by a lesson. Examples: data exercises, data recipes.
Target Audience - intended audience for which the learning resource was created: 
Graduate student
Undergraduate student
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 hour (but less than 1 day)