───✱*.。:。✱*.:。✧*.。✰*.:。✧*.。:。*.。✱ ───
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 theSCREAMING_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
andpayment_method
- I did something similar for the other things that needed to match specific records, such as
- Also, since
Products
has a foreign key toSuppliers
, I had to make sure thatSuppliers
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
───✱*.。:。✱*.:。✧*.。✰*.:。✧*.。:。*.。✱ ───