Skip to content

Database

Danny Jung edited this page May 15, 2024 · 4 revisions

Database

Entity-Relationship (ER) Diagram

image From: https://www.figma.com/board/t6SoANETqcafKGakzdAvZT/F%3ASAE%3A47-Database-Schema?node-id=0-1&t=CaOfywj7xwEVcR99-0

Purpose: The ER diagram shows all the entities and their attributes that are found in the FSAE website, along with the relationship between those entities.

Unified Modeling Language (UML) Class Diagram

image From: https://app.diagrams.net/#G1k4mIiCaXg5fba4FW8ORNPVLRsk73fDnY#%7B%22pageId%22%3A%22nZ3NGz7lrp0nLSx_nWRA%22%7D

Purpose: The UML class diagram represents the key classes in the job board system, their attributes, methods, and relationships.

Database Schema

image From: https://www.figma.com/board/t6SoANETqcafKGakzdAvZT/F%3ASAE%3A47-Database-Schema?node-id=0-1&t=CaOfywj7xwEVcR99-0

Purpose: The schema defines the structure of our data, including tables, columns, relationships, primary and foreign keys.