Question: 1) An M:N relationship can be decomposed into : a) two 1:1 relationships b) a 1:1 reltionship and a 1:M relationship c) two 1:N relationships

1) An M:N relationship can be decomposed into :

a) two 1:1 relationships

b) a 1:1 reltionship and a 1:M relationship

c) two 1:N relationships

d)noen of the above

2) if N number of tables are joined then they should have

a)maximum of N-1 join clauses

b)minimum of 1 join clause

c)maximum of N join clause

d)minimum of N-1 join clauses

PLEASE ANSWER ONLY IF YOU ARE 100% SURE AND GIVE NECESSARY EXPLANATION

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!

Q:

(Database Design ERDs) You can use the draw.io website to complete Task2 and save your lab file as a PDF file and attached to your zip file.. Inclding this word doc and draw.io result you can combine...

Q:

9) When using an REA diagram to develop a database, a many-to-many relationship must be A) broken into two, one-to-one relationships. B) combined into a single one-to-one relationship. C) combined...

Q:

Question 1 Morality is Select one: A. Universal and basic to human relationships. B. Established by the common law. C. The system that protects property and people. D. The application of ethics to...

Q:

If the entity COURSE is related to the entity CLASS, then it is only necessary to determine the connectivity of the relationship from COURSE to CLASS. True False A user gets an error when entering...

Q:

If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95%...

Q:

If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95%...

Q:

DRIVER TRUCK drives During some time interval, a DRIVER can drive many TRUCKs and any TRUCK can be driven by many DRIVERs FIGURE Q3.14 The Crow's Foot ERD for Question 14 How would you convert this...

Q:

Ch . 5 Problems: 1 , 2 , 3 , 4 , 5 , 6 , 1 0 , 1 1 , 1 2 , 1 8 ( pg . 1 6 7 - 1 6 9 ) Copy / Paste the ERD for each problem from your drawing application to a Word document and clearly label each...

Q:

D 4.0 Organization of Elements in Entities with Relationships At We will continue to use the DB ERD Exercise Excel file, so locate the copy you used in Section 3.0 and open it. When Section 3.0 was...

Q:

ONLY draw the entity - relationship diagrams for: Draw an ERD containing the Order and Customer entity types connected by a 1 - M relationship from Customer to Order. Choose an appropriate...

Q:

Assignment You may have to use Scilab/Matlab/Python for computation wherever necessary. Each student should make a choice of one of the above software, and stick to that throughout the assignment....

Q:

What weaknesses are commonly associated with the use of the payback period to evaluate a proposed investment?

Q:

which of the following statements is fasle? a capital budget lists the projects and investements b . when sales of a new product displace sales of an existing c . the opportunity cost

Q:

Cash-flow-based valuation is based on the future earnings that the firm is able to generate after adjusting for necessary investments in operating assets and required payments to debtholders . a...

Q:

As part of its long-range expansion and remodeling plan, Simpson Foods gathered input about the features/services its customers consider important in a grocery store. Data from 693 respondents...

Q:

The amount of work I am asked to do is reasonable.

Q:

The company encourages a balance between work and personal life.