This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills: The software developer's life manual and have John Sonmez on-line!
See this thread for details.
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Basic Database help

 
Rumesh Eranga
Ranch Hand
Posts: 34
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This looks like it might be a homework assignment. Can you please tell us which book it is from?
 
Rumesh Eranga
Ranch Hand
Posts: 34
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic