........ are define between tables. to get the information together form
Answers
Explanation:
This article describes how to define relationships in a Microsoft Access database. The article includes the following topics:
What are table relationships?
Kinds of table relationships
One-to-many relationships
Many-to-many relationships
One-to-one relationships
How to define relationships between tables
How to define a one-to-many or one-to-one relationship
How to define a many-to-many relationship
Referential integrity
Cascading updates and deletes
Join types
What are table relationships?
In a relational database, relationships enable you to prevent redundant data. 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. 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. 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.
A 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.
To make sure that you data stays synchronized, you can enforce referential integrity between tables. Referential integrity relationships help make sure that information in one table matches information in another. For example, each title in the "Titles" table must be associated with a specific publisher in the "Publishers" table. A title cannot be added to the database for a publisher that does not exist in the database.
Logical relationships in a database enable you to efficiently query data and create reports.
Answer:
A table is an arrangement of data in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs, and many other places. The precise conventions and terminology for describing tables vary depending on the context. Further, tables differ significantly in variety, structure, flexibility, notation, representation and use. In books and technical articles, tables are typically presented apart from the main text in numbered and captioned floating blocks.
This is your answer.
Hope this helps you.