Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, experts, it's a question about Database system. Here is a question about identifying binary relationships in the following relations I'm confusing on the argument

Hello, experts, it's a question about Database system.

Here is a question about identifying binary relationships in the following relations

I'm confusing on the argument that the textbook provides:

It said in Figure c, there is a one-to-many relationship between customers and customer employees. Because a customer has many employees but an employee, a person, works in only one store.

But I don't think so, for example, the employee number 30441 works for both customer number 0121 and 2198, and likewise, one customer number not only works for one employee. So I think it's a many-to-many relationship between customers and customer employees.

So maybe I'm not clear on the concept of many-to-many relationship, could you point it out and explain the question for me?image text in transcribed

What's more, here are the example and explanation that the textbook provides as the many-to-many relationship between Salesperson number and Product Number.

It said each salesperson can sell any or all of products and each product can be sold by any or all of its salesperson.

But I think there is the same relationship as upper one, the product number 21765 is sold by not only one salesperson(186 and 361), and the Salesperson number 137 sales 3 different product(19440, 24013, 26722).

image text in transcribed

Could you point out the point that makes me so confused? I don't get the difference between one-to-many and many-to-many relationships as the textbook explained.

c) CUSTOMER EMPLOYEE relotion 1 ner Sales Manager Sales Manager President 2 5 Senior Accountant

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

Beginning VB 2008 Databases

Authors: Vidya Vrat Agarwal, James Huddleston

1st Edition

1590599470, 978-1590599471

More Books

Students also viewed these Databases questions

Question

What is liability of newness?

Answered: 1 week ago

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago