The following table is a non-normalized table for a Rental Property Management Database.  Data is included to help you to perform the normalization.  One client may have multiple rental records.

Identify the functional dependencies and normalize the table to 1NF, 2NF, and 3NF respectively. You also need to show the steps to reach normal form and populate each relation with sample data. As a result, you can see that duplicate data will be removed through the normalization process.

CLIENT_RENTAL

ClientNo: Client Number (PK)

ClientName: Client (who rents a property) Name

PropertyNo: Property Number

PropertyAddress: Property Address (Do not need to break this attribute)

RentStart: Rent Start Date

RentEnd: Rent Ended Date

RentFee: Monthly Rental Fee

OwnerNo: Property Owner Number

OwnerName: Property Owner Name

Notes:

1. Can multiple clients rent the same property at the same time? For example, co-signers on a lease.  No
2. Can one client rent multiple properties at the same time? I.e. if he rented a home and an office.  Yes
3. Can one client rent the same property multiple consecutive times, requiring multiple records? For instance, he extends a lease for another year at a different rent.  No
4. A property cannot have multiple owners.
5. The RentFee is not fixed for each property and can change from one Client to the next.
6. A different client can rent the same property for a different time period creating another record for the same property.

Using the given file, ask the user for a name, phone number, and email. Display the required information.

These are the Files that I made:

import java.util.Scanner;

public class Demo5
{
    public static void main(String args[])
    {
        Scanner keyboard = new Scanner(System.in);

        System.out.println("New number creation tool");

        System.out.println("Enter name");
        String name = keyboard.nextLine();

        System.out.println("Enter phone number");
        String phoneNumber = keyboard.nextLine();

        System.out.println("Enter email");
        String email = keyboard.nextLine();

        Phone test1 = new SmartPhone(name, phoneNumber, email);

        System.out.print(test1);
        System.out.println("Telephone neighbor: " + ((SmartPhone) test1).getTeleponeNeighbor());
    }
}

And:

public class SmartPhone extends Phone
{
    private String email;
    private String phone;
    private String phone2;

    public SmartPhone()
    {
        super("None",-1);
        phone = "Not set";
        email = "None";
        phone2 = "Not set";
    }

    public SmartPhone(String name, String phone)
    {
        super(name, Long.parseLong(phone));
        this.phone = phone;
        this.email = "None";
    }

    public SmartPhone(String name, String phone, String email)
    {
        super(name, Long.parseLong(phone));
        this.email = email;
        this.phone = phone;
    }

    public boolean hasPhoneNumber()
    {
        return !phone.equals("Not set");
    }

    public String getAreaCode()
    {
        return phone.substring(0,3);
    }

    public String getPrefix()
    {
        return phone.substring(3,6);
    }

    public String getLineNumber()
    {
        return phone.substring(6);
    }

    public String toString()
    {
        return "Name: " + name + "\n" +
                "Phone: " + phone + "\n" +
                "Email: " + email + "\n";
    }

    public String getTeleponeNeighbor()
    {
        if(phone == "Not set")
        {
            return "Cannot calculate phone number neighbor";
        }
        else
            {
            String roundUp = "(";
            roundUp += phone.substring(0,3) + ") ";
            roundUp += phone.substring(3,6) + "-";
            roundUp +=  Integer.parseInt(phone.substring(6,10)) + 1;

            return roundUp;
        }
    }
}

Given Files:

public class Phone
{
    protected String name;
    protected long number;

    public Phone() {
        this("None", -1);
    }

    public Phone(String name) {
        this(name, -1);
    }

    public Phone(String name, long number) {
        this.name = name;
        this.number = number;
    }

    public String getName() {
        return name;
    }

    public long getNumber() {
        return number;
    }
}

//////////////// Input ////////////////

Zed
5552129999
[email protected]

//////////////// Required Output ////////////////

New number creation tool\n
Enter name\n
Enter phone number\n
Enter email\n
Name: Zed\n
Phone: 5552129999\n
Email: [email protected]\n
Telephone neighbor: (555) 213-0000\n

An experiment requires 74.2 mL of ethyl alcohol. If the density of ethyl alcohol is 0.790 g/cm3, what is the mass of 74.2 mL of ethyl alcohol?

In an experiment to in which Oxone was used to oxidize Borneol to Camphor, Calculate the theoretical yield of camphor. 0.4381g of Borneol 1.2333g of Oxone 0.0523g and 0.0254g of NaCl

when we performed the TLC experiment, the class chose a mixture for the mobile phase of 80 % ethyl acetate and 20 % hexanes. why was this composition chosen

what is Yeast 2 Hybrid is and what is it used for? What are the bait and prey and the concept behind how the Y2H experiment works? What are the advantages/disadvantages to it?

In an extraction experiment, an aqueous solution of propionic acid will be extracted with hexane and with ethyl acetate. Which solvent should extract more of the propionic acid? Explain.

briefly explain the meaning of the terms as they relate to this experiment. 1. forward reaction 2. reverse reaction 3. chemical equilibrium 4. endothermic reaction

How would the signal intensity (amount of color detected) in an indirect IHC experiment compare to the signal intensity of direct IHC. Explain your answer.