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 If you didn't use the pets table in Week 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 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 wantsalePriceisStillForSale True False fieldcreateTimeStampcreatedByupdateTimeStampupdatedByThe 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 enduser. In this case, assume your enduser is the ownermanager of the pet store or some other business if you built your own tables in Week Note that some columns are of no value to endusers. 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 enduser. 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
