Database Systems

about this Project...

Introduction –

Year 2 Database Systems module at university – two-part project.

For ‘ArchipelagoCrazy’, I designed a CONCEPTUAL ERD and crafted a data dictionary for their diverse adventures.
With ‘SoundStuff’, I translated a conceptual model into a LOGICAL ERD, executed specific SQL queries, and compared relational and NoSQL databases. This experience honed my database design and analytical skills.

Mark Awarded –

96 / 100 – High First Class

Project Specification –

Skills Developed –

UML Proficiency: Designed robust relational database schemas using UML notations, adhering to specific naming conventions.
Relational Database Design: Translated conceptual data models into logical entity relationship diagrams (ERDs) to represent interconnected tables.
SQL Mastery:
- Produced SQL statements to create and populate logically connected database tables.
- Crafted intricate SQL queries to retrieve, aggregate, update, and delete data across multiple tables.
Data Dictionary Creation: Documented entities, relationships, attributes, and primary keys, ensuring clarity and consistency in database design.
Comparative Analysis:
- Conducted a detailed comparative analysis between relational databases and NoSQL databases.
- Evaluated schemas, data consistency, storage, performance, workload, infrastructures, and security to provide informed guidance for business decisions.
Research & Referencing: Adhered to university guidelines for referencing, ensuring academic integrity in the comparative analysis.
Problem Solving: Interpreted complex business requirements from textual descriptions, extracting relevant information to produce accurate database designs.
Interactive Engagement: Participated in interactive FAQs to refine database designs and gain deeper insights into business requirements.

Outstanding work. The design and transition between the conceptual ERD for 'ArchipelagoCrazy' and the logical ERD for 'SoundStuff' was particularly impressive. Your SQL implementations were precise, showcasing a high level of mastery. The depth of your comparative analysis between relational and NoSQL databases was thorough and well-researched, and your commitment to academic integrity via adherence to referencing guidelines was evident. Your ability to extract and interpret complex business requirements speaks volumes about your analytical skills. Excellent participation in interactive sessions; it's a well-deserved 96/100. Keep up the great work!