Problem I (50 Points): Pet Store (Data File needed for this exercise: None): 50 Points A pet store owner wants to create a database for the store. The database needs to include information about animals and the breeds of the animals. The pet owner wants to keep records of the purchases and the customers that bought each animal. You'll need to decide what tables required to keep purchase and customer records. You'll also need to decide what relationships you want to create. Database Creation and Setup (a) Start Access, click Blank database. Browse to where you are storing your data files and name your database PetStore. Click Create to create the database. (b) Design a table to store breeds. Use the following fields: BreedID, AnimalType, BreedName, MaximumSize (in pounds), LengthOfLife (in years). Assign BreedID to be the primary key with the AutoNumber data type. For all other fields, enter appropriate data types, descriptions, and field sizes. Save your table as tblBreed (c) Enter the following records into the tblBreed table (in this order): BreedID AnimalType BreedName MaximumSize | LengthOfLife 1 Dog Akita 110 12 LAWN Dog Papillon 9 15 Cat Devon 7 18 Cat Birman 10 19 Chinchilla Silver Mosaic 1 15 (d) After entering these five breeds, add five more breeds of your choice to the table (You can use Google search to find more info on pet breeds and their life expectancy). (e) Import the Animals table from the Excel file provided (Animals.xIsx). Assign AnimalID to be primary key. BreedID is the foreign key to tblBreed. For all fields, enter appropriate data types, descriptions, and field sizes (e.g. Currency, text, lookup. ..etc.). Save your table as tblAnimal. f) After importing the ten animals, add five more animals which are type of the breeds you have entered in the prior table. (@) In the tblAnimal add a new field called petImage to store a photo of each animal (You can use Google image to find 15 small size images for your pets). (h) Open the Relationships window. Create a one-to-many relationship between BreedID in tblBreed and BreedID in tblAnimal. Enforce referential integrity and allow Cascade update related fields. Do not cascade delete. (i) Determine the tables that the store owner would need to keep store customers and their purchases. Design these tables and the appropriate fields. Make sure to assign primary keys. Create relationships between these new tables and your existing tables as appropriate. Hint: The Customer table should at least include fields related to personal information such as customer ID, name, phone, home address and email address. The Purchase table should include purchase ID, purchase date, customer ID and animal ID