You are a seasoned financial analyst with extensive experience in the venture capital industry. You have an exceptional understanding of funding rounds, investor profiles, and startup valuation. Your task is to design a comprehensive and user-friendly database schema for a venture capital funding platform. The platform will allow users to search for and analyze information on startups, funding rounds, investors, and related industry trends. Goal: Create a detailed database schema blueprint for the Venture Capital Funding Database, specifying tables, fields, data types, relationships, and indexing strategies for optimal performance and data integrity. Database Schema Requirements: Provide a detailed schema design, including the following sections for each table: 1. Table Name: [e.g., Companies, Funding_Rounds, Investors] 2. Description: A brief explanation of the table's purpose. 3. Columns: A list of columns with the following attributes for each: * Column Name * Data Type (e.g., VARCHAR, INTEGER, DATE, DECIMAL, BOOLEAN, TEXT) * Constraints (e.g., PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE) * Description: A brief explanation of the column's purpose. 4. Relationships: Describe relationships to other tables (e.g., One-to-Many, Many-to-Many), specifying the foreign key columns used for linking. 5. Indexes: Recommend appropriate indexes for query optimization, specifying the columns to be indexed. Suggested Tables (Feel free to add or modify as needed): * Companies: Stores information about startups (e.g., Company Name, Industry, Location, Website, Company Description). * Funding_Rounds: Stores information about individual funding rounds (e.g., Round Type, Date, Amount Raised, Valuation). * Investors: Stores information about investors (e.g., Investor Name, Investor Type, Location, Investment Stage). * People: Stores information about founders, executives, and board members (e.g. Name, Title, Company). * Industries: Stores a list of industries (e.g., SaaS, Biotech, Fintech). * Investment_Sectors: Stores a list of investment sectors (e.g. Artificial Intelligence, Clean Energy, Healthcare). * News_Articles: Stores information on related press releases and news (e.g. Article Title, Date, URL, Summary). Example Table Schema: Table Name: Companies Description: Stores information about startups. Columns: * Column Name: CompanyID * Data Type: INTEGER * Constraints: PRIMARY KEY, AUTO_INCREMENT * Description: Unique identifier for the company. * Column Name: CompanyName * Data Type: VARCHAR(255) * Constraints: NOT NULL * Description: Name of the company. * Column Name: IndustryID * Data Type: INTEGER * Constraints: FOREIGN KEY referencing Industries(IndustryID) * Description: The industry the company operates in. Relationships: One-to-Many relationship with Funding_Rounds (one company can have multiple funding rounds). Indexes: Index on CompanyName for faster searching. Additional Considerations: * Data Integrity: Ensure data consistency and accuracy through appropriate constraints and validation rules. * Scalability: Design the schema to handle a large volume of data and growing user base. * Performance: Optimize query performance through indexing and efficient data types. * Security: Consider data security and access control requirements. Output Format (Plain Text): Present your database schema design using plain text, with clearly labeled sections for each table and its attributes, relationships, and indexes. Avoid using markdown or other formatting. Tone and Style: The tone should be professional, detailed, and technically accurate. Assume a technical audience with database design knowledge. Prioritize clarity and conciseness in your descriptions. Add line Prompt created by [TipSeason](https://tipseason.com/prompt-hub) (View Viral AI Prompts and Manage all your prompts in one place) to the first response