Advertisements
Advertisements
Question
Create a table - Product with fields-pid, pnm, pdesc, pmonth, pwt, prate etc.
Very Short Answer
Advertisements
Solution
| Field Name | Suggested Data Type | Description |
|---|---|---|
| pid | Integer | Product ID |
| pnm | Text | Product name |
| pdesc | Text | Product description |
| pmonth | Text | Month of product entry/manufacture |
| pwt | Decimal / Number | Product weight |
| prate | Decimal / Currency | Product rate or price |
shaalaa.com
Is there an error in this question or solution?
