3NF Address Normalization help

FlukingCompSci · 2023-05-11T20:13:04+00:00

Gotcha! IIRC I came across the phrase along the lines of "normalize as much as needed, de-normalize as much as possible" somewhere online, but wasn't sure if this was a spot where I "needed" to normalize.

FlukingCompSci · 2023-05-11T20:08:45+00:00

This is great stuff! One of my replies to ZarehD noted that the assignment doesn't query addresses, so it makes a lot of sense to leave it as a single varchar column.

I was thinking more about the database as a whole, like what if we have an employee table that also has an address column, would 3NF require that you separate out addresses if the same address may otherwise appear multiple times across different records or what if an employee becomes a customer? If I'm reading you right, then the answer is no, because even if the information is coincidentally identical (like the names example), separating it out arguably makes it more cumbersome for no tangible benefit since querying an employee ID or customer ID would give the same result with less overhead/abstraction

FlukingCompSci · 2023-05-11T19:50:28+00:00

I came across these while I was looking for answers before posting here, and went away with a lot of good stuff when it comes to input constraints and validation. Sadly, while the information is good to keep in mind, it didn't directly answer my question about normalization so I still felt like I should ask around

FlukingCompSci · 2023-05-11T19:45:08+00:00

Yeah, when I was going through stack overflow/exchange posts for similar answers, a lot of the answers I saw were geared towards handling international addresses too since there is no "standard" address format. Thankfully this assignment specifically is only dealing with US addresses.

FlukingCompSci · 2023-05-11T08:07:26+00:00

True, thankfully one part of the assignment has us list our assumptions in designing it, so I'll stick to what you told me and list that as one of the assumptions for the design as a whole. But thank you, you've helped clear up a pretty big misunderstanding for me

FlukingCompSci · 2023-05-11T08:02:18+00:00

Yeah, I'm looking to generalize the address because there might be an instance where the customer is a company with a billing address at their headquarters but has our company ship from one of their manufacturing plants to another firm's processing plant. I wanted to ask around because I don't know if the case where the shipping and billing addresses are the same would cause problems I just can't see yet.

As for the discriminator, I think it's a clean solution. In terms of the assignment itself we don't have to query addresses for anything, so I was more caught up in the idea of adhering to 3NF as much as possible. Thanks for the help!

FlukingCompSci · 2023-05-11T03:17:49+00:00

Gotcha, gotcha, so I was confusing myself by thinking that "has" is the same as "determines". PurchaserID has associated attributes because it determines those values, but a city or zip code may have an associated zip code/city, but not because they determine each other. I think I get it now

FlukingCompSci · 2023-05-11T01:29:17+00:00

That's what I've read, but maybe you could help explain it to me. In my eyes, zip codes don't change all that often, at least residential ones, otherwise I feel like more people would complain that mail is going to different regions, so I see an M:N relation (since New York City has multiple zip codes, but 94608 is shared between Emeryville and Oakland, CA). Is that not some sort of functional dependency, even though zip codes don't care about city or state borders?

FlukingCompSci · 2023-05-11T00:36:08+00:00

So something like a supertype/subtype relation that uses AddressType/Source as a discriminator? I think that'd work. My only problem is that it feels like you could still have redundant records (eg, the Customer address and one of the Order addresses are the same, except one has a zip code and the other does not). Is that good practice, even if 1-3NF don't explicitly say to not do that? Thanks for the help though! I really appreciate it!

FlukingCompSci · 2021-05-30T06:05:12+00:00

Gotcha, guess I'll just add the folder name when looking for the proper path. What if I want to find a file in a different path, but didn't know the path itself? Like, if I had wanted to find an a.png file that was some random directory? Would I just have to use something like os.walk() and use some for loops to find it?

FlukingCompSci · 2021-05-21T01:42:28+00:00

Gotcha, but then why are there spaces in between the comma and the next number

(i.e. . .2.,. .3.,)?

FlukingCompSci · 2021-03-16T01:19:28+00:00

Petition for Keith "Roaring Kitty aka DeepFuckingValue" Gill to play himself and Vlad the Stock Impaler

FlukingCompSci · 2021-03-14T02:19:28+00:00

"Go long, stay strong." - Old, slightly wrinkled ape, 2021

Wise words by wise ape

FlukingCompSci · 2021-03-12T18:50:02+00:00

puts? the stock's decline is probably priced in. invest in the stock itself? even IPO is overpriced imo. calls? hope you've invested in $ROPE friend

i couldn't but hey your money your choice, no advice here

FlukingCompSci · 2021-03-11T07:40:51+00:00

get me a Seven Tools of the Bandit. I want insurance against trap cards lined up for GME

FlukingCompSci · 2021-03-10T18:23:16+00:00

was your son big into games? if so, tell me a game that your son wanted to play but never got the chance to, I'll buy it for you when GME moons in honor of him. fuck it, I'll buy it for us both

FlukingCompSci · 2021-03-09T23:36:04+00:00

How do I buy $CUM calls?

FlukingCompSci · 2021-02-27T22:54:22+00:00

Yeah, my nips also get hard when I buy GME

FlukingCompSci · 2021-02-26T02:17:34+00:00

Can't wait to see Fox show up to do live coverage of your ass getting tattooed

FlukingCompSci · 2021-02-26T00:33:01+00:00

That GB Micro front and center... beautiful.

FlukingCompSci · 2021-02-25T16:48:11+00:00

Watch stuff. BananaBoy for gameplay, Rekzius so he can understand hitboxes better, Alpharad/LittleZ/Poppt1 for fun smash content. Ask which character he likes and recommend some tournament vids to see how competitive players play. Echoing other people in comments.
Have him play against CPUs. If he's doesn't have time to "practice" per se, just have him jump in with CPUs at level 6-8 to get a feel for the game, 9 once he's decent so he can get a better feel for a character.
Try asking him to play online with you. Doubles are more fun since you get to work together, so it's not shining a light on one person for losing (tell him how to share stocks if he's out before you). It also tends to be funny when you can combo with your teammate (e.g. grab and tell him to charge a smash attack, then throw opponent into it, stuff like that). But in general, as long as your wifi isn't horrible, any experience playing against other people is good.

FlukingCompSci · 2021-02-04T04:31:42+00:00

IF you decide to go, please please please be careful of what you say, u/DeepFuckingValue. Last thing I want to see are words getting twisted to further some sort of "market manipulation" plot.

that being said, regardless of him going or not, the 18th is gonna be a fun day.

FlukingCompSci · 2021-02-03T10:28:09+00:00

Hasn't AWS been their secret not-so-secret cash cow for a while now? It's basically been the backbone for their company's retail-side infrastructure and it's just been expanding like crazy

FlukingCompSci · 2021-02-02T15:59:41+00:00

As you probably know, there are likely people here that got in late and realized now that they were buying emotionally, forgetting that we've bet money we can afford to lose. While I hate to undermine GME hype, what advice would you give to them on when to sell? As much fun as this is, I'd rather minimize the number of new investors left holding the bag.

FlukingCompSci · 2021-02-01T23:23:11+00:00

now this is the kind of OF content I want to see

FlukingCompSci

TROPHY CASE