Jump to ContentJump to Main Navigation
The Feminine Public SphereMiddle-Class Women in Civic Life in Scotland, C.1870–1914$

Megan Smitley

Print publication date: 2009

Print ISBN-13: 9780719079665

Published to Manchester Scholarship Online: July 2012

DOI: 10.7228/manchester/9780719079665.001.0001

Show Summary Details
Page of

PRINTED FROM MANCHESTER SCHOLARSHIP ONLINE (www.manchester.universitypressscholarship.com). (c) Copyright Manchester University Press, 2017. All Rights Reserved. Under the terms of the licence agreement, an individual user may print out a PDF of a single chapter of a monograph in MSO for personal use (for details see http://www.manchester.universitypressscholarship.com/page/privacy-policy). Subscriber: null; date: 26 February 2017

(p.139) Appendix 2 Database schema

(p.139) Appendix 2 Database schema

Source:
The Feminine Public Sphere
Publisher:
Manchester University Press

Schema requirements

This system stores the details of female membership to several women’s organisations active in late nineteenth-century Scotland. Each member may have a title, forename, initial and surname as well as a date of birth. This information is uneven, and many members may not have a complete set of these data. Members may have an address which includes street number, street, city and year(s) of known residence. While many members will not be linked to an address, members may be linked to different addresses in different years, and more than one member may share an address. Each member belongs to one or more organisations, and their membership to the same or different organisations may be spread over several – not necessarily contiguous – years. Each organisation has a name, location (e.g. Edinburgh or Glasgow), departments, committees and officers. Each organisation is likely to be active at multiple locations. The database should store the date different departments were started. Members may have roles on departments and as officers. A member may hold several positions in different organisations during the same or different years. Information on members and organisations comes from minutes books, annual reports and periodicals. These records may be stored at a museum, archive or library. Records have a title, authoring organisation, location and reference determined by the institution holding the record.

Entity-relationship diagram

The following entity-relationship diagram indicates the relationships linking the tables in the database schema. (p.140)

Appendix 2 Database schema

Figure 1: Entity-relationship diagram

Relational schema

Table: A relational schema indicating the tables and their attributes as implemented in the database schema.

ADDRESS

ADDRESSID

HOUSENUM-NAME

STREET

CITY

POSTCODE

DEPT

DEPTID

DEPT NAME

ORGID?#

START-YEAR

ENDYEAR

DEPTLEADER

MEMID#

DEPTID#

START-YEAR

ENDYEAR

MEMBER

MEMID

TITLE

FNAME

MNAME

SNAME

YOB

YOD

OFFICE

OFFICEID

OFFICENAME

OFFICEHOLDER

MEMID#

OFFICEID#

ORGID#

START YEAR

END YEAR

ORG

ORGID

ORGNAME

ORGMEM

ORGID#

MEMID#

START YEAR

END YEAR

ORGRECORD

RECID

ORGID#

TITLE

START YEAR

END YEAR

LOCATION

LOCARIONREF

RESIDENCE

MEMID#

STARTYEAR

ENDYEAR