ZuoTi.Pro
Question

The primary key for M:N relationship tables O is a single attribute. @ always consists of two attributes. O is the primary key of the most important entity linked to that relationship does not exist. Many-to-many relationship tables only use foreign keys
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The answer is : Does not exist. Many to many relationship only use foreign keys

Handling a one-to-one relationship or a one-or-many relationship can be done by adding the primary key of one table into the other table as a foreign key.

But handling many to many relationships requires a joining table or a bridging table which involves using foreign keys

0 0
Add a comment
Know the answer?
Add Answer to:
The primary key for M:N relationship tables O is a single attribute. @ always consists of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Which of the following is NOT true? Mapping an M:N relationship that has no attributes will...

    Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in: A new relation Two foreign keys A composite primary key A foreign key in both of the relations mapped from the involved entities

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • This is symbolized by a circle over a single line in an entity relationship diagram. It...

    This is symbolized by a circle over a single line in an entity relationship diagram. It signifies that the supertype does NOT have to be one of the specified subtypes. Partial completeness Total completeness System completeness Associative completeness A supertype entity can contain as many as ____ subtype entities. 10 1 100 no defined limit When you set up an Entity Relationship Diagram, and have a many-to-many relationship, this entity is created to avoid problems inherent to a many-to-many relationship....

  • In the box below, draw a relational model(not ERD) that illustrates the date represented by the...

    In the box below, draw a relational model(not ERD) that illustrates the date represented by the ERD described. Specify all primary and foreign keys. The ERD contains three entities: The first entity is called STUDENT and contains STUDENTID, StudentLastName, and StudentEmail as attributes. The StudentID attribute is the primary key for the STUDENT entity. The second entity is called CLASS and contains classID, className, and classcredit as attributes. The ClassID attribute is the primary key for the CLASS entity The...

  • 6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spou...

    6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spouse, one father, and one mother. Show foreign keys with dashed undedine, and Primary keys with solid underline. (Come up with your own field names). (3 points) 6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume...

  • Consider the following three tables, primary and foreign keys. Table Name        SalesPeople Attribute Name                  &nbsp

    Consider the following three tables, primary and foreign keys. Table Name        SalesPeople Attribute Name                                Type                                      Key Type EmployeeNumber              Number                               Primary Key Name                                   Character JobTitle                                  Character            Address                                 Character PhoneNumber                    Character YearsInPosition                Number Table Name        ProductDescription Attribute Name                                 Type                                      Key Type                 ProductNumber                  Number                               Primary Key                 ProductName                    Character                            ProductPrice                      Number Table Name        SalesOrder Attribute Name                                Type                                      Key Type                 SalesOrderNumber         Number                               Primary Key                 ProductNumber              Number                               Foreign Key                 EmployeeNumber           Number                               Foreign Key                 SalesOrderDate                Date Assume...

  • Show the ERD for the following piece of the problem statements. Show only entities (or dependent...

    Show the ERD for the following piece of the problem statements. Show only entities (or dependent entities), relationships, multiplicities, primary keys and foreign keys. Create an appropriate primary key if necessary. You don’t need to specify other attributes. If a relationship is M:N, then show two diagrams: both the M:N relationship diagram and its decomposition into two 1:N relationships. (a) A book has one or many keywords and one keyword can be used in zero or many books. (b) A...

  • when there is a primary key foreign key relationship, what type of constraint becomes important? Input...

    when there is a primary key foreign key relationship, what type of constraint becomes important? Input Mask Validation Entity Integrity Referential Integrity

  • COnvert the REA Diagram to tables. At least 2 Relevant Attributes for each. Table, Primary Key,...

    COnvert the REA Diagram to tables. At least 2 Relevant Attributes for each. Table, Primary Key, Foreign Key, Attribtes the following segment to tables. For each table, provide at least TWO relevant attributes.

  • What is a primary key? Multiple Choice A field (or group of fields) that uniquely identifies...

    What is a primary key? Multiple Choice A field (or group of fields) that uniquely identifies a given record in a table. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables. Characteristics or properties of an entity. A field (or group of fields) that uniquely identifies a given attribute in a table.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT