DATABASE basics Help needed!!!!

[rehrumesh]

hay guys... plz help me on followin question...

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

 

[madbuddy]

machan ubata oona dee thawa discribe karoth help 1k denna puluwan wei./..

 

[rehrumesh]

machan ubata oona dee thawa discribe karoth help 1k denna puluwan wei./..

prashnetama thibbe okai, candidate key tika identify karandai witharai ban..

 

[madbuddy]

mata question 1i therenneththe ban..... eeka theerunaanam asnwr 1 geemak nee..identify the for each kiyanne mokakda? :O

 

[madbuddy]

Identify the primary key for each of the tableda danne question 1 needa?

 

[rehrumesh]

na macho. eke kiyanne , hama table ekakama Indices with Duplicate attributes tika identify karanda kiyala. for each kiuwe hama table ekakatama...

 

[Topology]

meka mokkada kerenne ona?
Database design karana hati man dannava.
mulinma haduna ganna entities
eva thami
Product,Customer,Order
othana Order details kiyanneth Attribute ekak Order kiyana entitiy eke eka nisa eka ganna ema table ekatama

ham table ekakma Normalize karanna,eka nisapromary key,foregin keys danna.
evata kiyanna relational databases kiyali.

menna me vidiyata tables hadala database eka design karanna

Product

• Product ID (Primary Key)
• Product Name
• Price
• Preorder Level

• Customer

• �� Customer No
• �� Customer Name
• �� Customer Address

• Order

• �� Order No
• �� Order Date
• �� Discount Rate.
• �� Qty Ordered
• Customer NO (Foreign Key)

Product-Order Table (this is for many to many relationship)

• Product ID (Primary Key)
• Order No (Primary Key)

so one customer can have many orders, but one order can have only one customer. then that's a one to many relationship.

product order have many to many relationship cause one product can have many orders, and one order can have many product. as a normalize result you got another table which is so called product-order table.

 

[shan_n95]

product numbr primary product code foreing

 

[rehrumesh]

meka mokkada kerenne ona?
Database design karana hati man dannava.
mulinma haduna ganna entities
eva thami
Product,Customer,Order
othana Order details kiyanneth Attribute ekak Order kiyana entitiy eke eka nisa eka ganna ema table ekatama

ham table ekakma Normalize karanna,eka nisapromary key,foregin keys danna.
evata kiyanna relational databases kiyali.

menna me vidiyata tables hadala database eka design karanna

Product

• Product ID (Primary Key)
• Product Name
• Price
• Preorder Level

• Customer

• �� Customer No
• �� Customer Name
• �� Customer Address

• Order

• �� Order No
• �� Order Date
• �� Discount Rate.
• �� Qty Ordered
• Customer NO (Foreign Key)

Product-Order Table (this is for many to many relationship)

• Product ID (Primary Key)
• Order No (Primary Key)

so one customer can have many orders, but one order can have only one customer. then that's a one to many relationship.

product order have many to many relationship cause one product can have many orders, and one order can have many product. as a normalize result you got another table which is so called product-order table.

Machan mata me tika nam therenawa.mata therunne naththe indices with duplicate attributes kiyana eka...

rep denda widiyak naalu broo

product numbr primary product code foreing

hariyatama therune na machan.thawa tikak kiyala dendako

 

[h_abeysinghe]

හ්ම්ම් මෙක නම් දන්නෙ නැ එත් ඔන්න මගෙන් බම්ප් එකක්

 

[rehrumesh]

හ්ම්ම් මෙක නම් දන්නෙ නැ එත් ඔන්න මගෙන් බම්ප් එකක්

aulak na machoo.. bump ekaata sthuthi...

 

[idhasitha]

uba kiyana denam terenne na banzzz

Product primary key --Product Code
Customer primary key --Product Customer No
Order primary key --Order No
Order Details primary key---Order No

Order Details kiyana eke Order No eka Order Details table eke Order No references widiyata ganin

 

[Topology]

eka thami mama duplicate attributes ain karala Normalized karala dunna Database eka.
duplicates attribute kiyanne, repetitive vena attributes ekaam table eke, anika entities 2k ho vadi ganak eka ha samana nam oyata puluwan e deka ektu karala, duplicate vena attributes vena table ekakata danna,. ena thami normalize karanava kiyanna

 

[h_abeysinghe]

onna thawath bump ekak