Re: Database efficiency question
Posted by: denis k
Date: January 08, 2011 10:02AM

Thanks Rick James, I am hoping I got a good understanding now. The way I'm hearing it now is basically having a customer table, product table and customer_products table. Then just insert customer.cust_id and product_prod_id into the customer_product table.

Product table
-*prod_id
-prod_name

Customer table
-*cust_id
-username

Customer_products
-prod_id
-cust_id

How does that look?

Options: ReplyQuote


Subject
Written By
Posted
January 04, 2011 10:46PM
January 06, 2011 09:11PM
January 07, 2011 11:18PM
January 08, 2011 12:59AM
Re: Database efficiency question
January 08, 2011 10:02AM
January 08, 2011 10:38AM
January 08, 2011 11:02AM
January 16, 2011 03:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.