![]() It is worth mastering the Entity Relationships Diagram as it can help you to “see” the database in a new way. TblStudents and tblCourse are connected by a Many-to-Many relationship through a table called tblJctStudentsCourses. The “1” sign represents the “1” part of a relationship.ĬourseTypeID is a Foreign Key of tblCourseType (not shown).ĬourseID is a primary key as noted by the key symbol. ![]() The infinity sign represents the “Many” part of a relationship. There might well be more tables in the database but some could have been hidden to make the diagram easier to read. The obvious reason is the relax rules of NoSql about relationships, which aim to get a developer started with minimum requirements. Wouldn’t it be great if Access were able to provide us with some kind of visual representation of the data?Īs it happens, Access contains its own (very useful) diagram to visualize relations between tables…Ĭlick the Relationships button which can be found in the Relationships group of the Database Tools tab on the Ribbon. NoSql, unlike SQL which has ER and class diagrams, has neither names nor constraints for data modeling diagram(s). ![]() In this post, we show you how to open up the Entity Relationships Diagram in MS Access.Ĭreating relations between tables is a fundamental part of an Access database but trying to keep all those relations in mind can get a little confusing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |