Write a single file named A04.sql. Include use cinf201_myname at the top (where myname is your username). Choose at least 10 Pokmon (from this list), at least 10 abilities, and at least 10 moves, and all relevant "types" for the Pokemon you've chosen. Create tables with proper foreign keys to satisfy the kinds of queries listed below, and write "insert" queries to add the facts you've chosen. Your tables must be named with pok_ at the beginning of every table name. Write at least one example "select" query for each of the following:
Show Pokmon names and HP sorted by HP.
Show abilities for a specific Pokemon.
Show Pokmon with certain abilities (e.g., Snow Warning, Soundproof, etc.).
Show Pokemon that are certain types (e.g., Grass, Ice, etc.).
You do not need to include any more information than what is necessary for those queries. Your tables must be normalized according to the definition from our notes.
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference
and should not be submitted as is. We are not held liable for any misuse of the solutions.
Please see the frequently asked questions page
for further questions and inquiries.
Kindly complete the form.
Please provide a valid email address and we will get back to you within 24 hours.
Payment is through PayPal, Buy me a Coffee
or Cryptocurrency.
We are a nonprofit organization however we need funds to keep this organization operating
and to be able to complete our research and development projects.
