Difference between revisions of "CaseStudy:Designing Memento databases:Photographic equipment"

From Memento Database Wiki
Jump to navigation Jump to search
Line 35: Line 35:
[[Category: CaseStudy]]

Latest revision as of 08:48, 30 April 2021

Case Study: An initial photographic equipment database

In this study, we set out to create a barebones design & implementation of a database for a photographic equipment inventory for an amateur photographer or for a solo or very small professional photographic enterprise.
Our idea is to design a barebones but extensible database that will initially consist of a single library and will be able to grow to support several interrelated, linked libraries.


Before we begin, let's ensure we have an agreed understanding of the terminology we'll use in this study. In Memento, our terminology varies from other DBMS disciplines, notably relational DBMSes (or RDBMSes). The following table shows the equivalencies between them:

Memento Relational Definition
Database Database A generic term meaning the base of all interrelated data regarding a person's pursuit, an application, or a subject area.
Library Table Entries & fields or rows & columns of data
Field Field (or Column) A typed data item occupying a position within a library or table
Entry Record
(or row)
An instance or occurrence of data across fields or columns
Entry name Primary key The field or ordered set of fields (Column or ordered set of columns) that identify an entry or record
Link to entry SQL The means by which libraries or tables are related to each other

Requirements (the need)
Design considerations
Initial camera/lens/filter&hood, flash, tripod, bag/strap
See the 5 email attachments