learn-co-curriculum / dsc-1-05-12-one-to-many-and-many-to-many-joins Goto Github PK
View Code? Open in Web Editor NEWLicense: Other
License: Other
I'm not sure if this is an issue or a lack of my understanding of SQL, but the example for one-to-one and one-to-many seem to be the same type of join.
In explaining the one-to-many joins it says,
"Here we join products with product lines. There are only a few product lines that will be matched to each product. As a result, the product line descriptions will be repeated in our resulting view."
But this applies to the previous example that is listed as a one-to-one join. I could write the exact same description of the that table.
"Here we are joining employees to offices. There are only a few offices that will be matched to each employee. As a result the office descriptions will be repeated in our result view."
Also the line "there are only a few product lines that will be matched to each product," Is slightly confusing. On my first read I thought it was saying that a product could be matched to multiple product lines. I think if you say something like, "Multiple products will map to the same product line." it might be clearer.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.