Question: Subtypes should be used when: a recursive relationship is needed. there are attributes that apply to some but not all instances of an entity type.

Subtypes should be used when:
a recursive relationship is needed.
there are attributes that apply to some but not all instances of an entity type.
the instances of a subtype do not participate in a relationship that is unique to that subtype.
supertypes relate to objects outside the business.
Subtypes should be used when: a recursive relationship is needed. there

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!

Q:

Subtypes should be used when: a recursive relationship is needed. there are attributes that apply to some but not all instances of an entity type. the instances of a subtype do not participate in a...

Q:

Requirements Deliverable 1 must contain an analysis of the intended database system, and a conceptual schema. It must describe the problems encountered in this phase and justify the solutions. What...

Q:

Requirements Deliverable 1 must contain an analysis of the intended database system, and a conceptual schema. It must describe the problems encountered in this phase and justify the solutions. What...

Q:

Requirements Deliverable 1 must contain an analysis of the intended database system, and a conceptual schema. It must describe the problems encountered in this phase and justify the solutions. What...

Q:

Customer CUS ID (PRO Order Order No. (PK) places Includes CUS Name CUS ID (FO Item Order No. (FKO Item Code (PK Item Name Quantity Each ter price Address Order Date receives prepares Order...

Q:

Product Customers Orders Suppliers supplier_id suppliers_name supplier address Supplier phone supplies order product_id product_name product_price product description order id Customer_id Customer...

Q:

below is the ERD digram I need a same new normalized ERD diagram as per the requirements and checklist mention below . 1.The old ERD 2. The new Normalized ERD 3.A summary of the changes that you have...

Q:

Subtypes should be used when _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ . None of the above. there are attributes that apply to some, but not all instances of an entity type. the instances of a...

Q:

Customers Product Orders Suppliers supplier_id suppliers_name supplier_address Supplier_phone supplies order product ld product_name product price product description order id Customer_id Customer...

Q:

Customer Order Item CUS ID (PK Order No. (PK) places includes CUS Name HE CUS ID (FK) Order No. (FK) Item Code (PK Item Name Quantity Each tem price Address Order Date receives prepares Order...

Q:

The accompanying data on number of cell phone minutes used in one month are consistent with summary statistics published in a report of a marketing study of San Diego residents ( Tele- Truth, March,...

Q:

Livingston Company has developed capacity standards. Information about a non-value-added activity is as follows: Standard cost of the activity capacity acquired $60,000 Standard cost of the activity...

Q:

When covering a foreign currency asset transaction exposure currency put options are a preferred hedging tool as compared to the sale of a currency forwards because Question 2 options: Their cost is...

Q:

Select the following that illustrates the correct state of the stack frame after executing the following code: Double favoriteNum = 3 . 1 4 2 ; favoriteNum = 1 . 4 1 4 ;

Q:

6. Effectively perform the managers role in career management.

Q:

5. Business units can customize the system for their own purposes (with some constraints).

Q:

1. System is positioned as a response to a business need or supports a business strategy.