USER STORY: Create Database Schema

[emidombek]

User Story

User Story: As a developer, I want to create the initial database schema for the project to define the structure of the database.

Acceptance Criteria:

1. Define the main entities and their attributes for the database.
2. Determine primary keys and foreign keys for each table.
3. Specify data types for each column in the schema.
4. Ensure the schema follows normalization principles.
5. Document the database schema for reference.

Tasks:

• [x] Identify the main entities and their attributes.
• [x] Create an initial ERD (Entity-Relationship Diagram).
• [x] Define primary keys and foreign keys.
• [x] Determine appropriate data types for each column.
• [x] Normalize the schema to minimize data redundancy.
• [x] Create a detailed schema design document..

[emidombek]

Final concept.

[emidombek]

Spreadsheet with mapped models/columns here

[emidombek]

Link for Database Design Documentation here

[emidombek]

All tasks complete.