CAR_SALE (Car_no, Date_sold, Agent_no, Commission_pct, Discount_amt)
Assume that a car may be sold by multiple agents, and hence {Car_no, Agent_no} is the primary key. Therefore, a single car sale may occupy multiple tuples.
Additional dependencies are:
Date_sold → Discount_amt and
Agent_no → Commission_pct
Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why or
why not? How would you successively normalize it completely? Provide reasoning for each normalization.

Answer:

The description of the given point can be defined as follows:

Explanation:

In option a:

List the articles authored by John Smith

[tex]\pi[/tex]Article.title ([tex]\delta[/tex](Author.authorID=Authoring.authorID)^ (Article.articleID=Authoring.articleID)^ (Author.name=’John Smith’) (Article [tex]\times[/tex] Authoring [tex]\times[/tex] Author))

In option b:

Listed all John Smith but also Marc Antoine's articles  

[tex]\pi[/tex] Article.title ([tex]\delta[/tex](Author.authorID=Authoring.authorID)^ (Article.articleID=Authoring.articleID)^

(AUTOR.NAME='JohnSmith 'or "John Smith'Marc Antoine" )

(article [tex]\times[/tex] Authoring  [tex]\times[/tex] Author)

In option c:

Review the John Smith co-authors (authors co-authors with John Smith)  

ID (Author.authorID = Authoring.authorId)^(Article.articleID =Authoring.articleID)^(Article.articleID = Authoring.articleID)^  

(Author.name='John Smith') (Paragraph x Author)  

[tex]\pi[/tex]  Article.title ([tex]\delta[/tex](article.item ID = Addresse.itemID)^(Authoring.art.item = art)  

(Paragraph [tex]\times[/tex] Authoring)

In option d:

List all of that year's papers  

[tex]\delta[/tex] (Article.year=2019)  

In option e:

List the authors without a database post  

authorInDatabase = [tex]\pi[/tex] Authoring.authorID (δ(Author.authorID=Authoring.articleID) )

(Author [tex]\times[/tex] Authoring)

authorTotal =  Author.authorID (δ (Author.authorID=Authoring.articleID)

(Author [tex]\times[/tex] Authoring)

AuthorsWithNotWithArticles = authorTotal - AuthorInDatabase

In option f:

Listed of writers that have co-authored both published publications to John Smith  

Authors = [tex]\pi[/tex]  Book.authorID ([tex]\delta[/tex] Author.authorID)^(Article.articleID = Authoring.articleID)^ Authoring.articleID)^ Book Authors  

(Paragraph [tex]\times[/tex] Authoring) (Author.name='John Smith')  

[tex]\pi[/tex] Author.name ([tex]\delta[/tex] (Art.articleID = Author.articleID)^(Authoring.authorID = Authoring. Authoring. AuthorID)  

(Physician[tex]\times[/tex] Authoring)

Answer:

the text will highlited in gray

Explanation:

Answer:

book of English

page 91 answer in 2 part

Explanation:

ok bro pls follow me

Answer:

Interpretation #1: My dad wanted to annoy me and didn't want me to have fun.

Clarification: #1: Dad why did you refuse to let me borrow your keys, did I do something wrong? Or did you just want to annoy me.

Interpretation #2: He is worried that something dangerous might happen without any adults in the car and didn't want to rist anyone getting hurt.

Clarification #2 : Dad, do you think we are not going to drive safely? Would you prefer someone older accompanies us?

Explanation:

Answer:

print("You owe $", moneyDue, sep="")

Explanation:

By default, Python3 will put a space between two strings like this. If you specify that the separator is an empty string (sep="") then it will not separate the two strings and the space will go away.

Answer:

print("You owe$" + str(moneyDue))

Explanation:

It's the one with the plus sign. Correct on EDG 2021 :D

Answer:

Colors are complex. They are shades, designs, and an illusion that adds to our reality, truly. We have cones in our eyes to help us see these colors. Issac Newton defined colors. ROYGBIV was the acronym. Really, colors are just designs and shades and illusions we can see for many scientific reasons I can't explain in a few minutes.

Hope this helps!

Answer:

15 maybe an advertisement?

Explanation:

Answer:

ssume that,

Maximum “students” count can be 10.

*Driver Class*

*Solution class*

import java.util.*;

class Student {

private String name;

private int rollNo;

public String getName() {}

public void setName(String name) {}

public int getRollNo() {}

public void setRollNo(int rollNo) {}

};

class ClassRoom {

private int i;

private Student[] students;

public void addStudent(String name, int rollNo) {}

public Student[] getAllStudents() {}

};

Answer:

Beaker Purpose

Although the purpose of a beaker is to contain and measure liquids, the glassware can come in a multitude of shapes and sizes. Most often, a beaker is cylindrical in shape and has a flat bottom. Some beakers have a small beak or spout to aid in the pouring of liquids.

Here hope that helps know mark me as brill

Answer:

It has to be performed a minimum of  1  trips to do   100 steps

It has to be performed a minimum of  4  trips to do   500 steps

It has to be performed a minimum of  7  trips to do   1000 steps

It has to be performed a minimum of  32  trips to do   5000 steps

All trips need to be  44

Explanation:

open python console and execute the .py code bellow:

import math

floor_steps=16

floor=5

total=0

target_steps=2*floor_steps*floor

trips=100/(target_steps)

trips= math.ceil(trips)

total+=trips

print("It has to be performed a minimum of ",trips," trips to do   100 steps")

trips=500/(target_steps)

trips= math.ceil(trips)

total+=trips

print("It has to be performed a minimum of ",trips," trips to do   500 steps")

trips=1000/(target_steps)

trips= math.ceil(trips)

total+=trips

print("It has to be performed a minimum of ",trips," trips to do   1000 steps")

trips=5000/(target_steps)

trips= math.ceil(trips)

total+=trips

print("It has to be performed a minimum of ",trips," trips to do   5000 steps")

print("All trips need to be ",total)

Answer:

Explanation:Mind mapping software can help you to make connections and become a better creative problem solver.

...

It helps you to make better decisions. ...

It helps you to become better organized. ...

You can see the forest and the trees. ...

It helps you to identify, prioritize and track key project tasks.

A vector is a drawing made up of lines without any surface color or shading. The correct option is 2.

Digital shapes called vectors are formed of lines and curves and are used to build images using mathematical equations. These curves and lines, which are also known as pathways, enable designers to scale pictures that are as simple as shapes or as intricate as full-blown illustrations.

Focus is placed on using only straight lines and contours, without any shading in line drawings. In the majority of line drawings, the artist draws the entire picture without ever taking their tool off the paper.

Therefore, the correct option is 2. Vector.

To learn more about vector drawing, refer to the link:

https://brainly.com/question/3930341

#SPJ1

Answer:

D. Wireframe

Explanation:

Answer:

Written in Python:

userinp = input("Input: ")

count = 0

while not userinp == "stop":

print("You entered "+str(userinp))

count = count + 1

userinp = input("Input: ")

print("All done, "+str(count)+" words entered")

Explanation:

I've added the full program as an attachment where I use comments to explain difficult lines

Answer:

word = input("Please enter the next word: ")

count = 0

while word != "DONE":

      count += 1

      print("#{}: You entered the word {}".format(count, word))

      word = input("Please enter the next word: ")

print("A total of " + str(count) + " words were entered.")

Explanation:

Assuming this is python, this should help!

802.11 do not share this property with Ethernet this is because Wireless networks is known to have a kind of potential parallelism, and as thus, it differ from Ethernet.

Wireless networks are known to be a kind of computer networks that are said to not need to be connected by form of cables.

The use of a wireless network is one that helps firms to avoid the costly prices of using cables in their buildings or as a form of connection between their various equipment locations.

Learn more about Ethernet from

https://brainly.com/question/1637942

Answer:

The answer is "range (12, 86, 2)"

Explanation:

Answer:

B is definitely the answer

Answer:

To involve people in major and minor situations that is best for the community to be involved in.

The  problem in my community is lack of pipe borne water.

Africa is known to be a content that has some poverish nation. My community is known to lack good water and that is a key issue i would love to address.

What i can do is to write to the government and other private organizations for help or i will take the project upon myself to construct bore holes for the community. A lot of people do not have access to water during the dry season and this will solve the problem.

An essay can be written by following the steps below:

Note that a good essay is one that that communicate the right message to anyone reading it.

Learn more about water from

https://brainly.com/question/5060579

Based on the scenario, the part of the C-I-A security triad that has failed is maintaining availability.

The C-I-A security triad refers to an abbreviation for confidentiality, integrity and availability. It can be defined as a cybersecurity model that is designed and developed to guide security policies for information security in an organization, so as to effectively and efficiently protect and make their data available to authorized end users.

In this scenario, the part of the C-I-A security triad that has failed is maintaining availability because the database server hardware cannot be replaced immediately if it fails.

Read more on data here: brainly.com/question/25558534

Answer: Command Line Interface

This is also known as a command prompt.

On many systems, this program has a black background and white text font. You can type in commands such as "cd" which means "change directory", or you could type in "mkdir" to make a directory. The commands I'm listing in the examples apply to windows systems but they may also apply to linux and other systems as well.

Answer:

true

Explanation:

Because it is the very best way

Answer:

hope it helps..

Explanation:

four types.

More information: Adaptive, corrective, perfective and preventive are the four types of software maintenance.

PLEASE THANK MY ANSWER

Answer: C

I hope this helps

Answer:

Here is the program that demonstrates the use of JAVA exception:

import java.util.Scanner;  //to accept input from user

public class Main {  //class name

   public static void main(String[] args) {  //start of main method

      Scanner input = new java.util.Scanner(System.in);  //creates Scanner class object to accept input from user

       int number1 = 0;  //stores the first integer value

       int number2 = 0;  //stores the second integer value

       while(true) {  //keeps looping until user enters integer value

           System.out.println("Enter 2 integers to perform addition: "); //prompts user to enter two integer values

           try {  //defines a chunk of code to check for errors        

               number1 = input.nextInt(); //reads input integer 1

               number2 = input.nextInt(); //reads input integer 2                  

               break;             }  

           catch (java.util.InputMismatchException e) { // defines a code chunk to execute if an error occurs in the try code chunk

              System.out.println("Input must be an integer "); //displays this message if user enters anything other than an integer value

              input.nextLine();              }         }  // reads input from user again until user enters both integer type values

       System.out.println("The sum is: " + (number1+number2));      }  } //if user enters 2 integers then computes and displays the sum of two integer values

Explanation:

The program uses InputMismatchException exception and asks the user to input two integers and computes the sum of two integers if user enters  integers otherwise an exception InputMismatchException is thrown and a error message Input must be an integer is displayed to the user if they input a string of letters instead o f integer values. Here while loop is used which keeps executing until user enters both the integer values. After the user enters correct values, the sum of the two integers are computed and result is displayed on output screen. The screenshot of program and its output is attached.

Another program asks the user to input an integer and the program executes correctly if they enter an integer but exception InputMismatchException is thrown with an error message that is is displayed to the user if they input a string of letters. Here is the program:

import java.util.Scanner;

public class Main {

   public static void main(String[] args) {

       Scanner input = new java.util.Scanner(System.in);

       int number1 = 0;          

       while(true) {

           System.out.println("Enter an integer value: ");        

           try {

               number1 = input.nextInt();  

               break;             }  

           catch (java.util.InputMismatchException e) {

              System.out.println("Input must be an integer ");

              input.nextLine();             }        }  

       System.out.println("The program executed correctly!");  } }

Answer:

use fliter the data

Explanation:

brainly patrol don't take this down, there isn't really an explanation type of question.

Answer:

Here is the Python program:

input1 = int(input("Enter an integer: ")) #prompts user to enter an integer

if(input1<0): #if input value is negative

    print("Input1 integer is negative")

elif(input1==0): #if input value is 0

    print("Input 1 integer is zero")

elif(input1<=30): #if input value is less than or equal to 30

    print("Input 1 is positive but less or equal than 30")

else: #if input value is greater than 30

    print("Input 1 is positive and greater than 30")    

Explanation:

I will explain the program with an example

Lets say user enters 16 as input So

input1 = 60

Now the first if condition if(input1<0): is false because 60 is not less than 0

The second elif (else if) condition elif(input1==0): also evaluates to false because 60 is not equals to 0

The third elif condition elif(input1<=30): evaluates to false because the input value is 60 which is not less than or equal to 30.

The fourth else part executes because all the above if elif conditions evaluate to false which means the input number if neither negative, nor 0 and not less than or equal to 30. Hence the input number is greater than 30 and this is true as 60 is greater than 60. So the print statement executes which is:

    print("Input 1 is positive and greater than 30")

The message in the above print statement is printed on the output screen.

The screenshot of the program along with its output is attached.

Answer:

108.7

Explanation:

When someone enters an answer, it's stored in the variable "answer" as a string. Then "weight" is set to the value of the string, converted to a floating-point number (meaning that it has a decimal value, instead of being an integer). At that point weight = 105.7, so when you add 3 to it you get 108.7.

Answer:

bbbbbbbbbbbbnbbnnnnnnnnnnnnnnnnn