Defining more transactions
Tourist attractions and countries are related entities: each tourist attraction is located in a specific country. How can we reflect this in our transactions? What are the effects of this on the database? We analyze the reorganization concept; we execute and see the selection list automatically created by GeneXus for selecting a country and relate it to an attraction, and we will see that GeneXus controls the consistency of the related data. Significance of the name assigned to attributes. Possibility of not assigning a value to a foreign key.
Differences between transaction and table structures. Impact analysis. Primary and foreign key. We add an attribute of Image type to register a photo of the tourist attraction.
Primary Key Foreign Key integridad referencial Nullable clave nula Image prompt