Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. Question 1. If recording the results of each testing process is still done manually, according to you please explain which approach fits between Centralized and View Integration for gathering requirements. 2. What Fact Finding Methods you will choose to get information related to the development of a database system to record the testing process, and explain the reasons for choosing.

Given the following case you are to answer the two questions on the following pages. Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to have assigned an identifying number. 1. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attrIbutes take on. 2. Create the database design for this case below using an Entity-Relationship Diagram.

ER-Diagram and EER-DiagramHoliday Travel Vehicles (HTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at the HTV, a new vehicle record is created. Included in the new vehicle record are vin-number, model, year, manufacturer, and base cost. Several manufacturers that supply the vehicle are Toyota, Chrysler and Ford. When a customer arrives at HTV, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed upon, a sales invoice is completed by the salesperson. The invoice summarizes the purchase with invoice no, date, vehicle vin-number, sale tax and final price. Customers are assigned a customer ID when they make their first purchase from HTV. Name, sex, DOB, address (street, city, zipcode), and phone number are recorded for the customer. Each invoice lists just one customer. A person does not become a customer until he or she purchases a vehicle. Overtime, a customer may purchase a number of vehicles from HTV.…

Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…