1. Create a database named “DB_Normalization”.
2. Create table “TBL_CustomerTransaction”
3. Insert the 40 unnormalized data:
OrderI CustomerNa CustomerAddr Customer ProductNa ProductCate ProductPr OrderD SalesPers TotalOrderAm PaymentMet
D me ess City me gory ice ate on ount hod
01 John Smith 123 Elm St New York Laptop Electronics 1200 2023-01- Alice 1200 Credit Card
15
002 Jane Doe 456 Oak St Chicago Smartphon Electronics 800 2023- Bob 800 Debit Card
e 02-10
003 John Smith 123 Elm St New York Headphone Accessories 150 2023- Alice 1350 Credit Card
s 03-05
004 Sam Wilson 789 Pine St Los Smartwatc Electronics 250 2023- Carol 250 Cash
Angeles h 03-20
005 Anna Lee 321 Maple Ave Boston Tablet Electronics 600 2023- David 600 Credit Card
03-25
006 John Smith 123 Elm St New York Keyboard Accessories 100 2023- Alice 100 Credit Card
04-01
007 Emily Davis 654 Birch Rd Miami Laptop Electronics 1200 2023- Bob 1200 PayPal
04-10
008 Peter Parker 111 Spider Ln New York Mouse Accessories 50 2023- Carol 50 Credit Card
04-15
009 Jane Doe 456 Oak St Chicago Laptop Accessories 70 2023- Bob 870 Debit Card
Case 04-20
010 John Smith 123 Elm St New York Monitor Electronics 300 2023- Alice 1450 Credit Card
04-25
011 Chris Evans 987 Cedar St Dallas Gaming Electronics 500 2023- Carol 500 Cash
Console 05-01
012 Anna Lee 321 Maple Ave Boston Smartphon Accessories 30 2023- David 630 Credit Card
e Case 05-05
013 Emily Davis 654 Birch Rd Miami Tablet Electronics 600 2023- Bob 600 PayPal
05-10
014 Sam Wilson 789 Pine St Los Headphone Accessories 150 2023- Carol 400 Cash
Angeles s 05-15
015 Peter Parker 111 Spider Ln New York Smartwatc Electronics 250 2023- Alice 250 Credit Card
h 05-20
016 Jane Doe 456 Oak St Chicago Gaming Electronics 500 2023- Bob 570 Debit Card
Console 05-25
017 Chris Evans 987 Cedar St Dallas Laptop Electronics 1200 2023- Carol 1200 Cash
06-01
018 John Smith 123 Elm St New York Smartphon Electronics 800 2023- Alice 800 Credit Card
e 06-05
019 Sam Wilson 789 Pine St Los Monitor Electronics 300 2023- Carol 300 Cash
Angeles 06-10
020 Anna Lee 321 Maple Ave Boston Mouse Accessories 50 2023- David 50 Credit Card
06-15
021 Emily Davis 654 Birch Rd Miami Laptop Electronics 1200 2023- Bob 1200 PayPal
06-20
022 John Smith 123 Elm St New York Keyboard Accessories 100 2023- Alice 100 Credit Card
06-25
023 Peter Parker 111 Spider Ln New York Smartphon Electronics 800 2023- Carol 800 Credit Card
e 07-01
024 Jane Doe 456 Oak St Chicago Tablet Electronics 600 2023- Bob 600 Debit Card
07-05
025 Sam Wilson 789 Pine St Los Laptop Accessories 70 2023- Carol 370 Cash
Angeles Case 07-10
026 Anna Lee 321 Maple Ave Boston Monitor Electronics 300 2023- David 350 Credit Card
07-15
027 Emily Davis 654 Birch Rd Miami Gaming Electronics 500 2023- Bob 500 PayPal
Console 07-20
028 John Smith 123 Elm St New York Laptop Electronics 1200 2023- Alice 1200 Credit Card
07-25
029 Chris Evans 987 Cedar St Dallas Headphone Accessories 150 2023- Carol 150 Cash
s 08-01
030 Peter Parker 111 Spider Ln New York Smartwatc Electronics 250 2023- Alice 250 Credit Card
h 08-05
031 Jane Doe 456 Oak St Chicago Keyboard Accessories 100 2023- Bob 700 Debit Card
08-10
032 Anna Lee 321 Maple Ave Boston Laptop Accessories 70 2023- David 370 Credit Card
Case 08-15
033 John Smith 123 Elm St New York Smartwatc Electronics 250 2023- Alice 250 Credit Card
h 08-20
034 Peter Parker 111 Spider Ln New York Monitor Electronics 300 2023- Carol 300 Credit Card
08-25
035 Emily Davis 654 Birch Rd Miami Smartphon Electronics 800 2023- Bob 800 PayPal
e 08-30
036 Sam Wilson 789 Pine St Los Gaming Electronics 500 2023- Carol 500 Cash
Angeles Console 09-05
037 Chris Evans 987 Cedar St Dallas Tablet Electronics 600 2023- David 600 Credit Card
09-10
038 Jane Doe 456 Oak St Chicago Headphone Accessories 150 2023- Bob 650 Debit Card
s 09-15
039 Anna Lee 321 Maple Ave Boston Mouse Accessories 50 2023- David 350 Credit Card
09-20
040 Emily Davis 654 Birch Rd Miami Laptop Electronics 1200 2023- Bob 1200 PayPal
09-25
Note: On the 21st and 31st rows, change the CName, CAdd, CCity into your personal name and address.
4. Create a compilation of each set code that you have accomplished.
5. Screenshot or photograph the set code and paste it into the MS docx.
Ex: Create a table.
6. Submit your file on Google Classroom. The link will be sent on your GC.
