Lab 5 - Normalization Instructions Lab 5 Tasks Based on the following scenario, provide a Word document with a normalized set of entities and attributes. The document must include UNF, 1NF, 2NF and 3NF solutions. Submission An MS-Word document that that is name like: lastname_firstname_lab5.docx You must include your name and student number in the word document. Below is a sample. Joe Student 0123456789 UNF: entity [entity_identifier, attributed, attribute2, attribute3] 1NF : 2NF: 3NF: Scoring The document will be scored as follows: 5 -> All normal forms are completed and dependencies resolved. 3 -> There are some errors in the normalization process 1 -> Significant errors are present 0 -> not submitted, completely incorrect, etc. Scenario Patient Application System Considerations Description Each client must be age 18 or over. A client is the person to whom the bill will be sent. The mailing address and the phone number of the client is absolutely required. All other data is optional. An owner may be a client or a dependent of the client. For example a child may be the owner of a pet. Because we know the client (parent) of the child, we know where to send the bill. Each owner can have only one client, but obviously a client may be responsible for several owners. There can be only one owner per animal, but an owner may have several animals. Each animal will have static data stored such as pet name, age, gender In addition, the history of treatment for the pet must be available. See the Health History report