My last post (first post to the forum!), a beginner plea for help, saw some helpful souls post a number of links on data normalization. Numerous articles have been read, albeit not fully digested, and I've delved headfirst into the world of relational databases.
Can I request a progress check?
Background:
I'm shooting to create a bilingual database of business segments for the purposes of translation. In my head, the user will enter a 4-digit stock ticker into a search box, and out will pop:
The analysts covering the stock in question, including their relevant contact information (full name, phone number, etc). In addition, all products, business segments, etc., associated with the firm associated with the 4-digit ticker will also be displayed. Stocks are, of course, incorporated into sectors (pharma, toys and media, etc.) which will also be incorporated.
I have attached my current data model, though it currently DOES NOT include any analyst information (and I'm a bit confused as to how to incorporate it)
Some notes/questions on the image attached:
*ProductID, BusinessSegmentID, SectorID, and DrugID are all auto numbers.
*I'm unsure as to whether (in the CoverageTbl) the SectorCode is "functionally dependent" on the TickerID. A Ticker identifies a single, unique company. The SectorCode isn't really dependant on the ticker, but rather is an indication of which family it belongs in. Is this a functional dependence problem or am I thinking about this wrong.
*I remain very uncertain how to incorporate the analysts. Most of their contact information will likely be contained in a single table, but given that two or more analysts will together cover a number of companies (tickerID's) we have a many-to-many relationship, no? Any hints as to how to proceed?
I apologize if anything is unclear or confused.