SRS Document on Phone accessory store sample template provided
viquar4u
phoneaccessstore.accdb| cust_id | f_name | l_name | Strt_addrs | City | State | Zip | reg_date |
|---|---|---|---|---|---|---|---|
| 1 | zohair | kazim | 96 langs rd | melbourne | vic | 3032 | 4/20/18 |
| 2 | anwar | lal | 89 rd | melbourne | vic | 3034 | 4/23/18 |
| 3 | viquar | uddin | 96 langs rd | melbourne | vic | 3000 | 4/25/18 |
| delivery_id | cust_name | seller_name | product_name | delivery_status |
|---|---|---|---|---|
| 1 | 2 | 2 | 1 | false |
| product id | product_name | seller_id | price |
|---|---|---|---|
| 1 | iphone 7 back cover | 1 | 4$ |
| 2 | iphone 7 display | 1 | 15$ |
| 3 | samsung s8 battery | 2 | 50$ |
| seller_id | f_name | l_name | company_name | strt_adrs | city | state | zip |
|---|---|---|---|---|---|---|---|
| 1 | younus | ali | craft exp | 37 gref rd | melbourne | vic | 3000 |
| 2 | imran | mohammed | back cover | 45 park st | melbourne | vic | 3000 |
PARAMETERS __product id Value;
SELECT DISTINCTROW *
FROM delivery_stat AS product_data
WHERE ([__product id] = product_name);
SELECT DISTINCTROW *
FROM cust_data;
SELECT [seller_data].[seller_id], [seller_data].[f_name], [seller_data].[l_name]
FROM seller_data
ORDER BY [l_name];
SELECT DISTINCTROW *
FROM product_data;
SELECT [product_data].[product id], [product_data].[product_name]
FROM product_data
ORDER BY [product_name];
SELECT [seller_data].[seller_id], [seller_data].[f_name], [seller_data].[l_name], [seller_data].[company_name]
FROM seller_data
ORDER BY [company_name];
SELECT [cust_data].[cust_id], [cust_data].[f_name], [cust_data].[l_name]
FROM cust_data
ORDER BY [l_name];
SELECT DISTINCTROW *
FROM delivery_stat;
SELECT DISTINCTROW *
FROM seller_data;
