Subject Name: Systems Design and Development COMP-1430

Scenario:

An Archaeological group investigated locations in the Southeast of England for Artifacts. During the excavation, several artifacts were identified dating back to the Palaeolithic, Neolithic, Bronze and Iron ages. The group would like to keep a record of specific locations where artifacts were found, photos and description of artifacts.

Questions: 1. How would you implement a Flat File (flat database) methodology to this problem? 2. What are the strengths and weaknesses of this methodology (flat database) in the context of this scenario? 3. Alternatively, how would you implement an SSAD (relational database) methodology? 4. What are the strengths and weaknesses of this approach (relational database) in the context of this scenario?