Homework Answers
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
Add Answer to:
The primary key for M:N relationship tables O is a single attribute. @ always consists of...
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....
Please answer true or false 27) Relationship instances occur when an instance of one entity is...
Please answer true or false 27) Relationship instances occur when an instance of one entity is related to an instance of another entity via a relationship. 28) Two columns of a relational table can have the same values. 29) If one of two identical relational tables has the first row moved to the last place, those two relational tables are no longer identical. 30) An entity and its 1:1 unary relationship are mapped as one relation. 31) An entity and...
Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above,...
Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above, work on the problems below: 1. For each table, identify the primary key. 2. For each table, identify the foreign key(s). 3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. 4. For one of the tables, give examples of a superkey and a secondary key. 5....
Which of the following statement is true? A primary key is a minimal candidate key A...
Which of the following statement is true? A primary key is a minimal candidate key A candidate key is a a set of attributes for which, if we remove any attribute, it will lose the key property If we add an extra attribute to a super key, it will become a candidate key A super key is the most important key in an entity/table A primary key can be any set of attributes that uniquely identifies a tupple/row
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  
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...
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
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...
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...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago