Garden Glory chapter 1 Essay

823 WordsDec 7, 20134 Pages
Q-A: Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1:30, but it will concern owners and properties rather than owners and pets. Your list should include, a minimum, owner name, phone and billing address, as well as property name, type and address. Answer: PropertyName PropertyType PropertyAddress OwnerLastName OwnerFirstName OwnerPhone OwnerEmail Q-B: Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in spreadsheet. Answer: There are three types of modification are likely to occur in this case. 1- Updating some value in the list 2- Deleting some value in the list…show more content…
So, these two themes are possible. Table: OWNER OwnerID OwnerLastName OwnerFirstName OwnerPhone OwnerEmail Table: PRPPERTY PropertyID PropertyName PropertyType PropertyAddress Creation of tables will solve the updating, adding and deleting problems. For example if we want to update the phone number of a customer we have to change the number in single row of OWNER table and it will update that change in all tables. For example to delete a property if we delete the property in PROPERTY table and we can keep the owner data and to add data, for example, if add a owner data in OWNER table we don’t have to add property for that owner. Q-D: Create a sample list of owners, properties and services. Your list will similar to that in Figure 1-31. Your list should include the data items form part a as well as the date, description, and amount charged for each service. Answer: PropertyName PropertyType PropertyAddress OwnerLastName OwnerFirstName OwnerPhone OwnerEmail Service Date Charge Q-E: Illustrate modification problems that are likely to occur if Garden Glory attempts to maintain the list from part D in spreadsheet. Answer: 1- Adding some value in the list 2- Deleting some value in the list 3- Updating some value in the list Updating value: For example, there will be problem
Open Document