Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 14. Using the following ERD that models a way to track vendor invoices, do the following (20 points): For each entity: Indicate if the
Question 14. Using the following ERD that models a way to track vendor invoices, do the following (20 points): For each entity: Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not invoices invoice_id INT(11) vendor_id INT(11) Invoice_number VARCHAR(30) invoice_date DATE invoice_total DECIMAL (9,2) payment_tota DECIMAL (9,2) credit_total DECIMAL (9,2) invoice_due_date DATE payment date DATE Indexes vendors vendor_jd INT(11) vendor_name VARCHAR(50) vendor address I VARCHAR(50) vendor_address2 VAROHAR(50) vendor_aty VARCHAR(50) vendor_state OHAR (2) vendor_zip_code VARCHAR(20) vendor phone VARCHAR(50) vendor_contact_last_name VARCHAR(SO) vendor_contact_frst_name VARCHAR(50) Indexes invoice_line_items invoice_id INT(11) invoice_sequence INT(11) line_item_amount DECIMAL (9.2) line_item_descripton VARCHAR(100) Index Entities invoices strong weak ID-dependent weak non-ID-dependent vendors strong weak ID-dependent weak non-ID-dependent invoice_line_items strong weak ID-dependent weak non-ID-dependent Relationships Entity 1: PK: Optional Mandatory One Many Entity 2: FK: Optional Mandatory One Many Business Rule 1: Business Rule 2: Identifying Non-identifying Entity 1: PK: Optional Mandatory One Many Entity 2: FK: Optional Mandatory One Many Business Rule 1: Business Rule 2: Identifying Non-identifying
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started