Q1)Answer the following question.
1)Explain the relationship set on the feilds of tables in the database.
Answers
Answer:
mark me as BRAINLIEST OOOOOOOOOOOOOOOOOOOOKKKKK
Explanation:
Many-to-many relationships
In a many-to-many relationship, a row in table A can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table that is called a junction table. The primary key of the junction table consists of the foreign keys from both table A and table B. For example, the "Authors" table and the "Titles" table have a many-to-many relationship that is defined by a one-to-many relationship from each of these tables to the "TitleAuthors" table. The primary key of the "TitleAuthors" table is the combination of the au_ID column (the "Authors" table's primary key) and the title_ID column (the "Titles" table's primary key)
How to define a one-to-many or one-to-one relationship
To create a one-to-many or a one-to-one relationship, follow these steps:
Close all tables. You cannot create or change relationships between open tables.
In Access 2002 or Access 2003, follow these steps:
Press F11 to switch to the Database window.
On the Tools menu, click Relationships.
In Access 2007, Access 2010, or Access 2013, click Relationships in the Show/Hide group on the Database Tools tab.
If you have not yet defined any relationships in your database, the Show Table dialog box is automatically displayed. If you want to add the tables that you want to relate but the Show Table dialog box does not appear, click Show Table on the Relationships menu.
Double-click the names of the tables that you want to relate, and then close the Show Table dialog box. To create a relationship between a table and itself, add that table two times.
Drag the field that you want to relate from one table to the related field in the other table. To drag multiple fields, press Ctrl, click each field, and then drag them.
In most cases, you drag the primary key field (this field is displayed in bold text) from one table to a similar field (this field frequently has the same name) that is called the foreign key in the other table.
The Edit Relationships dialog box appears. Make sure that the field names that are displayed in the two columns are correct. You can change the names if it is necessary.
Set the relationship options if it is necessary. If you have to have information about a specific item in the Edit Relationships dialog box, click the question mark button, and then click the item. (These options will be explained in detail later in this article.)
Click Create to create the relationship.
Repeat steps 4 through 7 for each pair of tables that you want to relate.
When you close the Edit Relationships dialog box, Access asks whether you want to save the layout. Whether you save the layout or do not save the layout, the relationships that you create are saved in the database.