Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have five E-R model questions: Question 24 1. When converting an E-R model to a relational model, the table for a binary relationship can

I have five E-R model questions:

Question 24

1. When converting an E-R model to a relational model, the table for a binary relationship can be replaced by a foreign key provided the relationship is not

A.

many-to-many

B.

many-to-one

C.

one-to-many

D.

one-to-one

0.5 points

Question 31

1. In the E-R model, an attribute that can be broken down into smaller attributes is called

A.

composite

B.

null

C.

a superattribute

D.

derived

0.5 points

Question 34

1. In the EE-R model, completeness constraints tell us whether a specialization is

A.

total or partial

B.

union or category

C.

disjoint or overlapping

D.

predicate-defined or user-defined

0.5 points

Question 38

1. When an entity set is related to itself, we have a _______ relationship.

A.

extended

B.

optional

C.

mandatory

D.

recursive

0.5 points

Question 39

1. In the relational model, the table in which a foreign key appears as the primary key is called its

A.

root relation

B.

home relation

C.

child relation

D.

foreign relation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OpenStack Trove

Authors: Amrith Kumar, Douglas Shelley

1st Edition

1484212215, 9781484212219

More Books

Students also viewed these Databases questions

Question

4. What advice would you give to Carol Sullivan-Diaz?

Answered: 1 week ago