I have a class diagram and would like to know how to build the database. Here's the scenario:
-
With the classes below I have a Demand that has a requestor and an analyst, next to each of the classes should I have a list of demands?
-
In this case what would the database look like, id requestor and id analysts would be PK in your tables and fk in the table DEMANDS?
-
In the case of the list of demands in Requesters and Analysts as would be in the DB, what kind of data?
Applicant
- ID_SOLICITANTE - NOME - LOTACAO - DEMANDAS (LIST)
Analyst
- ID_ANALISTA - NOME - EQUIPE - DEMANDAS (LIST)
Demands
ID_DEMANDA NRO_TICKET PRIORIDADE ANALISTA (Tipo: Analista) SOLICITANTE (Tipo: Solicitante)