aspose file tools*
The moose likes JDBC and the fly likes Basic Database help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Basic Database help" Watch "Basic Database help" New topic
Author

Basic Database help

Rumesh Eranga
Ranch Hand

Joined: Jan 26, 2011
Posts: 34
Hello people,
I am new to databases. on a question book,i found the belowing question and i were confused.Please somebody help me.

Sales Order Processing system has the following entities each stored in a table.
• Product
􀂃 Product Code
􀂃 Product Name
􀂃 Qty available
􀂃 Price
• Customer
􀂃 Customer No
􀂃 Customer Name
􀂃 Customer Address
• Order
􀂃 Order No
􀂃 Customer No
􀂃 Order Date
• Order Details
􀂃 Order No
􀂃 Sequence No
􀂃 Product No
􀂃 Sales Price
􀂃 Qty Ordered

Identify the for each of the table

• Indices with Duplicate attributes



Thank you
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

This looks like it might be a homework assignment. Can you please tell us which book it is from?
Rumesh Eranga
Ranch Hand

Joined: Jan 26, 2011
Posts: 34
It is not a assignment actually. The book i got from the workshop where i work as a trainee employe.
Even tho the book is company confidential, i've added image of the page on below link.

http://img843.imageshack.us/i/77538010.png/

I don't need you to write the answer for me, but tell me what does "Indices with Duplicate attributes" means.It would be much grateful if you can give me an example.

Thank you
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

the question asks you to
1) identify the primary key for each table
2) Indices with Duplicate attributes ie non-unique index attributes

so firstly, do you know what an index is, and can you identify indexed attributes that will not be unique (hint foreign keys are a good start)
Rumesh Eranga
Ranch Hand

Joined: Jan 26, 2011
Posts: 34
Now i can understand.Thank you very much Mr.David for the explanation.
Juniors like me have lot to learn from seniors like you.
Thank you again.
 
wood burning stoves
 
subject: Basic Database help