Question TASK: You are a personal seller who sell product (choose any product) and have FIVE agents. To get order information, create ONE (1) ORDER FORM using Google Form. You may refer to any website which sell similar product as a catalog. You can distribute the form to your classmates (lecturer will assign the group to fill up the order form). Based on the data collected from the form, answer the questions below: 1. How many records does the file contain? How many fields are there per record? 2. What data redundancies do you detect? Discuss. 3. How could those redundancies lead to anomalies? Discuss. 4. Discuss the disadvantages of using Google Form to collect Order information. 5. Create other files which relevant to your business (PRODUCT, AGENT, SUPPLIER)

1 there are 5 records file contains there are 7 fileds per records  2. Many organisations have data redundancy, which happens when the identical piece of data is kept in two or more locations. As more businesses move away from compartmentalised data and toward a single repository, they are discovering that their databases are clogged with inconsistent duplicates of the same entry. Although it might be difficult to reconcile — or even profit from — redundant data inputs, knowing how to effectively manage and track data redundancy can help your company avoid long-term inconsistency concerns. 3.  A good relational database architecture should, in general, capture all of the required properties and associations. This should be accomplished with the least amount of stored data and no redundant data. Redundancy is often unwelcome in database architecture because it makes it difficult to maintain consistency following modifications. Redundancy, on the other hand, can occasionally result in performance gains, such as when it is used to link data instead of a join. When you need to get information from two linked tables, you use a join. When you put conflicting data into a table, you get an insertion anomaly. When we insert a new record, such as account no. A-306  we must ensure that the branch data matches that of previous rows. Anomaly has been updated. If a branch's address changes, such as the Round Hill branch in  a ... See the full answer