can you just answer the excersize 5.2 #a. For question 5-2(a), please name at least three tables and identify specific fields for each table.
USING YOUR KNOWLEDGE 5-1. Suppose you are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before the shows, you meet with the marketing managers and determine what displays and equipment they want to display. Then you identify each of the components that needs to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise conven- tion personnel as they set up the booths and equipment. Once the show is over, you supervise the packing of the booth and all equipment as well as schedule its ship- ment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all equipment If there are problems due to shipping damage or loss. you handle those problems. Your job is important; at a typical show. you are responsible for more than a quar- ter of a million dollars’ worth of equipment. a. You will need to track data about booth components, equipment, shippers, and shipments. List typical fields for each type of data. b. Could you use a spreadsheet to keep track of this data? What would be the advantages and disadvan- tages of doing so? c. Using your answer to part a, give an example of two relationships that you need to track. Show the keys and foreign keys for each. d. Which of the following components of a database application are you likely reports, queries, or application program? Explain Tree Trimming Service. Recall that Samantha has a degree from a forestry program and recently opened her business in St. Louis, Missouri. Her business consists of many one-time operations (e.g. removing a tree or stump), as well as recurring services (e.g. trimming customers’ trees every year or two). When business is slow. Samantha calls former clients to remind them of her services and of the need to trim their trees on a regular basis a. Name and describe tables of data that Samantha will need to run her business. Indicate possible fields for each table. b. Could Samantha use a spreadsheet to keep track of this data? What would be the advantages and disad- vantages of doing so? are returned. c. Using your answer to part a. give an example of two relationships that Samantha needs to track. Show the keys and foreign keys for each. d. Which of the following components of a database application is Samantha likely to need: data entry forms, reports, queries. or application program? Explain one use for each that she needs. e. Will this application be for one user or for multiple users? Will she need a personal DBMS or an prise DBMS? If a personal DBMS, which product will enter- she use? 5-3. YourFire Inc. (the same YourFire we met at the end of to need: data entry forms Chapter 3. page 83) is a small business owned by Curt and Julie Robards. Based in Brisbane. Australia, YourFire manufactures and sells the YourFire, a lightweight camp- C one use for each that you will need. e. Will your application be for one user or for multiple users? Will you need a personal DBMS or an enter- prise DBMS? If a personal DBMS, which product will ing stove. Recall that Curt used his previous experience as an aerospace engineer to invent a burning nozzle that enables the stove to stay lit in very high winds. Using her industrial design training. Julie designed the stove so that it is small. lightweight, easy to set up. and very stable. Curt and Julie sell the stove directly to their customers over the Internet and via phone. The warranty you use? 5-2. Samantha Green (the same Samantha we met at the end of Chapter 3. page 79) owns and operates Twigs on the