Consider this scenario: A local bakery needs a database to m…
Consider this scenario: A local bakery needs a database to manage its daily operations. The bakery serves customers, each identified by a unique customer ID. The bakery records each customer’s name, phone number, and email address. Customers are recorded in the system when they sign up for the loyalty program, even if they have not yet placed an order. Customers can place multiple orders over time. Each order is identified by a unique order ID and records the order date, pickup or delivery method, and total amount. Each order is linked to the customer who placed it and the employee who handled it. Each employee is identified by a unique employee ID. The bakery records each employee’s name, position (such as baker, cashier, or delivery driver), and hourly wage. Orders can contain multiple products, and the same product can appear on many orders. Each product is identified by a unique product ID and has a name, category (such as bread, pastry, or cake), and price. After each order is completed, one invoice is generated. Each invoice is identified by a unique invoice ID and records the payment status (such as paid, pending, or overdue) and the payment method (such as cash, card, or online). Tasks: Identify all entities, primary keys, and attributes. Draw an EERD in MySQL Workbench that includes all entities, their attributes, and the relationships between them. Label the cardinality and optionality for every relationship. Include a bridge/associative entity where appropriate. Submit a document containing a screenshot of your completed EERD. Insert -> Image -> Upload Image
Read DetailsA wheel accelerates from rest to 59 rad/sec at a rate of 58…
A wheel accelerates from rest to 59 rad/sec at a rate of 58 rad/sec^2. Through what angle (in radians) did the wheel turn while accelerating? (You must show your full solution steps here. The Scratch Paper is not a substitute for the solution steps.)
Read Details