Open Forsm0 opened 3 days ago
Forsm0
commented
3 days ago This task is now ready to be picked up. If you have any concerns about the set deadline, please let me know. If you get stuck, please don't hesitate to reach out. We are all in this together. Lets goo
ShajiRahman
commented
22 hours ago Can some share the updated class diagram please ?
ShajiRahman
commented
22 hours ago What are the 5 tables that we have decided ?
Priority: High Description: Complete the foundational database setup, which is critical for backend and front-end data integration in later weeks.
Establish a well-defined database schema with both logical (ERD) and physical (table creation) models.
[ ] Create Entity-Relationship Diagram (ERD): Identify key entities (tables) and their relationships, targeting up to 5 tables.
[ ] Develop Logical Model: Map out tables with fields and data types in an ERD, including primary keys and foreign keys.
[ ] Design Physical Data Model: Use phpMyAdmin to translate the ERD into a physical database model by creating tables with appropriate columns, data types, primary keys, and foreign keys.
[ ] Document Schema: Write a brief schema documentation file describing each table’s purpose and its main fields.