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 methodology to this problem? 2. What are the strengths and weaknesses of this methodology in the context of this scenario? 3. Alternatively, how would you implement an SSAD methodology? 4. What are the strengths and weaknesses of this approach in the context of this scenario? 5. Design an ERD for the above scenario. 6. What are your assumptions? 7. What are the legal, ethical and moral implications of your design? 8. Produce a MySQL script to CREATE one of the entities or table designed in question (5) 9. Produce a MySQL script to INSERT data to this table 10. Produce a MySQL script to SELECT data from any chosen table 11. UML- Create a Use Case Diagram for the scenario above 12. What are your assumptions? 13. Create a Class Diagram for the above scenario. 14. Describe any Aggregates, Inheritance or Associations relevant to this model. 15. How could the model produced in (13) be used to describe the core principles of OOAD APIE? 16. Describe the gains of each of this principles when developing a system.