Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Information about voucher sales, including customer details, branch details, product codes, quantities, prices, and total amounts. The data is organized into multiple tables, including customer info, voucher item info, product info, and staff info.
Typology: Exercises
1 / 26
This page cannot be seen from the preview
Don't miss anything!
Voucher No Customer Name Customer address V00001 Thandar Win G-5, Moe Kaung Street, Hlaing, Yangon V00002 Nilar H-4, Thit Sar Street, Oke Kyin, Yangon V00003 Thandar Win A-9,Kyaung Kone Street, Hlaing, Yangon V00004 Mying Maung C-9, Min Dahma Street,Kyaik Waing, Yangon V00005 Min Khant S-7, Oakkala Street, Insein, Yangon
Customer Phone Customer Email Branch Name Branch address 09-422846339 Lily-1 A-22, Junction Square, Yangon 09-999888777 Lily-2 B-66, Junction City, Yangon 09-444111333 Lily-1 A-22, Junction Square, Yangon 09-555999000 Lily-3 F-55, City Mall, Yangon 09-555222333 Lily2 B-66, Junction City, Yangon [email protected] [email protected] [email protected] [email protected] [email protected]
Quantity Price Amount Total 2, 3, 4, 2 25000, 45000, 15000, 70000 50000, 135000, 60000, 140000 385000 3, 5 15000, 70000 45000, 350000 395000 10, 5 45000, 70000 450000, 350000 800000 1, 3 50000, 70000 50000, 140000 190000 5 50000 250000 250000
Date Staff Name 14/12/2023 Phyu Sin 18/1/2023 Min Min 13/5/2023 Phyu Sin 16/5/2023 Maung Maung 15/6/2023 Min Min
Customer address Customer Phone Customer Email G-5, Moe Kaung Street, Hlaing, Yangon 09- G-5, Moe Kaung Street, Hlaing, Yangon 09- G-5, Moe Kaung Street, Hlaing, Yangon 09- G-5, Moe Kaung Street, Hlaing, Yangon 09- H-4, Thit Sar Street, Oke Kyin, Yangon 09- H-4, Thit Sar Street, Oke Kyin, Yangon 09- G-5, Moe Kaung Street, Hlaing, Yangon 09- G-5, Moe Kaung Street, Hlaing, Yangon 09- C-9, Min Dahma Street,Kyaik Waing, Yangon 09- C-9, Min Dahma Street,Kyaik Waing, Yangon 09- S-7, Oakkala Street, Insein, Yangon 09- [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected]
Date Staff Name 14/12/2023 Phyu Sin 14/12/2023 Phyu Sin 14/12/2023 Phyu Sin 14/12/2023 Phyu Sin 18/1/2023 Min Min 18/1/2023 Min Min 13/5/2023 Phyu Sin 13/5/2023 Phyu Sin 16/5/2023 Maung Maung 16/5/2023 Maung Maung 15/6/2023 Min Min
Customer Info Customer ID Customer Name C00001 Thandar Win C00002 Nilar C00003 Mying Maung C00004 Min Khant Voucher Info Voucher No Date V00001 14/12/ V00002 18/1/ V00003 13/5/ V00004 16/5/ V00005 15/6/ Branch Info Branch ID Branch Name B00001 Lily- B00002 Lily- B00003 Lily- Product Info Product code Category P0001 Sandals P0002 Boots P0003 Sandals P0004 Heels P0005 Sandals
Quantity Amount 2 50000 3 135000 4 60000 2 140000 3 45000 5 350000 10 450000 5 350000 1 50000 3 140000 5 250000
Customer Phone Customer Email 09- 09- 09- 09- Amount Branch Info 50000 Branch ID 135000 B 60000 B 140000 B 45000 350000 450000 350000 Product Info 50000 Product Code 140000 P 250000 P P P P Staff info Staff ID S S S [email protected] [email protected] [email protected] [email protected]
Voucher Info Voucher No Customer ID Branch Id Staff ID V00001 C00001 B00001 S V00002 C00002 B00002 S V00003 C00001 B00001 S V00004 C00003 B00003 S V00005 C00004 B00002 S Branch Name Branch address Branch Email Branch Phone Lily-1 A-22, Junction Square, Yangon 09- Lily-2 B-66, Junction City, Yangon 09- Lily-3 F-55, City Mall, Yangon 09- Category Price Sandals 25000 Boots 45000 Sandals 15000 Heels 70000 Sandals 50000 Staff Name Phyu Sin Min Min Maung Maung [email protected] [email protected] [email protected]
Table Name Customer Info Attributes Data type Null/Not Null Constraints Customer ID Varchar(10) Not Null Customer Name Varchar(30) Not Null Customer Address Varchar(50) Null Customer Phone Varchar(20) Not Null Check Customer Email Varchaar(50) Null Check Table Name Voucher Item info Attributes Data type Null/Not Null Constraints Voucher No Varchar(10) Not Null Product Code Varchar(10) Not Null Primary Key Identity(1,1),Check Foreign Key Composite primary key Foreign Key Composite primary key
Quantity Int Not Null Amount Int Not Null Table Name Product Info Attributes Data type Null/Not Null Constraints Product Code Varchar(10) Not Null Category Varchar(20) Not Null Table Name Staff Info Attributes Data type Null/Not Null Constraints Staff ID Varchar(10) Not Null Staff Name Varchar(20) Not Null Primary Key Identity(1,1),Check Primary Key Identity(1,1),Check
