All categories

2 years ago

Write two example use of relationships ICT

Computers and Technology

1 answer:

Yakvenalex [24]2 years ago

3 0

Answer:

Read it all before you write if this isn't what you searching for I'm sorry...:(

A relationship, in the context of databases, is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationships allow relational databases to split and store data in different tables, while linking disparate data items.

For example, in a bank database a CUSTOMER_MASTER table stores customer data with a primary key column named CUSTOMER_ID; it also stores customer data in an ACCOUNTS_MASTER table, which holds information about various bank accounts and associated customers. To link these two tables and determine customer and bank account information, a corresponding CUSTOMER_ID column must be inserted in the ACCOUNTS_MASTER table, referencing existing customer IDs from the CUSTOMER_MASTER table. In this case, the ACCOUNTS_MASTER table’s CUSTOMER_ID column is a foreign key that references a column with the same name in the CUSTOMER_MASTER table. This is an example of a relationship between the two tables.

You might be interested in

Write a method called removeHighPrice that will go through a provided ArrayList called prices and removes the first price that i

Diano4ka-milaya [45]

Answer:

The method written in Java is as follows:

public static ArrayList<Double> removeHighPrice (ArrayList<Double> prices){

for(int i =0;i<prices.size();i++){

if(prices.get(i) > 5.00){

prices.remove(i);

break;

}

return(prices);

}

Explanation:

This line declares the method

public static ArrayList<Double> removeHighPrice (ArrayList<Double> prices){

This line iterates through the ArrayList named prices

for(int i =0;i<prices.size();i++){

This checks if current price is greater than 5

if(prices.get(i) > 5.00){

If yes, the price is removed

prices.remove(i);

And the loop is terminated

break;

}

This returns the ArrayList

return(prices);

}

<em>I've added as an attachment, the complete program which includes the main method</em>

Download txt

6 0

3 years ago

Forms often allow a user to enter an integer. Write a program that takes in a string representing an integer as input, and outpu

Bond [772]

Answer:

user_string = input("Input a string : ")

output = user_string.isnumeric()

if output == True:

print("yes")

else:

print("no")

Explanation:

First of all check whether user input have all numeric value or not .
Display yes if string contain all numeric values .
Display no if string contain at least one non - integer character .

7 0

3 years ago

Read 2 more answers

Please help me I don't understand. It's Python.

Vitek1552 [10]

It’s , c probably sorry if I’m wrong

8 0

3 years ago

Read 2 more answers

Windows uses a memory-management technique known as ________ to monitor which applications you use most frequently and then prel

lukranit [14]

Answer:

SuperFetch

Explanation:

Superfetch is a memory management technique on windows service that enables or fetch frequently use applications on systems and launch them faster because the frequently use applications has been preload into the system memory for easy access when they want to be used.

SuperFetch always takes notice of all application running on your system in which when you exit a frequently used application SuperFetch will preload them immediately since it is saved on the system memory.

One of the most important part of Superfetch is that it saves alot of time because you don't have to search the applications before you get access to them in as far as the application was frequently used.

5 0

3 years ago

Assume that ip has been declared to be a pointer to int and that enrollment has been declared to be an array of 20 elements . As

Vitek1552 [10]

Answer:

ip = enrollment + section;

Explanation:

The variable ip has been declared to be a pointer to int.

int * ip;

The variable enrollment has been declared as an array of 20 elements .

int enrollment[20];

The variable section has been declared as an int.

int section;

In order to make ip point to the element in the array indexed by section, we can use the following statement :

ip = enrollment + section;

This will make ip point to enrollment[section].

5 0

3 years ago