Question: Help with this question Problem 8-10 use the same database. Let a database application have the following entities Sales ={ Customers, Salesperson, Retail Order, Items
Problem 8-10 use the same database. Let a database application have the following entities Sales ={ Customers, Salesperson, Retail Order, Items }, which contains the information that a salesperson sells multiple items (tables, computers,...) to customers. There are many customers. There are many salesmen. There are many items. For example, John sells to Joe, Smith sells to Jane, ... The "Salesperson" will sale many times. The "Customer" can come back and buy items many times. The "Retail Order" specifies which Salesperson sell to which customer. In each "Retal Order", many items (tables, computers, ...) can be sold What is the relationship between Salesperson to Retail Order? One-to-many relationship None of the above Many-to-many relationship One-to-one relationship
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
