All categories

3 years ago

CAR_SALE (Car_no, Date_sold, Agent_no, Commission_pct, Discount_amt)

Computers and Technology

1 answer:

serg [7]3 years ago

8 0

1NF

In 1NF the relation should follow atomicity that means no repeating groups

In the relation there is no repeating groups

the relation is in 1NF

2NF

In 2NF, the relation should be in 1NF and each non prime

attribute must depend on primary key and No Partial dependency

Commission% is functional dependent on Salesperson# which is only part of the primary key.

relation is not in 2NF

3NF

In 3NF, the relation should be in 2NF and any NON prime attribute should not describe any non prime attribute.

Already we know relation is not in 2NF

there is a non prime attribute date_sold that describe another non prime attribute Discount_amt,

the relation is not in 3NF

Finally we come to. Know

the relation satisfies only 1NF

NORMALIZATION

The relation is not in 2NF

Decompose the relation CAR_SALE

CAR_SALES (Car#, Date_sold, Salesperson#, Discount_amt)

SALESCOMM (Salesperson#, Commission%)

CAR_SALES and SALESCOMM are in 2NF

In 3NF, the relation should be in 2NF and any NON prime

attribute should not describe any other non prime attribute

SALESCOMM relation is in 3NF

but CAR_SALES is not in 3NF the reason is that there is a

non prime attribute Date_sold that describes another non prime attribute Discount_amt.

So, decomposing the relation

CARSALEDATE (car#, salesperson#, Date_sold)

DATEDISS(Date_sold, discount_amt)

The relations CARSALEDATE

SALESCOMM

DATEDIS are in 3NF

You might be interested in

Write a class named RetailItem that holds data about an item in a retail store. The class should store the following data in att

sp2606 [1]

Answer:

public class Main

{

public static void main(String[] args) {

RetailItem ob1 = new RetailItem("Jacket", 12, 59.95);

RetailItem ob2 = new RetailItem("Designer Jeans", 40, 34.95);

RetailItem ob3 = new RetailItem("Shirt", 20, 24.95);

}

class RetailItem {

private String itemDescription;

private int units;

private double price;

public RetailItem(String itemDescription, int units, double price) {

this.itemDescription = itemDescription;

this.units = units;

this.price = price;

}

Explanation:

Create a class called RetailItem that has three variables itemDescription, units, and price

Initialize a constructor that takes three parameters to set the values

Inside the main, create three objects with given data

7 0

3 years ago

The sequence of instructions performed to execute one program instruction

Feliz [49]

Answer:

The CPU. The CPU is the heart of the computer. A program is a sequence of instructions stored in main memory. When a program is run, the CPU fetches the instructions and executes or follows the instructions.

Explanation:

hope you get ur answer

......

3 0

3 years ago

Weak Induction

slega [8]

Answer:

Following are the answer to this question:

Explanation:

In option 1:

The value of n is= 7, which is (base case)

$\to 3^7$

when n=k for the true condition:

$\to 3^k$

when n=k+1 it tests the value:

$\to 3^{(k+1)}= 3^k,3\\\to < (k!) 3 \ substituting \ equation \\\to$

since k>6 hence the value is KH>3 hence proved.

In option 2:

when:

for n=1:(base case)

$\log(1!)$

0<=0 \\ condition is true

when the above statement holds value n=1

when n=k

$\log(k!)$

when n=k+1

$\log(k+1)!=\log(k!)+\log(k+1)\\$

$\because k \log k$ $[\therefore KH>K \Rightarrow \log(KH>\loK)]$

In option 3:

when n=1:

$A_1 \cup B=A_1 \cup B\\\\$

when n=k

$\to (A_1\cap A_2 \cap.....A_k) \cup B\\=(A_1\cup B) \cap(A_2\cup B_2)....(A_k \capB).....(a)\\\to n= k+1\\ \to (A_1\cap A_2 \cap.....A_{kH}) \cup B= (A_1\cup B)\\\\\to [(A_1\cap A_2 \cap.....A_{k}) \cup B]\cap (A_{KH}\cup B)\\\\\to [(A_1\cup B) \cap (A_2 \cup B) \cap (A_3\cup B).....(A_k\cup B)\cap (A_{k+1} \cup B)\\\\ \ \ \ \ \ \ substituting \ equation \ a \\\\$

hence n=k+1 is true.

7 0

3 years ago

Write a test program that prompts the user to enter three sides of the triangle (make sure they define an actual triangle), a co

Ivanshal [37]

Answer:

Scanner in = new Scanner(System.in);

System.out.print("Please enter 3 sides of a triangle, color and " +

"whether it is filled or not (true false): ");

double s1 = in.nextDouble();

double s2 = in.nextDouble();

double s3 = in.nextDouble();

String color = in.next();

boolean filled = in.nextBoolean();

Triangle t1 = null;

try {

t1 = new Triangle(s1, s2, s3, color, filled);

}

catch (IllegalTriangleException ite) {

System.out.println(ite.toString());

}

System.out.println(t1.toString());

System.out.printf("Triangle color: %s, Triangle filled: %s%n" +

"Area: %.2f%n" +

"Perimeter: %.2f%n%n",

t1.getColor(),

t1.isFilled(),

t1.getArea(),

t1.getPerimeter());

Explanation:

Scanner in = new Scanner(System.in);

System.out.print("Please enter 3 sides of a triangle, color and " +

"whether it is filled or not (true false): ");

double s1 = in.nextDouble();

double s2 = in.nextDouble();

double s3 = in.nextDouble();

String color = in.next();

boolean filled = in.nextBoolean();

Triangle t1 = null;

try {

t1 = new Triangle(s1, s2, s3, color, filled);

}

catch (IllegalTriangleException ite) {

System.out.println(ite.toString());

}

System.out.println(t1.toString());

System.out.printf("Triangle color: %s, Triangle filled: %s%n" +

"Area: %.2f%n" +

"Perimeter: %.2f%n%n",

t1.getColor(),

t1.isFilled(),

t1.getArea(),

t1.getPerimeter());

7 0

3 years ago

In theory, a hacker with a small but powerful directional antenna could access a wireless network from more than one mile away.

Svetradugi [14.3K]

100 miles i assume since the avarge antanna cover 5-50 miles

3 0

3 years ago