Question: I'm only needing help with 2A and 2B.. I'd greatly appreciate the help. It's over Entity Relationship diagrams and Cardinalities (Data Flow Charts). Hands-on Practice
I'm only needing help with 2A and 2B.. I'd greatly appreciate the help. It's over Entity Relationship diagrams and Cardinalities (Data Flow Charts).
Hands-on Practice (HOP) 1 - ERD Levels 0 and 1 Develop the following models: 1a & 1b. Use LucidChart to develop the same ERD Level 0 and Level 1 diagrams discussed in the lectures this week for Rick's Brick & Cue Catering. ERD Level O should include the following entities: CUSTOMER, EVENT, ITEM, DELIVERY LOCATION, GUEST CHECK, and EMPLOYEE. ERD Level 1 should contain the same entities, along with any association entities added to resolve M:N relationships. 2a & 2b. Use LucidChart to develop ERD Level 0 and Level 1 diagrams for the following business rules: An invoice is written by a sales representative. Each sales representative can write many invoices, but each invoices is written by a single sale representative. The invoice is written for a single customer. However, each customer can have many invoices. An invoice can include many detail lines, each of which describes one product bought by the customer The product information is stored in a product entity The product's vendor information is found in a vendor entity For 2b, here are a few things the database should track: Name, address, phone, email of customer Name, phone, email of sales representative Name email of vendor Invoice number, date, subtotal (i.e., amount prior to tax), tax on the invoice, and invoice total (subtotal + tax) Unit price, quantity, and total amount charged on the invoice for a product
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
