This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Basic Database help Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Basic Database help" Watch "Basic Database help" New topic
Author

Basic Database help

Rumesh Eranga
Ranch Hand

Joined: Jan 26, 2011
Posts: 33
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: 33
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: 33
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.
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Basic Database help
 
Similar Threads
Customer Order project
XML and XSLT not working
transferring database
How to iterate multiple list in an object?
pass the values from HTML to jsp page