IEW:InstructionsPrevious AttemptsBest PracticesIndependent Project 2-5Life’s Animal Shelter wants to expand the database created in the Independent Project 1-5 . To ensure consistency, the starting file is provided for you. In this project, you use Design view to create a second table, edit field properties, integrate data integrity rules, and enter data. You also create a relationship between the two tables and enforce referential integrity constraints. Finally, you add data using the relationship between tables.[Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.6]File Needed: LifesAnimalShelter-02.accdb (Available from the Start File link.)Completed Project File Name: [First Name.Last Name]-LifesAnimalShelter-02.accdbSkills Covered in This ProjectCreate a table using Design view.Add fields into a table.Edit field properties in Design view.Create an input mask.Create a validation rule and validation text.Save a table.Enter records.Create a foreign key.Create a 1:M relationship between tables.Enforce referential integrity.View a table in Datasheet view and expand related records. Open the LifesAnimalShelter-02 database file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Enable content in the security warning.Create a new table using Table Design. Add the fields in Table 2-29 into the table and set field properties.Table 2-29Field NameData TypeDescriptionField SizeOwnerIDShort TextUnique owner ID4OwnerLastNameShort TextLast name20OwnerFirstNameShort TextFirst name20AddressShort TextStreet address40CityShort Text 20StateShort Text 2ZIPShort TextZIP Code5PhoneShort TextContact phone number10 Set OwnerID as the primary key. Select the State field and type TX in the Default Value. Save the table as Owners.Create an input mask for the Phone field. Select the Phone field. Use the Phone Number Input Mask. Don’t make any changes to the mask or placeholder character and select the Without the symbols in the mask, like this radio button. Finish the Input Mask Wizard. Save the table.Create and test a field validation rule. Select the OwnerID field. Type Like "####" in the Validation Rule. Type You must enter a 4-digit Owner ID as Validation Text. Save the table and switch to Datasheet view. Test the rule by typing 11 in the first row of the OwnerID column. Move to the OwnerLastName field. The message box should display the validation text message (Figure 2-92) since the OwnerID is not four digits long.Figure 2-92 Field validation rule error message Click OK to acknowledge the error. Delete the contents and type 1111 into the OwnerID field. Verify that you successfully move to the OwnerLastName field since 1111 meets the validation rule criteria. Delete this test data record. Enter the records in Table 2-30 into the Owners table. Life’s Animal Shelter doesn’t have any data about the owners stored electronically so you are unable to import any data. Since the State field has a default value of TX, you can simply accept that value and tab to the next field.Table 2-30OwnerIDOwnerLast NameOwnerFirst NameAddressCityStateZIPPhone0100SmithAlbert11 Lakewood DriveAbileneTX79601325-614-93330101WestonMark2601 Nonesuch RoadAbileneTX79606325-555-11120102RiveraAngela2548 Laney RoadDentonTX76208940-321-80200103MoyerSilvia6867 Anglebluff CircleDallasTX75248972-380-61880104WillsMason2421 Klondike DriveDallasTX75228214-224-5555 Save and close the table.Determine the foreign key field. Currently, a field is not common across the Owners and Pets tables. A one-to-many relationship exists between the two tables since an owner could adopt many pets, but each pet is only adopted by one owner. The foreign key comes by taking the primary key field from the 1 table and adding it in as an additional field in the M table. Open the Pets table in Design view. Add the foreign key field below the Details field using the information in Table 2-31.Table 2-31Field NameData TypeDescriptionField SizeFKOwnerIDShort TextMust match an OwnerID in the Owners table4 Save and close the Pets table.Create a one-to-many relationship between the Owners and Pets tables. Open the Relationships window and add the two tables. Enlarge the table objects, if needed, to see all of the fields. Drag the OwnerID field from the Owners table on top of the FKOwnerID field in the Pets table. Release the pointer. The Edit Relationships dialog box displays. Select the choices to Enforce Referential Integrity and Cascade Update Related Fields. Leave the Cascade Delete Related Records check box not selected. The shelter does not want to delete pet records when it deletes information about an owner. Create the relationship. Save the changes and close the Relationships window.Enter the following data into the specified records in the Pets table to reflect which pets have been adopted: Open the Pets table in Datasheet view. Type 0100 in the FKOwnerID field for PetID 1. Type 0103 in the FKOwnerID field for PetID 3. Type 0100 in the FKOwnerID field for PetID 12. Type 0104 in the FKOwnerID field for PetID 14. Close the Pets table.View the related data records in the Owners table. Open the Owners table in Datasheet view. Click the plus sign to the left of the OwnerID field for Albert Smith, OwnerID 0100. You should see the two pets adopted by Albert. Close the Owners table. Close the database. Upload and save your project file. Submit project for grading.please answers these questions below Does Zillow really need a database?Joanee Johnson44 unread replies.44 replies.List the reasons a company like Zillow would need to use a database to run its business and do you think the business could be run without a database?Please make sure your response is detailed and written in complete sentences with correct spelling and grammar. Looking forward to reading your responses. Please make sure your response references concepts in the chapter. On next Monday you will be assigned a classmate's answer to respond to. It will be due next week.

The CEO is aware of the importance of diversity and inclusion within the company. However, the CEO and Leadership do not realize the differences between diversity and culture, and how this impacts teamwork. As the HR Manager, Leadership has asked you for a plan to motivate the employees at Lollipop Company, Inc. For this project assignment on Lollipop Company, Inc. complete a minimum of a 3-page business professional report that addresses the following concepts: Discuss the key elements of motivating a culturally diverse organization.Why is diversity and inclusion important? What are the benefits?Discuss how working with others can help with respect for diversity and respect for diverse perspectives.Explain how your plan will motivate and engage a culturally diverse workforce.Also, describe your plan for encouraging teamwork among a diverse workforce and ensuring that employees make meaningful and valuable contributions to team projects and tasks. Visit the Rasmussen online Library and search for a minimum of 3 articles covering diversity and culture and teamwork. Conduct academic research using the library's databases, like Business Source Complete via EBSCO and Business via ProQuest. Remember to integrate citations accurately and appropriately for all resource types; use attribution (credit) as a method to avoid plagiarism. Use NoodleBib to document your sources and to complete your APA formatted reference page and in-text citations. Company & 10-Ks Information: Mergent Online Instructions for accessing 10-Ks using Mergent Online