Question: database managment 3) Consider the following binary relationships: Buys Cust Car Sam Mustang Sam Cobra Jenn Mustang Jenn Cobra Buys from Cust SP Sam Don

database managment

3) Consider the following binary relationships:

Buys

Cust

Car

Sam

Mustang

Sam

Cobra

Jenn

Mustang

Jenn

Cobra

Buys from

Cust

Sam

Don

Sam

Sharon

Jenn

Sharon

Sells

Car

Don

Cobra

Don

Mustang

Sharon

Cobra

Sharon

Mustang

These relationships involve customers (), salespersons (), and cars(). What information, if any, can you get from these relationships about who sold Sam a Cobra?

Answer:

If it is not possible to determine who sold Sam the Cobra, show a possible ER diagram that would be able to answer this question without ambiguity. Populate the table(s) with some representative data.

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!

Database Managment 4) Consider the following requirements for a company database: A company has employees that have social security number (ssn), salary and phone Departments are described by a...

Comprehensive Each part of the comprehensive problem is based on Big Marker (www.bigmarker.com). Problem Part 2 of 5 Consider the narrative in Part 1 as you respond to the following questions on...

UNTING INFORMATION SYSTEMS; FOURTH EDITION cumentation Tecbniques and Database Design 3. Consider the database specifications you created in Question 2. Suggest three queries Big Marker could create...

Please answer this question fully with every step. I will give a thumbs up if right. This is Database. Problem 3 Consider the bookstore E-R in Fig 6.30 in the 7 th ed of textbook (Figure 7.29 in 6th...

Database course 3. Consider the following schedule S of two transactions rl(X), r2(Y), wl(Y), cl, w2(Z), c2 Tell whether (i) S is serial (ii) S is serializable i.e., it can be written as an...

Database Manegment 3. Consider schema (R,F),where R ABCDE, F C EA, E-D, DB C, AC E i. Find all the keys of the relation, and for each one, prove it is indeed a ii. Decompose the schema into a set of...

NOTE: SUBJECT DATABASE Managment system There is/are table(s) having more than one FK (which are neither PK nor part of PK) True/False True Q: Relationship Line lies between having cardinality &...

COMPLETE ALL THE QUESTIONS 1) Make a version of X.32[7] where the element type is a template argument. [10] ( 2.5) Given an Itor class like the one in X.32[8], consider how to provide iterators for...

Sunny Oaks Summerday Park Elementary School Figure 1. CLASS ROSTERS with telephone contact information Directory ROSTER MOSPES serves several neighborhoods in NorthWest Dallas. The MOSPES PTA...

Database Managment 1) A view is an alias of an actual table; all the columns and rows are visible through either the table or the view. a. True b. False 2) One advantage of a view is that it can...

Hugret Ltd is a company operating in the hotel industry and it owns two hotels, both operating as separate investment centre. The financial information of both hotels over the last four years is...

a. It is said (S. Branch Walker) that the Indian who sold Manhattan for $24 was a sharp salesman. If he had put his $24 away at 6 percent compounded semiannually, it would now be worth over $9...

QUESTION 2 ( 2 5 marks ) You are the Auditor of Dress Up ( Pty ) Ltd ( Dress Up ) , a company that hires both formal wear and dress - up costumes for short - term use. Dress Up has five stores across...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

b. What are its goals and objectives?

4. Trust develops with shared experience, values, give-and-take, and the result of human communication. Satellites, electronic mail, and networks could reduce the dimensions of trust to which we are...

3. Messages of affect and value will decrease. Ambiguity in interpreting information will increase. Managers will have to seek new ways of communicating the affective component of messages.