Question: 27. If there is a one-to-one relationship from entity A to B , then a. there exists a functional dependency from the primary key in

27. If there is a one-to-one relationship from entity A to B , then a. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) -> PK(B). b. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) -> PK(A). c. both a. and b. d. neither a. nor b.

28. If there is a one-to-many relationship from entity A to B , then a. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) -> PK(B). b. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) -> PK(A). c. both a. and b. d. neither a. nor b.

29. If there is a many-to-many relationship from entity A to B , then a. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) -> PK(B). b. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) -> PK(A). c. both a. and b. d. neither a. nor b.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 41 The reason why a database table is in the second normal form (2NF), but not in the third form (3NF) is because: a. There is a non-prime attribute that is transitively dependent on the key...

1. If a relational database table is in the third normal form, it is also in a. the first normal form. b. the second normal form. c. the Boyce-Codd normal form. d. both a. and b. 2....

QUESTION 8 Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table R? a. select * from R left outer join S where...

would you please please help me with all the questions thanks alot Question 1 (3 points) In the case of both one-to-one and one-to-many relationships, one table is considered the parent, and its...

27. To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click on the shortcut menu. a. Open b. Modify A form that is contained within another...

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. A weak relationship exists if the primary key of the related...

undefined Normalization Tutorial Question 1 Given a report of sales by SQuare Mas shown below: SQuare M Sales Report salespersonNo salespersonName sales Area custNo custName outletNo outletAdd sales...

Multiple choices: 8. A car's color is an example of a ________. a. multivalued attribute b. derived attribute c. single-valued attribute d. simple attribute 15. In the Chen notation, ________. a....

A rectangular tetrahedron has six edges of length a. A force P is directed as shown along edge BC. Determine the moment of P about edge OA.

What is the acceleration of the electron at its turningpoint? Express your answer in meters per second squared. A 2.3 mm -diameter sphere is charged to -4.5 nC . An electron fired directly at the...

2.55 If each coded item in a catalog begins with 2 distinct letters followed by 3 distinct nonzero digits, find the probability of randomly selecting one of these coded items with the first letter a...

Who would ask the question: What does this tell us about program sustainability? Question 3 options: Internal users of financial accounting information. External users of financial accounting...

1. Sufficient budget and resources will be provided to develop and support the use of new technology.

7. Recommend what should be included in an electronic performance support system.

9. Identify and explain the benefits of learning management systems.