You viewed two video resources, Designing a Database and Relational Schema of the "Priscilla/Dave" project. At the end of the logical design phase, there were five tables (Pet, PetOwner, IdTag, PetFood, and Toy). (a) Find the names of pets owned by anyone whose first name is John. Note: Use the SELECT command. (b) As there is a many-to-many relationship (between Pet and Toy) that cannot be expressed in a Relational database, an additional table (PetToy) was introduced that links the two tables. Thus, the final design is: Priscilla is interested in providing additional services to her customers, as well as having a better control on her toys and food suppliers. For additional services, she wants to add to the database the names of veterinary doctors in the neighborhood. Each customer could choose the vet he or she wants to work with, and that vet will treat all the customers' pets. Priscilla also likes to add supplier data to her database. Each PetFood item is supplied by just one FoodSupplier (but a supplier can supply many food items). A Toy can be supplied by multiple ToySuppliers. A ToySupplier can supply many Toys. Extend the design to include Veterinarians, PetSuppliers, and ToySuppliers

Exploring_e01_Grader_IR.xlsx Start Excel. Open the downloaded Excel file named Exploring_e01_Grader_IR.xlsx.On the Session1 worksheet, in cell A3, enter Start Date as the text. In cell B3, enter 7/7/11 as the date.On the Session1 worksheet, in cell E7, create a formula that will calculate the session fee with member discount.On the Session1 worksheet, change the value in cell D8 to 280, and then clear the contents in cell A13.On the Session1 worksheet, in cell H7, create a formula that will calculate the total fees collected for the Introduction to Watercolor class.On the Session1 worksheet, use the fill handle to copy the formulas in cells E7 and H7 down through row 11.Display the formulas on the Session1 worksheet, and then hide the formulas on the spreadsheet. Delete the worksheet labeled Sheet1.On the Session1 worksheet tab, insert a new row above row 5.On the Session1 worksheet, move the range A3:B3 to A14:B14.On the Session1 worksheet, delete row 3.On the Session1 worksheet, copy the range A5:E11. Click on the Class Fees worksheet tab, and then paste the copied range into cell A4.On the Class Fees worksheet, change the width of column A to 30.00 (215 pixels). Change the width of columns D and E to 14.57 (107 pixels).On the Session1 worksheet, copy the range A1:H2. Paste the values (without formatting) onto the Class Fees worksheet in cell A1.On the Class Fees worksheet, merge and center the text in cell A1 across the range A1:E1, and then merge and center the text in cell A2 across the range A2:E2.On the Class Fees worksheet, select the range A4:E5 and add a bottom border. With the range still selected, change the fill color to Tan, Background 2.On the Class Fees worksheet, apply the Accounting Number format with zero decimal points to the range D6:E10.On the Class Fees worksheet, change the page setup options so that the data is centered horizontally on the page.On the Class Fees worksheet, create a header that will display the text Class Fees in the center section of the header area. Print preview the Class Fees worksheet. Return to Normal view.

Discuss the overall process of developing new software.  Please also note the differences between software development and methods.