On this project I have created a sample of a relational data-base about 5 of the biggest companies in the world, providing information about some of their biggest investments.
-
Topic and Aim Selection:
- The project commenced with the selection of the topic and primary aim of the database. The primary objective was to provide users with detailed insights into internal investments made by these major corporations.
-
Initial Handwritten Diagram:
- An initial concept diagram was hand-drawn to outline the preliminary relationships and structure of the database.
-
Refined Diagram Using DB Diagram:
- The preliminary diagram was refined and organized using a specialized tool like DB Diagram. This step allowed for a clearer visualization of the database's structure and relationships.
-
Table Creation with Data Integrity in Mind:
- During the table creation phase, utmost attention was paid to data integrity, ensuring that relationships were accurately defined. This approach laid the foundation for a robust and dependable database.
-
Organized Data for User-Friendly Retrieval:
- When designing the tables, the focus was on ensuring that data retrieval was user-friendly. Related information was logically organized to facilitate efficient querying. For instance, a Company table was created alongside an Investments table, and further, the Performance table was connected to provide deeper insights.
-
Interconnected Tables for Meaningful Relationships:
- I organized it with three key tables: a "Companies Table" containing company details, an "Investments Table" listing investments linked to companies through foreign keys, and a "Performance Table" presenting additional insights about investments, connected to the Investments Table via foreign keys.
By following this systematic workflow, the Portfolio Investment database was meticulously designed to cater to users seeking comprehensive insights into major companies' internal investments. The step-by-step approach, starting from topic selection to data organization and relationship establishment, ensured that the resulting database is both reliable and user-friendly.