Computer Science

Family Tree Database

EER modelling · normalization · MySQL · SQL Server

Period

2024 / Database project

Role

Requirements, EER modelling, normalization and SQL implementation

Status

Repository available

Project premise

The project turns an intuitive but complicated human network into explicit, queryable relationships.

A normalized relational model for family relationships, education, employment, addresses, marriages and life events.

Model

EER + Relational schema

Platforms

MySQL + Microsoft SQL Server

Schema

13 tables

Query set

20 example operations

Focus

Cardinality + Normalization

Deliverables

Create / Insert / Query / Drop

Selected project material