Cemetery Prototype Database :: Database

This prototype database was designed to meet the general needs of users from a bleed of incompatible backgrounds in relation to cemeteries and graveyards. The scenario is described as follows A pool of world-wide archaeological and historical societies has collaborated in funding a multidisciplinary database of international historical graveyards whose history goes back at least 100 years. As the database leave behind be used for research as well as town-planning by a wide variety of people, including historians, local councils, genealogists, sociologists and epidemiologists, it is anticipated that it testament include not only information about the graveyards themselves, but as well as the buildings, individual gravestones and the records of people buried there. Emphasis addedKey words and phrases (highlighted) were used to check up on the appropriate entities and their attributes, and to help determine the kinds of queries that might be useful for make out stakeholde rs.This database will serve a diverse range users, each with different needs. Prior to constructing this database, I created a list of questions that I suspected whitethorn cede been of interest to a given stakeholder, and then ensured that my database could answer them. I have listed a sample of these questions in Appendix I and have provided relevant queries to demonstrate the usefulness of the database.EntitiesFrom the scenario described above, I have situated that the following main entities are the most appropriate for a relational database cemeteries, burial plots, burial records, monuments, buildings, and inscriptions. Each main entity and its significant attributes will be described below however, a full list of attributes can be found in the appendix.Cemeteries and graveyardsEach necropolis or graveyard will exist in the database as a distinct entity, and all another(prenominal) entities can be traced back to their relevant cemetery. Curl (1999) defines a cemetery as a burial ground, especially a large landscaped leafy vegetable or ground laid out expressly for the deposition or interment of the dead, not being a churchyard attached to a push through of worship.Accordingly, a cemetery is not simply a place containing a dead body or bodies, but a delimit location particularally intended to be used for burying the dead. time Curl attempts to distinguish a cemetery from a churchyard, my database takes a broader onrush and includes all formal burial places (graveyards in general), including those associated with churchyards, burial mounds, and war memorials.As noted by Rugg (2000), cemeteries also provide the ability of users to locate a specific grave .