Question

The figure below shows a list used by a veterinary office. Refer to the list and answer the questions below. 1. G H OwnerEmail Marsha [email protected] Richaed [email protected] Marha [email protected] Lic [email protected] Richard [email protected] Richard [email protected] Mies [email protected] Hilay [email protected] PerD08 27-Feb-12 Downs 1Feb-11 James 17-Jul-13 Downs 5-May-13 Frer 6Jun-10 James Ownerl astName OwnerFirstName Marsha Richard Marsha Liz Richard Richard Miles Hilary OwnerPhone 201-823-5467 201-735-9812 201-823-5467 201-823-6578 201-735-9812 201-735-9812 201-634-7065 210-634-2345 PetType PetName 2 King 3 Teddy 4 Fido 5 AJ 6 Cedro 7 Woolley 8 Buster 9 Jedah PetBreed Std. Poodle Cashmier Std. Poodle Colle Mix Dog Cat Dog Dog Ca Cat Unknown Unknown Border Collie Abyssinian James 110ec-09 Trent 1Jul-06 Evans Dog Cat Describe two problems that are likely to occur when using this list (Think in terms of keeping track of data for updates, deletes and additions). Pleases ensure to specifically explain the two problems and how they can occur in this list with examples referring to rows in the list 2. 2B. Describe a solution to the problem What is the difference between data and information? Give specific examples to explain the 3. difference.

Answer 1

2A.

Updation anomaly:

If an owner's email is changed, it has to be updated in all the places . for example if the email of James Richard is changed, it has to be updated in 3 rows. If all rows are not updated , inconsistency exists in the database.

Deletion anomaly:

If a pet dies and his information is deleted from the table, his owner's information will also get deleted. for example if the pet dog AJ dies and his information is deleted from the table, his owner information will also get deleted.

B.

The solution to the above mentioned problem is Normalization.

Normalized tables

PET(PetName, PetType, PetBreed, PetDOB, OwnerPhone)

OWNER(OwnerPhone, OwnerLastName, OwnerFirstName, OwnerEmail)

underlined are primary keys and italicised are foreign keys.

3.

Data is raw facts like India, 45, James.

Processed and organized data is called information like customer country is India, his age is 45 and customer name is James.

Do ask if any doubt. Please upvote.