Sample Header Ad - 728x90

How do I identify functional dependencies and normalize a table based on the attributes?

0 votes
1 answer
2540 views
I'm having trouble identifying the combination of attributes which make up Functional Dependencies(FDs) of a particular table. While I understand how Normalization process works when given the FDs, I'm unable to translate and identify FDs for a given table. I've been tasked to create a database of a company which tracks all expenses of sales/packages etc. Naturally that means storing Customer information for the company to identify all consumers.
CREATE TABLE Customers (
    id        integer primary key,
    address   text not null,
    name      text not null,
    email     text unique not null,
    phone     text unique not null,
    unique(name, address)
);
I've chosen to represent the info for the customer table as such, given that each phone number and email is uniquely tied to the customer. The unique constraint allows for multiple people from the same household address to be present in the table. I want to see if I can normalize this table further, however I am unable to identify the attributes to determine the FDs needed.
Asked by Naja (13 rep)
Apr 13, 2021, 07:55 AM
Last activity: Apr 13, 2021, 12:48 PM