wk3 - 10.11 .22 2nd Project in MySQL
Posted: Fri Sep 16, 2022 7:47 am
10.11.22 2nd Project in MySQL
The next step is to discuss 4 to 6 new MySQL queries that deliver more detailed information or are more complex in their design. Consider what we learned from the first assignment.
. Get more precise and detailed results.
. Do not limit your search to the Dewey classification as most items in the database are not Dewey, and it may be interesting to see why some are classified in Dewey and others not.
. Make sure that the results are true to your search, so that there is no ambiguous information, for instance Shaokang's "Headphones" referred to both a musical cd but also people checking out headphones in the library.
. Share the sequence of rewrites Its interesting for the class to share how you evolved your query from a less efficient to a more efficient version.
. Check the Library's online search tool to see if something you got is actually what it is: https://seattle.bibliocommons.com/v2/se ... New+Titles
. A database is an evolving thing. Our negotiations with the library resulted in getting data starting in 2006, and since then classifications, categories of things, or for instance, Itemtypes: https://www.mat.ucsb.edu/~g.legrady/aca ... mTypes.pdf have been added or been reduced. For instance, checkout of cdroms, VHS tapes, are rarely checked out today, but maybe they continue to be looked at.
The next step is to discuss 4 to 6 new MySQL queries that deliver more detailed information or are more complex in their design. Consider what we learned from the first assignment.
. Get more precise and detailed results.
. Do not limit your search to the Dewey classification as most items in the database are not Dewey, and it may be interesting to see why some are classified in Dewey and others not.
. Make sure that the results are true to your search, so that there is no ambiguous information, for instance Shaokang's "Headphones" referred to both a musical cd but also people checking out headphones in the library.
. Share the sequence of rewrites Its interesting for the class to share how you evolved your query from a less efficient to a more efficient version.
. Check the Library's online search tool to see if something you got is actually what it is: https://seattle.bibliocommons.com/v2/se ... New+Titles
. A database is an evolving thing. Our negotiations with the library resulted in getting data starting in 2006, and since then classifications, categories of things, or for instance, Itemtypes: https://www.mat.ucsb.edu/~g.legrady/aca ... mTypes.pdf have been added or been reduced. For instance, checkout of cdroms, VHS tapes, are rarely checked out today, but maybe they continue to be looked at.