Using the following business rules for a centralized contact management database select the correct specialization hierarchy symbol on the diagram below.Each contact will be assigned a unique number.We need to store name, address, telephone, and email address for everybody.A contact may be a vendor, someone we purchase items from. We need to remember our credit limit and a remit to address.A contact may also be a customer. We need to store their favorite color, so that we can recommend items to them, and their ship-to address.We may also keep contact information about individuals who are neither a customer or a vendor.Some contacts are both a customer and a vendor. ContactPKContact_NumberContact_Last_NameContact_First_NameContact_PhoneContact_EmailVendorCustomerFK Contact_NumberVendor Credit_LimitVendor_Remit AddressVendor_Remit_CityPKPKFK Contact_NumberCust_Fav_ColorCust_Ship_AddressCust_Ship_CityVendor_Remit_StateCust_Ship_StateVendor_Remit_ZipCust_Ship_Zip아

The answer is "O" with a single line under it.

Answered: Using the following business rules for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Using the following business rules for a centralized contact management database select the correct specialization hierarchy symbol on the diagram below.

Each contact will be assigned a unique number.
We need to store name, address, telephone, and email address for everybody.
A contact may be a vendor, someone we purchase items from. We need to remember our credit limit and a remit to address.
A contact may also be a customer. We need to store their favorite color, so that we can recommend items to them, and their ship-to address.
We may also keep contact information about individuals who are neither a customer or a vendor.
Some contacts are both a customer and a vendor.