nbajazz16
contestada

Using the data for the JC Consulting database shown in Figure 2-1, identify the one-to-many relationships as well as the primary key fields and foreign key fields for each of the five tables.

Using the data for the JC Consulting database shown in Figure 21 identify the onetomany relationships as well as the primary key fields and foreign key fields f class=

Respuesta :

MrRoyal

The JC consulting database is a structure used to store organized information of JC consulting

How to identify the relationship

From the figure, we can see that the cardinality of the project table and the client table is 1 : many.

Similarly, the cardinality of the project table and the ProjectLifeItems is 1 : many.

Hence, the one-to-many relationships are Project & Clients and Project & ProjectLifeItems

How to identify the primary key

This is the key on the first table (i.e. the client table)

Hence, the primary key field is ClientID

How to identify the foreign keys

These are the fields that correspond to the primary key on the client table

The fields that correspond to ClientID are ProjectID, EmployeeID, TaskID and ProjectLifeItemsID

Hence, the foreign keys are ClientID are ProjectID, EmployeeID, TaskID and ProjectLifeItemsID

Read more about database at:

https://brainly.com/question/24223730

Otras preguntas