Design and creation of Database

[v613]

Design Database Structure with SQL DDL

Objective:
Design the structure of the database required for application, including all necessary tables, relationships, and data types. This should encompass all entities and fields that align with the application’s requirements.

Requirements:

1. Identify Entities and Relationships:

   • Determine the key entities (e.g., Partners, Events, Locations) and their relationships.
   • Outline any constraints, such as primary and foreign keys.

2. Write SQL DDL:

   • Draft the SQL DDL statements for creating the required tables. Ensure that the naming conventions and data types are consistent and suitable for the application.
   • Include any indexes and necessary constraints to optimize performance. (optionaly)

3. Organize DDL Scripts:

   • Store all SQL DDL scripts in a dedicated directory within the project. The suggested path is scripts/ddl.sql. Ensure that the directory is included in version control.

4. Documentation:

   • Provide comments within the DDL scripts to explain the purpose of each table and any significant design decisions made.

5. Commit Guidelines:

   • When committing changes, please make sure to include the relevant issue link in the commit "body" (not in the subject) for proper tracking.

Feel free to reach out if you need any clarifications or assistance as you work on this task!

[v613]

I know that the task has been completed. Could you please upload the scripts to the designated directory? Thank you!

[v613]

I am reopening this issue because the requested actions have not yet been completed