Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Examine entity CUSTOMER in the associated file for this homework. Fill out the table below to answer the question s parts. Identify the determinant CUS

Examine entity CUSTOMER in the associated file for this homework. Fill out the table below to answer the questions parts.
Identify the determinant CUS_CODE: Unique identifier and by knowing it we can determent any other information about the customer.
Explain what kind of specific determinant it is It is a primary key and uniquely identifying each customer.
List the dependent attributes Attributes that depend on "CUS_CODE:
CUS_LNAME, CUS_FNAME, CUS_INITIAL, CUS_AREACODE, CUS_PHONE
If we removed the determinant from the entity, what attributes could we us in a composite key and why? we could use a composite key consisting of "CUS_LNAME," "CUS_FNAME," and "CUS_AREACODE."
Express your composite key using the correct syntax

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

Professional Microsoft SQL Server 2014 Integration Services

Authors: Brian Knight, Devin Knight

1st Edition

1118850904, 9781118850909

More Books

Students also viewed these Databases questions

Question

4. Describe some cultural differences in the notion of friendship.

Answered: 1 week ago