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 theI'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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!