![]() This would have values for all the units used in the recipes, e.g. The Unit column should also be a foreign key referencing the primary key of a Units table with just one column, Unit. ![]() The last would be a Long Text column, and would be the text description of the 'instructions' for making the dish in question.Īnd to model the many-to-many relationship type: So you'd start with two tables to model these, in broad outline as follows: The list of ingredients is, in relational database terms, a many-to-many relationship type between the entity types recipes and ingredients, the tables, their attributes and the relationships between them. As always the starting point is the logical model, i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |