Question: For this weeks addition, you will add a new table that indicates the cost for each pet in the table you created for Week 5

For this weeks addition, you will add a new table that indicates the cost for each pet in the table you created for Week 5. If you didn't use the pets table in Week 05, you will need to contrive a new table that aligns logically and conceptually with your previous work. This week, you will create a new table that will have to join the initial table you made with each pet. In this table, the primary ID for the table you created in Week 5 will be a foreign key in the new table you are creating for this week. In the new table, include the following fields:uniqueID (You name it the way you want)salePriceisStillForSale (True / False field)createTimeStampcreatedByupdateTimeStampupdatedByThe second step for the use case is showing the query needed to join the two tables together. You should pick one or more columns from each table that would be useful and interesting to your end-user. In this case, assume your end-user is the owner/manager of the pet store (or some other business if you built your own tables in Week 05). Note that some columns are of no value to end-users. Use an Inner Join for this query. Remember that you only want to return fields with data related to the pet. (For example, no date information outside of the pet's date of birth.) The only field included in the petSalePrice table should be the salePrice for the animal.Provide a paragraph outlining the thought process behind the table being created and the general business case that could be solved with the referenced query.Once youve created the join, create a view so the query can be utilized by just selecting from the view.Please include the query used to create the new database table along with the query used to complete the insert statement.The files submitted should include the followingA word document for the following:Provide a paragraph outlining the thought process behind the table being created and the general business case that could be solved with the referenced query.This document should clearly explain your thought process for building the query. You are demonstrating your understanding of what you're learning. You're solving a business problem for your end-user. LPT: one or two sentences is almost certainly insufficient. Either a separate .sql file for each query or a single .sql file that contains all requested queriesThere should be no queries contained within the word document. The word document should solely contain your thoughts related to the use case.(Your queries need to reflect your OWN thought process and show variances to the example provided since you will be solving your business concern.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!