Question: I need help with this question Problem 8-10 use the same database. Let a database application have the following entities Sales ={ Customers, Salesperson, Retail_Order,
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 "Retail Order", many items (tables, computers,..,) can be sold Hint: This is very similar to one of your homework What is the relationship between Retail Order and Items? One-to-many relationship None of the above One-to-one relationship Many-to-many relationship
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
