answersLogoWhite

0

The way a many to many relationship is done is by inserting a junction table and having two one to many relationships with the primary key of each of the two main tables becoming a join primary key of the junction table.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the typical language for database management?

The typical language for database management is SQL. This is one of many programming languages, but this is the predominate one for database management.


What is ETL software used for?

ETL software stands for 'Extract, Transform and Load'. This software is used mainly to migrate data from one database to another. It is also used to convert database formats from one type to another.


How many tables are required in access database?

one


How do I convert 2003 access database to 2007?

Open the database in Access 2007 and save as Access 2007 format.


How many Access database can you have open at one time?

as many as you want


How can you convert a database program to a word document?

Unless you want to read the code that powers the database programme, you don't want to convert it to a document. You may, however, want to convert a database file to a document. Since the database file contains not only the data you want to retrieve, but embedded codes, you may be able to save the database file into a .TXT format. Then you can open it using Windows Notepad -- if you're working on a Windows operating system. This will give you the contents of the database data file.


What is a one-to-many relationship?

It is a term from computer databases. A relational database can have a one-to-many relationship in its data. For example, if you have a customer order database, one table will contain customer names and another will contain their orders. Each customer will only be listed once, but each customer can make many orders. So one customer can be related to many orders. Incorporating that into a database requires the creation of a one to many relationship.


What database object allows you to select specific information from one or many tables?

You are referring to the Microsoft Access Database. This allows you the ability to select specific information from one or many tables.


What is a paper based database?

One paper-based database I can readily think of is a phone book. Paper based database is database that consists of many papers, not a e-database! Paper-based communicaton is anything written, drawn or printed.


What would you keep in your database?

A database should be dedicated to one sort of information. A common mistake designers of database systems make is combining unrelated information, leading to many issues.


How can you convert an Access database to an Excel spreadsheet?

To export the Access database to an Excel sheet in an easy way and for a detailed explanation, see the related links.


Can a relational database support one to one?

Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.