Logical relationships in a database enable you to efficiently query data and create reports. A title cannot be added to the database for a publisher that does not exist in the database. For example, each title in the "Titles" table must be associated with a specific publisher in the "Publishers" table. Referential integrity relationships help make sure that information in one table matches information in another. To make sure that you data stays synchronized, you can enforce referential integrity between tables. If you were to store all this information in the "Titles" table, the publisher's telephone number would be duplicated for each title that the publisher prints.Ī better solution is to store the publisher's information only one time, in a separate table that we will call "Publishers." You would then put a pointer in the "Titles" table that references an entry in the "Publishers" table. ![]() There is also information that you might want to store about the publisher, such as the publisher's telephone number, address, and ZIP Code/Postal Code. For example, if you are designing a database that will track information about books, you might have a table named "Titles" that stores information about each book, such as the book's title, date of publication, and publisher. In a relational database, relationships enable you to prevent redundant data. ![]() How to define a many-to-many relationship.How to define a one-to-many or one-to-one relationship. ![]() How to define relationships between tables.The article includes the following topics: This article describes how to define relationships in a Microsoft Access database. This article applies only to a Microsoft Access database (.mdb or. Novice: Requires knowledge of the user interface on single-user computers.
0 Comments
Leave a Reply. |