| Customer |
| CustId | Name | Sex | Education | IsStudent | Age | ContactNo |
| 1 | Rachit Rokad | 1 |
| 0 | 30 | 9375750578 |
| 2 | Poonam Makati | 2 | MCA | 1 | 25 | 9426244131 |
| 3 | Ayush Patel | 1 | 2 | 1 | 7 |
|
| 4 | Nenshi | 2 | BE-Comm | 0 | 22 |
|
| 5 | Yuti Vachhani | 2 | 8 | 1 | 12 |
|
| Supplier |
| SupplierId | Name | Sex | ContactNo |
| 1 | Rachit Rokad | 1 | 9375750578 |
| 2 | Vimal Patel | 1 |
|
| 3 | Parul Makadiya | 2 |
|
| 4 | Aarti Chapani | 2 |
|
| CustOrder |
| CustOId | CustID | Date | Total |
| 1 | 3 | 10-Feb-2010 | 1000 |
| 2 | 1 | 12-Feb-2010 | 1100 |
| 3 | 4 | 10-Apr-2010 | 800 |
| CustOrdeItem |
| CustOIId | CustOID | Item | Qty | Unit | Price |
| 1 | 1 | Colgate | 1 | Pcs | 25 |
| 2 | 1 | Grocery | 15 | KG | 20 |
| 3 | 1 | Shoes | 1 | Pcs | 675 |
| 4 | 2 | Plastic chair | 2 | Pcs | 300 |
| 5 | 2 | iron | 1 | Pcs | 500 |
| 6 | 3 | Bag | 1 | Pcs | 800 |
| Abbreviation |
| ID | Value | Type |
| 1 | Male | Sex |
| 2 | Female | Sex |
==============================================
Shradhdha Zalavadiya |Senior Software Engineer
WebMingle Technology
Accelerated by knowledge. Driven by values.
www.webMingle.in
No comments:
Post a Comment