Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1a. Based on the participation of Customer and Ordering Buys, what can you conclude b Base on the cardinality of Supplies, what can you conclude?(8marks)

image text in transcribed

1a. Based on the participation of Customer and Ordering Buys, what can you conclude

b Base on the cardinality of Supplies, what can you conclude?(8marks)

c Mention one alternate key for Supplier(5 marks).

1. Given the following conceptual representation: order No date totalAmount tax firstName Street City lastName state zip custName custAdd creditLimit Order custid . deliver To Address zip street state city deliverTo Phone areaCode Buys M Customer Phone Contains Quantity number areaCode number N unitCost reorder Point M N Supplier Supplies Item qtyOnHand supplier No contactName Item No Item Name unitPrice supAdd supName street Zip/ country Phone city postal Code state countryCode areaCode number

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

5. How do instructional objectives help learning to occur?

Answered: 1 week ago

Question

4. Help trainees set challenging mastery or learning goals.

Answered: 1 week ago