A 'SubWay' sub order has many items that may be included on the order. The order may contain choices such as breads, meats, toppings, condiments. Each order has an ID, name, and order date. Breads have a 'best used by date' and type such as white, rye, wheat, etc. Meats have a 'expiration date' and type such as turkey, ham, roast beef. Toppings and condiments have their own characteristics as well. Draw entities and represent any mutually exclusive relationships. Include optionality, cardinality, relationship names, attributes, UIDs and entities.

A 'SubWay' sub order has many items that may be included on the order. The order may contain choices such as breads, meats, toppings, condiments. Each order has an ID, name, and order date. Breads have a 'best used by date' and type such as white, rye, wheat, etc. Meats have a 'expiration date' and type such as turkey, ham, roast beef. Toppings and condiments have their own characteristics as well. Draw entities and represent any mutually exclusive relationships. Include optionality, cardinality, relationship names, attributes, UIDs and entities.

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please write a Quality Plan which includes quality assurance and Testing for the computer game clue-less following the instructions below: This game is a simplified version of the popular board game, Clue . The main simplification is in the navigation of the game board. In Clue-Less there are the same nine rooms, six weapons, and six people as in the board game. The rules are pretty much the same except for moving from room to room.
3.Rose Theater Company For this assignment you will modify the Rose Theater Company assignment created in chapter 2. Rose Theater company sells tickets to their productions. There are three seating options for purchase at Rose's theater; Orchestra seats, Center Stage seats, and Outer Stage seats. Orchestra seats cost $75 each, Center Stage seats cost $50 each, and Outer Stage seats cost $25 each. The theater company also gives a discount of 5% on tickets to the local theater group members. The user will enter the number of Orchestra, Center State, and/or Outer stage seats the customer wants to purchase along with whether the customer is a member of the local theater group. The program will calculate and display the income from each type of seat sale along with the discount, and total sale. Requirements Must include use of named constants Must include meaningful variable names Must include a main function with a call to the main function. Must include at least one value returning…
in visual c# add customer id from customer table to booking table which has a customer id column. they are primary key and foriegn key and are linked in realtionship table in access file. when button is clicked insert first name into booking table in first name column. This should automaically copy customer id to booking table in customer id column without coding
Special consideration needs to be made for the selection of the product category. Allowthe user to make a selection between the following categories:
if the productCost and productprice are numeric variables and productName is a string variable, which of the following statements are vaild assignments? if a statement is not vaild, explain why not productCost = 100 productPrice = productCost productPrice = productName productPrice = "24.95" 15.67 = productCost productCost = $1,345.52 productCost = productPrice-10 productName = "Mouse pad" productCost+20 = productPrice productName = 3-inch nails productName = 43 productName = "44" "99" = productName productName = brush battery = productName productName = productPrice productName = productCost
Strauble-Dytisa is a manufacturer of refrigerator parts located in Quaretero, Mexico. They supply parts to manufacturers in the U.S. such as Maytag and Frigidaire. Orders for parts are received (by Sales Department) from manufacturers. Each order (see the order form on the next page) has an order#, order date, and a total order amount (you can ignore taxes, s/h etc.). The order includes also the part#’s that are required, the part names and quantity of the part. An order could include for e.g. #51500 “door Liner” qty 50 as seen on the form. Since different manufacturers can order the same part (e.g. door liner), the order “qtys” from different orders are combined into one “#needed” for each part. The Sales Department checks orders against an inventory file to see if parts are available. If the parts are available, an invoice is created and the parts are shipped to the manufacturer along with an invoice. A copy of the invoice is sent to accounting. If the parts are not available, a copy…
Check the elements that are returned with the operation:SELECT[Airline="FlyRight" ^ Destination="Detroit"]
Make the functions below according to the attached class diagram and GUI program mockup. No The function to be made 1 Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021 When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. 2 Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID 3 If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. 4 When the ‘Hapus’ button is clicked, data from…
The Financial officer at RGI wants you to develop an application that will evaluate the company’s asset’s annual depreciation using the double-declining balance and sum-of-the years’ digit method. The Financial officer will enter the asset’s cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic’s Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the…
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
If productCost and productPrice are numeric variables, and productName is a string variable, which of the following statements are valid assignments? If a statement is not valid, explain why not. productCost = 100 productPrice = productCost productPrice = productName productPrice = "24.95" 15.67 = productCost productCost = $1,345.52 productCost = productPrice - 10 productName = "mouse pad" productCost + 20 = productPrice productName = 3-inch nails productName = 43 productName = "44" "99" = productName productName = brush battery = productName productPrice = productPrice productName = productCost
Task 3: The InstantRide Finance team wants to know the average discount amounts for each car in the InstantRide. Calculate the average discount amount as monetary value for the travels where a discount is applied. You need to create a subquery over the TRAVELS table to retrieve CAR_ID and DISCOUNT_AMOUNT, calculated with 2 decimals using the ROUND function. To calculate the DISCOUNT_AMOUNT, multiply the TRAVEL_PRICE by the TRAVEL_DISCOUNT where the TRAVEL_DISCOUNT value is not NULL. Round the result to 2 decimals. Then you can use this subquery to get the CAR_ID and AVG of DISCOUNT_AMOUNT values, once again using the ROUND function on the average results. Group the results by the CAR_ID. Use CAR_ID and DISCOUNT_AMOUNT as column aliases and return it back to the Finance team. Task: Calculate the average discount for each car. (SQL Database Test)