CS 3310Assignment #5: Database DesignDescription:The goal is to practice database design using normalization.Work the Morgan Importing Problem described as described below. No database development is required for thisassignment, just the table design. The assignment involves concepts covered in chapter 4 and its slides. Pay attention to the following guidelines for Assessing Table Structure from Figure 4-1 of Chapter 4.Assessing Table StructureMorgan Importing Problem:Phillip Morgan, the owner of Morgan Importing, makes periodic buying trips to various countries. During the trips, he keeps notes about the items he purchases and basic data about their shipments. He hired acollege student as an intern, and she transformed his notes into the spreadsheets in Figure 4-9. This is just sample data. Phillip has purchased hundreds of items over the years, and they have been shipped indozens of different shipments.Phillip wants to enter the information age, thus he has decided to develop a database of his inventory. He wants to keep track of the items he has purchased, their shipments, and eventually customers andsales. To get started, he has asked you to create a database for the data in Figure 4-9.Figure 4-9 – Spreadsheets from Morgan ImportingTo complete this assignment, you must complete following instructions and provide detailed answers for each item:A Follow the “Assessing Table Structure” procedure shown. List multivalued dependencies,functional dependencies, candidate keys, primary keys, and foreign keys. State yourassumptions.B List questions you would ask Phillip to verify your assumptions.C Create tables as necessary to eliminate multivalued dependencies, if any.D The relationship between shipment and item data could be inferred by matching values in theFrom cells to values in the City cells. Describe two problems with that strategy.E Describe a change to this spreadsheet that does express the shipment/item relationship.F Assume that Phillip wishes to create an updateable database from this data. Design tables youthink are appropriate. State all referential integrity constraints.G Assume that Phillip wishes to create a read-only database from this data. Design tables you thinkare appropriate. State all referential integrity constraints.H Do these data have the multivalue, multicolumn problem? If so, how will you deal with it?I Do these data have the inconsistent data problem? If so, how will you deal with it?J Do these data have a null value data problem? If so, how will you deal with it?K Do these data have the general-purpose remarks problem? If so, how will you deal with it?For part A, make sure you state your assumptions.For part B, list at least 6 questions to verify your assumptions stated in part A.For part C, describe the tables using the SQL standard notation (the PK is underlined and the FK is italicized). For example, SKU_DATA (SKU, SKU_Description, Department, Buyer)For part D, focus on the FK usage and the issue of data consistency when addressing this part.For Parts F and G, , describe the tables using the SQL standard notation (underlined PK and italicized FK) with referential integrity statements. For example, SKU_DATA (SKU, SKU_Description, Department, Buyer)BUYER (BuyerName, Department)Where SKU_DATA.Buyer must exist in BUYER.BuyerNameInclude all of your answers for all parts (Questions A – K) in one MS Word document.Due 11:59 p.m.

Define the Circle2D class that contains:

■ Two double data fields named x and y that specify the center of the circle with getter methods.

■ A data field radius with a getter method.

■ A no-arg constructor that creates a default circle with (0, 0) for (x, y) and 1

for radius.

■ A constructor that creates a circle with the specified x, y, and radius.

■ A method getArea() that returns the area of the circle.

■ A method getPerimeter() that returns the perimeter of the circle.

■ A method contains(double x, double y) that returns true if the

specified point (x, y) is inside this circle (see Figure 10.21a).

■ A method contains(Circle2D circle) that returns true if the specified circle is inside this circle (see Figure 10.21b).

■ A method overlaps(Circle2D circle) that returns true if the specified circle overlaps with this circle (see Figure 10.21c).

Use the following code for the methods contains and overlaps: 

  public boolean contains(double x, double y) {

    // MyPoint is defined in Exercise09_04

    double d = distance(x, y, this.x, this.y) ;

    return d <= radius;

  }

  public boolean contains(Circle2D circle) {  

    double d = distance(this.x, this.y, circle.x, circle.y);

    return d + circle.radius <= this.radius;

  }

  public boolean overlaps(Circle2D circle) {   

    // Two circles overlap if the distance between the two centers

    // are less than or equal to this.radius + circle.radius

    // MyPoint is defined in Exercise09_04

    return distance(this.x, this.y, circle.x, circle.y)

      <= radius + circle.radius;

  }

  private static double distance(double x1, double y1,

      double x2, double y2) {

    return Math.sqrt((x1 – x2) * (x1 – x2) + (y1 – y2) * (y1 – y2));

  } 

Here is a sample run for a point 2, 2 with a radius of 5.5:

I am attaching all files.

• Attachment 1
• Attachment 2

The XYZ Corporation pro-