Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. supplier s#: sname city status...

SUPPLIER S#: SNAME CITY STATUS...

90.2K

Verified Solution

Question

Accounting

SUPPLIER S#:
SNAME CITY STATUS
S1 IBM NY
S2 KLM AMS
S3 ATT NY
S4 GTE LA
S5 MCI NY

PART:

P# PNAME COLOR WEIGHT
P1 PC/XT BLACK 10
P2 PS/2 RED 20
P3 BOLT BLACK 5
P4 PIN BLUE 1

SP: S# P# QTY
S1 P1 30
S1 P2 40
S1 P3 10
S1 P4 10
S2 P1 30
S2 P2 40
S3 P1 40
S3 P3 50
S4 P4 40

Define primary key and foreign keys and enforce referential integrity.

Also, enforce the following integrity constraints:

  • Suppliers may only be in NY, SF, AMS or LA.
  • The quantity supplies may not be negative.
  • A supplier may not supply more than 5 products.
  • A part may not weigh more than 100.
  • NY supplies may not supply green parts.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A venturimeter is placed in a pipe which is at 30 degrees to the horizontal. The...

Mechanical Engineering
Q

Choose the correct answer World War II created a new world dominated by O Germany...

Biology
Q

Michael is driving to Denver Suppose that the remaining distance to drive in miles is...

Basic Math
Q

Kevin, Kim, and Lyu are walking on a 2D surface embedded in a flat three-dimensional...

Algebra
Q

Find the vertical asymptote s of the graph of the function x 7 3 x...

Algebra
Q

18 Issara deposits 2000 into an account that pays 3 05 interest compounded continuously How...

Algebra
Q

During Year 1 Chine Enterprises experienced the following events (1) Earned...

Accounting
Q

Your parents' small business purchases undeveloped land for $150,000 and, after a few years, forgets...

Accounting
Q

A delivery service owns a small fleet of trucks which was purchased for $150,000 early...

Accounting
Q

The main difference between absorption costing and variable costing is how we treat Direct costs...

Accounting
Q

Chaney Company provides lawn care services. Following are data for a recent week Service Revenue...

Accounting
Q

Cosmos Energy has acquired a loan of $250,000 to expand their electrical business operations in...

Finance