Answered step by step
Verified Expert Solution
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 CUSCODE: 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 "CUSCODE:
CUSLNAME, CUSFNAME, CUSINITIAL, CUSAREACODE, CUSPHONE
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 "CUSLNAME," "CUSFNAME," and "CUSAREACODE."
Express your composite key using the correct syntax
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started