86|EXCEL – Smarty’s School Supplies

Challenges
, , ,
81

Challenge86_solution_FaithCall.xlsx (11.1 KB)
my solution :)))))

82

MJTechHubChallenge86.xlsx (14.3 KB)
Here’s my solution!

83

Here’s my solution!
Oct 23 TechHub Challenge.xlsx (10.1 KB)
Thanks for teaching me about Normalization!

84

Here is my solution!
Smartys School Supplies.xlsx (17.0 KB)

85

Fun challenge! This is my solution.

Challenge86_Data.xlsx (13.7 KB)

86

Solution
Challenge86_Data.xlsx (14.5 KB)

87

Challenge86_Data.xlsx (14.7 KB)

Here is my solution!

88

Challenge86_Data.xlsx (10.0 KB)

89

Challenge86 Solution.xlsx (17.8 KB)
Here is my Solution!

90

Challenge86_Data.xlsx (10.8 KB)

91

Challenge86_Data.xlsx (11.0 KB)

92

Here is my solution! I did it differently than the original, but I think it’s okay because the only difference I saw was that the date was in OrderDetails instead of as a primary key. I don’t think it’s necessary as part of the primary key because it can be stored in the OrderDetails. You cannot have two dates on one Invoice Number.
Challenge86_Data.xlsx (16.7 KB)

93

Here is my solution!
Challenge86_Data.xlsx (9.5 KB)

94

Challenge86_Solution.xlsx (14.5 KB)
This was a really good refresher on data normalization!

95

Good challenge that only took about 10 minutes to practice nominalization
Copy of Challenge86_Data.xlsx (12.4 KB)

97

Copy of Challenge86_Data.xlsx (12.4 KB)
About 15 minutes

98

Here was my idea!

TechHubSmarty’sSupplies.xlsx (12.9 KB)

99

Enjoyed the challenge! It was a good refresher!
Challenge86_Data.xlsx (14.2 KB)

100

Here is my solution:

Challenge86_SolutionRyan.xlsx (16.2 KB)

101

Here is my solution.
Challenge86_Data(3).xlsx (14.2 KB)

It took about an hour.
It was not terribly difficult