CS340 / INTRODUCTION TO DATABASE SYSTEMS

Every connection.
A stronger
foundation.

Behind every meaningful application is a thoughtfully designed database. Explore how we built Sillah’s data foundation, from the first idea to a connected system.

Explore the project ↗Follow the journey ↓

MODELED WITH PURPOSE. BUILT TO CONNECT.

SILLAH / DATA ARCHITECTUREFIG. 01

⊞ Family member 01

PK member_id INT

FK family_id INT

relationship VARCHAR

⌁ Medical history 02

PK history_id INT

FK member_id INT

condition VARCHAR

SillahRELATIONAL CORE

↗ Risk alert 03

PK alert_id INT

FK member_id INT

Connected by design.
Conceptual architecture

STRUCTURE → INTEGRITY → CONNECTION↗

06Project phases

04Contributors

01Connected system

From conceptual modeling
to full-stack integration.

01 / THE PROCESS

An idea. Six phases.
A complete foundation.

Follow the decisions, diagrams, and code
that bring the database to life.

PHASE 00↗

✳

Start with a purpose.

The team, the problem, and the idea behind a preventive family health platform.

PROPOSAL · TEAM FORMATION

PHASE 01↗

⌘

Make a clear plan.

Define the requirements, map the architecture, and shape the user experience.

REQUIREMENTS · WIREFRAMES

PHASE 02↗

⊞

Connect the dots.

Translate real-world relationships into an enhanced entity–relationship model.

EER MODEL · RELATIONSHIPS

PHASE 03↗

▤

Give data structure.

Build a relational schema with purposeful keys, normalization, and constraints.

SCHEMA · NORMALIZATION

PHASE 04↗

</>

Bring it into code.

Create the tables, populate sample data, and enforce integrity with SQL.

MYSQL · DATA INTEGRITY

PHASE 05↗

↔

Make it work together.

Connect queries, backend logic, and the frontend into one application.

BACKEND · FULL-STACK

02 / THE APPLICATION

Family health.
Connected through data.

Sillah brings family medical history, hereditary risk awareness, and preventive care workflows into one system. This is the engineering behind those connections.

Visit Sillah ↗

01

Model the relationships

Family, medical history, and preventive care.

↗02

Protect the integrity

Relational design. Consistent, reliable data.

↗03

Connect the experience

Real queries behind meaningful interactions.

↗

03 / THE PEOPLE

Built together.

Four contributors. One shared foundation.
Select a team member to meet the people behind the project.

• Shoug Alomran

  Risk alerts & analysis

• Yara Albugami

  Appointments & awareness

• Rose Al Rakan

  Users & access control

• Raghad Abdulaziz

  Family & medical history