Lab 5

Course: CSCI 2020

Database Design and Creation

• I wasn’t too sure whether I should keep the tables’ casing how it says in the ‘Table Name’, or if I should use the same convention as the other tables, but I just did what it said in the table, which ended up being PascalCase, rather than the SCREAMING_SNAKE_CASE that the other tables are in.
• For pet statuses, I decided on ‘Available’, ‘Sold’, and ‘Pending’ since there weren’t any specific specifications on what they should be.
  • I did something similar for the other things that needed to match specific records, such as credit_status and payment_method
• Also, since Products has a foreign key to Suppliers, I had to make sure that Suppliers was created before, otherwise I received error messages since the constraint wasn’t met.

Data Population

I thought that writing all of this data would be tedious, I decided to use AI to complete the data after I generated the first few examples.

Basic Intelligence Gathering

• I wasn’t too sure whether each questions’ parts a, b, and c were just for a single query, or whether they should be separate, but I decided to do them separately.

Species Available Report

• 1.A
• 1.B
• 1.C
• 2.A
• 2.B
• 2.C
• 3.A
• 3.B
• 3.C
• 4.A
• 4.B
• 4.C
• 5.A
• 5.B
• 5.C