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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2017 Skopje Macedonia September 18 22 2017 Proceedings Part 3 Lnai 10536

Authors: Yasemin Altun ,Kamalika Das ,Taneli Mielikainen ,Donato Malerba ,Jerzy Stefanowski ,Jesse Read ,Marinka Zitnik ,Michelangelo Ceci ,Saso Dzeroski

1st Edition

3319712721, 978-3319712727

More Books

Students also viewed these Databases questions