An animal clinic keeps the records on the pets information in the spread sheet with the column headings: PetName, PetType, PetDOB, OwnerLastName, OwnerFirstName, Phone, Address, Service, ServiceDate, Charge. a. The clinic can keep the records in this way on the spreadsheet, but they will soon find inconveniences in handling the pets information. Think in terms of data entry, updating data, or deleting data. b. To avoid the above problems, the pet treatment information needs to be kept in separate “tables” such as Pet, Owner, and Service in the Microsoft Access terms. How these tables should be set up to keep the pet treatment information efficiently? You can write the table name and its contents such as TableName(fieldname1, fieldname2, etc). c. For the tables you set up in b, assign or add appropriate primary keys and foreign keys for each table. Some table wouldn’t need a foreign key. The primary key should be underlined, and foreign key in italic such as TableName(primarykeyname, fieldname1, fieldname2, foreignkeyname, etc).
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.