your database design should avoid two tables with a _____ relationship

Answers

Answer 1

In a well-designed database, you should avoid having two tables with a circular or recursive relationship. This means that two tables should not have a direct relationship where each table references the other as a foreign key.

For example, let's say we have two tables: "Employees" and "Managers." Each employee has one manager, and each manager manages a group of employees. In this scenario, the "Employees" table can have a foreign key referencing the "Managers" table to represent the manager of each employee. However, it would be problematic to have a foreign key in the "Managers" table referencing the "Employees" table to represent the employees managed by each manager. This would create a circular relationship between the two tables.

To avoid this situation, you can introduce a third table, such as "EmployeeManager," which acts as a junction or associative table. This table would contain foreign keys to both the "Employees" and "Managers" tables, allowing you to establish a many-to-many relationship between employees and managers. This design resolves the circular relationship issue and provides a more normalized database structure.

Learn more about Database https://brainly.com/question/518894

#SPJ11


Related Questions

1. ¿Dónde emergieron los Bancos Centrales? 2. ¿En qué siglo los Bancos Centrales se potenciaron? 3. ¿El Banco de Suecia en qué siglo fue fundado? 4. ¿En el año de 1694 qué Banco se creó? 5. ¿Quién creo en 1800 el Banco Francés? 6. ¿En qué siglo y años Estados Unidos creó el Banco Estados Unidos? 7. Entre 1861 -1865 Abraham Lincoln creo el primer Banco y único Banco Central ¿Cuál erasu objetivo? 8. ¿Cuál otras funciones cumplían los Bancos en el siglo XIX?

Answers

Answer:

. ¿Dónde emergieron los Bancos Centrales?

El primer banco central fue creado por el Parlamento Sueco en 1668, siendo su principal acreedor la Corona Sueca. Esto generó inflación y crisis financieras. Después de un siglo, en 1779, la ley fue modificada, obligando al Banco a que la masa monetaria fuese respaldada por oro en una proporción fija. Sin embargo, comenzó la guerra con Rusia y se regresó a su origen violando el precepto de estabilidad que confería ese patrón oro.

2. ¿En qué siglo los Bancos Centrales se potenciaron?

La historia de la banca central se remonta al menos al siglo XVII, con la fundación de la primera institución reconocida como un banco central, el Banco de Suecia.

3. ¿El Banco de Suecia en qué siglo fue fundado?

El primer banco central fue creado por el Parlamento Sueco en 1668.

4. ¿En el año de 1694 qué Banco se creó?

En 1694, se creó el Banco de Inglaterra, que sería el más famoso banco central durante casi 300 años.

5. ¿Quién creo en 1800 el Banco Francés?

Fue creado por Napoleón en 1800 para estabilizar la moneda después de la hiperinflación del papel moneda generado durante la Revolución Francesa y las conquistas napoleónicas.

6. ¿En qué siglo y años Estados Unidos creó el Banco Estados Unidos?

A principios del siglo XIX, Estados Unidos creó el Banco de los Estados Unidos (1791-1811) y luego un segundo Banco de los Estados Unidos (1816-1836) tras el cierre del primero. Ambos bancos se establecieron siguiendo el modelo del Banco de Inglaterra. Pero a diferencia de los británicos, los estadounidenses tuvieron una desconfianza profunda de cualquier concentración de poder financiero en general, y de los bancos centrales, en particular.

7. Entre 1861 -1865 Abraham Lincoln creo el primer Banco y único Banco Central ¿Cuál erasu objetivo?

Abraham Lincoln creó el primer y único Banco Central público del país, con el objetivo de garantizar los pagos de guerra.

8. ¿Cuál otras funciones cumplían los Bancos en el siglo XIX?

Se exigió la creación de una estructura crediticia flexible que fuera capaz de dar respuestas a las empresas de ferrocarril y a los barcos de vapor,

Explanation:

. ¿Dónde emergieron los Bancos Centrales?

El primer banco central fue creado por el Parlamento Sueco en 1668, siendo su principal acreedor la Corona Sueca. Esto generó inflación y crisis financieras. Después de un siglo, en 1779, la ley fue modificada, obligando al Banco a que la masa monetaria fuese respaldada por oro en una proporción fija. Sin embargo, comenzó la guerra con Rusia y se regresó a su origen violando el precepto de estabilidad que confería ese patrón oro.

2. ¿En qué siglo los Bancos Centrales se potenciaron?

La historia de la banca central se remonta al menos al siglo XVII, con la fundación de la primera institución reconocida como un banco central, el Banco de Suecia.

3. ¿El Banco de Suecia en qué siglo fue fundado?

El primer banco central fue creado por el Parlamento Sueco en 1668.

4. ¿En el año de 1694 qué Banco se creó?

En 1694, se creó el Banco de Inglaterra, que sería el más famoso banco central durante casi 300 años.

5. ¿Quién creo en 1800 el Banco Francés?

Fue creado por Napoleón en 1800 para estabilizar la moneda después de la hiperinflación del papel moneda generado durante la Revolución Francesa y las conquistas napoleónicas.

6. ¿En qué siglo y años Estados Unidos creó el Banco Estados Unidos?

A principios del siglo XIX, Estados Unidos creó el Banco de los Estados Unidos (1791-1811) y luego un segundo Banco de los Estados Unidos (1816-1836) tras el cierre del primero. Ambos bancos se establecieron siguiendo el modelo del Banco de Inglaterra. Pero a diferencia de los británicos, los estadounidenses tuvieron una desconfianza profunda de cualquier concentración de poder financiero en general, y de los bancos centrales, en particular.

7. Entre 1861 -1865 Abraham Lincoln creo el primer Banco y único Banco Central ¿Cuál erasu objetivo?

Abraham Lincoln creó el primer y único Banco Central público del país, con el objetivo de garantizar los pagos de guerra.

8. ¿Cuál otras funciones cumplían los Bancos en el siglo XIX?

Se exigió la creación de una estructura crediticia flexible que fuera capaz de dar respuestas a las empresas de ferrocarril y a los barcos de vapor,

# input a mark in a subject of a student and
Check if the student is pass or not pass [pass mark=30]​

Answers

Answer:

mark = int(input("Enter mark: "))

if (mark >= 30):

 print("Pass")

else:

 print("Not pass")

Explain in not less than 3 Sentences

1. Decimal Number System


2.Binary Number System​

Answers

Answer:

The Decimal Numeral system :-

It is the standard system for denoting integer and non-integer numbers. It is the extension to non-integer numbers of the Hindu–Arabic numeral system.

Binary Number system :-

It is a number expressed in the base-2 numeral system , which uses only two symbols: typically "0" and "1". The base-2 numeral system is a positional notation with a radix of 2. Each digit is referred to as a bit, or binary digit.

hope it helps you...

WHAT IS MULTIMEDIA SUPPOSED TO MEAN ???

Answers

Answer:

using more than one medium of expression or communication

Answer:

It basically means using more than one expression or form of communication

Explanation:

What percentage of teens say they have witnessed cyberbullying?

50

95

70

35

Answers

A Majority of Teens Have Experienced Some Form of Cyberbullying. 59% of U.S. teens have been bullied or harassed online, and a similar share says it's a major problem for people their age

254 × (×) igual 20×()682883993

PLEASE HELP ITS TIMED Ishmael would like to capture a selected portion of his screen and then capture actions he performs on that selected portion. What should he do?


Use the Video from My PC command.

Use the Insert Screen Recording control.

Create a poster frame.

Use an embed code.

Answers

Answer:

Option B

Hope this Helps!!! :)

What are some other projects or things you do in your life (other than writing an essay) where you use an iterative process?

Answers

Answer:The iterative design process occurs in a continuous cycle involving three unique stages: formulate, test, evaluate. These core elements make up the basic progression in which the development of a game will follow. The rest is simply rinse and repeat

Explanation:

Answer:

Coke has experimented with different formulations of its popular Coca Cola product, including the failed New Coke iteration. The aim is to achieve the best tasting product that customers like.

A company that is operating a factory or assembly line may experiment with different methods of arranging the assembly line or with different production methods. Each time the production process is changed, this is a different iteration. Each time the order of operations and procedures are changed, this is a different iteration. The goal is to achieve the fastest, best and most optimal method of creating a product.

A musician may start with one version of a song and refine it, making changes to a note here and there or changing the tempo and speed. Many different iterations of a song may be created this way until the optimal finished product has been created that sounds and works the best.

A cook may experiment with a recipe, tweaking the ingredients or changing different steps of the process slightly until the food tastes as good as it possibly can.

Microsoft has released multiple versions of the Windows operating system to add functionality for users and to correct bugs. Each different version is a different iteration of its operating system and the goal is for the next iteration to be better than the last.

Explanation:

Pick an example, and put it in your own words.

Which finger is used to press SHIFT key while typing!
A. Little finger
B. Thumb
C. Index finger
D. Ring Finger ​

Answers

Answer:

Little Finger (A)

Explanation:

it would be A. little finger i’m pretty sure

PLS HELP ASAP suppose you want to find pages that contain the word German but not the word shepherd. which search would achieve this?
German OR shepherd
German- shepherd
"GERMAN shepherd"
"German"+"shepherd"

Answers

Answer: German- shepherd

Explanation:

If I want to find pages that contain the word German but not the word shepherd, the search would achieve this would be German- shepherd.

It should be noted that other options such as German OR shepherd, "GERMAN shepherd" and "German"+"shepherd" all mean that pages containing the words German and also shepherd will be found.

The (-) sign simply means that not. Therefore, the correct option is German - shepherd which means German but not shepherd.

Answer:

German- shepherd

Explanation:

If someone said to you, “Pseudocode is a waste of time! It’s just more work because you end up writing the same program twice,” how would you explain the benefits of pseudocode?

Answers

Answer:

It allows the designer to focus on main logic without being distracted by programming languages syntax.

* Since it is language independent, it can be translated to any computer language code.

* It allows designer to express logic in plain natural language.

* It is easier to write actual code using pseudocode.

* Unlike algorithms, pseudocodes are concise so pseudocodes are more readable and easier to modify.

Explanation:

what is a defult? pls help if you wouldn't mind

Answers

Answer:

a beginner or a novice

Explanation:

failure to fulfill an obligation, especially to repay a loan or appear in a court of law.


What is programming?​

Answers

Answer:

using code etc to change how something works out make it work how you want it to. mostly code but sometimes circuit boards and stuff like that.

Explanation:

see above

Answer:

Programming is the process of creating a set of instructions that tell a computer how to perform a task.

Find the cost of 2m 20cm at 25p per metre​

Answers

Answer: 55 meters.

Explanation:

First convert the 20 cm to meters so the entire number is in meters.

1 meter = 100 cm

20 in cm is:

= 20/100

= 0.2 meters.

2.2 meters.

One meter costs 25p so 2.2 meters will cost:

= 2.2 * 25

= 55 meters

What line of code would you edit if you wanted a bigger sprite?This is computer science.Pick branliest if right


A.3

B.4

C.5

D.You have to edit the picture itself

Answers

pretty sure the answer is a-3

Answer:

C. 5

Explanation:

Line 3 refers to the positioning of the sprite.

Line 4 refers to the animation preset of the sprite.

Line 5 is the correct choice because in the code it references scale and a value which can be modified to make the sprite bigger. For example, from 0.3 to 0.5

If I'm right please give brainliest, thanks

In French class, Blue puts on a visor and the environment changes to that of a café in Paris. Which of the following terms describes this kind of technology?

Answers

Answer:

virtual reality

Explanation:

Answer:

virtual

Explanation:

virtual and realyty

What storyboarding technique uses a combination of two techniques, and which techniques does it combine?
O A. hierarchical; wheel and linear
O B. linear; webbed and hierarchical
O C. webbed; linear and hierarchical
© D. wheel; webbed and linear

Answers

Answer:

d

Explanation:

Answer:

They're right, it's c:  webbed; linear and hierarchical

Explanation:

Edmentum, I got it right.

Frida has been given the task of creating a database to store all her company's records and sales records. She is going to produce a relational database. The customers records will have the fields Customer_id, Name, Contact_Phone, and card Number. The sales records will have the fields Invoice_number, Item_number, Item_description, Item_cost and Customer_ref.

Complete the diagram below to show how the tables will be combined.

Answers

Answer:

A value that's used to identify a record from a linked table is called a ______. ... A database administrator is setting up a new table that will contain customer ... The fields include name, address, company, phone, email, and customer ID. ... Gina does not know how to write SQL commands and no forms have been created.

Explanation:

Choose all items that are true about the two example of HTML shown on the right.

Example 1 will display differently than example 2 in a web browser.

They are styled differently, but will look the same in a web browser.

Example 2 is easier to analyze and repair.

The styling in example 2 is required by modern web browsers.

Answers

Answer:

2

Explanation:

Answer:

B and C

Explanation:

When you click on what will happen?

The font will change back to the default setting.
The document will change back to the last time you saved it.
The last step will be undone.
The last step will be redone.

Answers

The last step is undone. The default font choices in Microsoft Word are one of the biggest sources of ongoing annoyance for legal users.

What is Default setting?

you can alter just two Styles (+Body and +Headings) permanently to give your papers a more professional typography.

There is a drop-down menu labeled Fonts over to the far right. You can view a list of preconfigured font sets by clicking on Fonts. You want to select Customize Fonts from here.

You can see the Body font and the Heading font on the left. Here is where you control the two Styles, +Body and +Headings, that I mentioned previously.

Therefore, The last step is undone.

To learn more about default font, refer to the link:

https://brainly.com/question/21104940

#SPJ1

Answer: C The last step will be undone. this is the Undo Icon

Explanation:

Enumerate the steps on how to set-up the CD-ROM as the first boot device.​

Answers

Answer:

Explanation:

1)Press boot key ( Del or specified key)

to enter BIOS setup utility.

2) using the direction keys, make selection of "Advanced BIOS Features"

3)then access Advanced BIOS setting by pressing Enter key

4. Using up/ down arrow keys Select "First Boot

Device"

.

5) Using up and down keys, select "CD-ROM "

6. go back to "BIOS setting screen" by Pressing ESC key

7. Select " Save & Exit Setup"

.

3 uses for a GPS system other than for a satellite navigation system

Answers

Answer:

Location – determining a position. Navigation getting from one location to another. Tracking – monitoring object or a personal movement. Mapping – creating maps of the world.

I need help writing the algorithm I know how to do the flow chart for the first one but I’m not sure if the second question is a for loop

Answers

Answer:

The algorithm is as follows:

(a) Sales and commission

1. Start

2. Input Sales

3. Commission = 0.30 * Sales

3. If sales >= 4000.00 then

3.1   Commission = 0.60 * Sales

4. End If

5. Print Commission

6. Stop

(b) Amount of Rainfall

1. Start

2. Days = 1

3. Total = 0.0

4. While Days <= 31

4.1. Input Rainfall

4.2. Total = Total + Rainfall

4.3. Days = Days + 1

4.4. End If

5. Print Total

6. Stop

See attachment for flowchart

Explanation:

(a) Sales and commission

This begins the algorithm

1. Start

This gets sales from the user

2. Input Sales

This calculates the commission based on 30% (i.e. for sales < 4000)

3. Commission = 0.30 * Sales

This checks if sales is greater than or equal to 4000

3. If sales >= 4000.00 then

This calculates the commission as 60% of Sales

3.1   Commission = 0.60 * Sales

This ends the if condition

4. End If

This prints the calculated commission

5. Print Commission

This ends the algorithm

6. Stop

(b) Amount of Rainfall

This begins the algorithm

1. Start

This initializes the number of days to 1

2. Days = 1

This initializes total rainfall to 0

3. Total = 0.0

The following while loop is repeated until day 31st

4. While Days <= 31

This gets input for Rainfall from the user

4.1. Input Rainfall

This calculates the total rainfall

4.2. Total = Total + Rainfall

This increments the number of days

4.3. Days = Days + 1

This ends the if statement

4.4. End If

This prints the total rainfall

5. Print Total

This ends the algorithm

6. Stop

___________ is a computer programming language.

Answers

Python!!! I hope that helped!!
Pascal, c+, c++ etc

Which option is the default when creating appointments and meetings in a user’s own calendar as it relates to Free/Busy information that others will see when looking at the user’s calendar?

a. Free
b. Working Elsewhere
c. Busy
d. Tentative
I only have 10 minutes left so please help fast!

Answers

Answer:

C !

Explanation:

Answer:

Busy

Explanation:

Need help ASAP

Thankss + BRAINLIST only for correct answers

Answers

Why visit it?
For entertainment, purely for the user to enjoy the content that has been produced for them.

Why was it made?
Netflix is a subscription based service that has been made to allow users to stream TV shows and other entertainment sources. It was made for leisure.

16
Mackenzie is the network administrator for a large security corporation. What task
might Mackenzie perform as part of her job?
O answering calls from customers who need help
9
developing a website for the corporation
12
connecting a new computer to the network
15
testing a new video game before its release

Answers

Answer:

Connecting a new computer to the network.

Answer:

C. Connecting a new computer to the network

Explanation:

That is part of the job and the test say it is correct.

6. A presentation is widely used to present and effectively​

Answers

Answer:

A Presentation is a collection of slides arranged in a systematic order. 2) A presentation ...

Explanation:

Please give thanks to all my answers and please mark as brilliant and please follow me

Could someone please help?​

Answers

Answer:

it looks difficult

Explanation:

you can devotingly solve it

What is the output of this Python code?
def guess(a, b, c):
if a > b and a < c:
print(True)
else:
print(false)
X = 45
y = 31
z = 78
guess(x, y, z)

Answers

Answer:

True

Explanation:

in function guess:- a = x; b = y; c = z

so 45 > 31 AND 45 < 38

since both the stements are true

True is printed

What is the name of the function below?

function go(){
alert("hello everybody");
}

Answers

Answer:

It’s Java script I think and it makes something say hello everybody

Explanation:

Other Questions
write a dicriptive paragrah on your "favorite person".Write in your own words An agent's appointment remains in effect until any of the following takes place, except:A) Cancellation or expiration of the licenseB) The filing of a notice of termination by the appointing insurerC) The agent attains the age of 65 For the reaction NH4Cl(aq)NH3(g) + HCl(aq) H = 86.4 kJ and S = 79.1 J/K The equilibrium constant for this reaction at 261.0 K is a simple example of a repetition control structure is the command. group of answer choices true false HELP!!! WILL GIVE BRAINLIST!!!A small segment of DNA has the following nitrogen base sequence: DNA = TAC CCT ACC ATTa) Determine the complementary mRNA codons:_____________________________________________b) What are the tRNA anticodons?_____________________________________________c) What amino acids are called for by this sequence? _____________________________________________d) What is the importance of the "start" and "stop" codons? _____________________________________________ Which statement describes super PACs?They do not get involved in elections.They support all candidates equally.They operate the same as regular PACs but with more money.They can raise an unlimited amount of money. mary works as a salesperson in a retail shoe store. of the five stages in the selling process, mary is least likely to engage in TRUE/FALSE. The growth of the NIH, which sponsors most of the biomedical research in the United States, has reflected the growth of concern about chronic degenerative diseases. What might have helped the Greek city-states to be more cooperative at the end of the Peloponnesian War? A sinusoidal voltage has a peak value of 15 V, has a frequency of 125 Hz, and crosses zero with positive slope att 1 ms. Choose the correct expression for the voltage y(t) = 15 cos(250mt-135)V s(t) = 15 cos(250mt-135) V 0 (t) = 15cos(125mt-135) V O v(t) = 15 cos(125mt +135.) V You are troubleshooting a computer that is being used primarily to serve Web pages and respond to Active Directory requests. Which operating system are you most likely using? a. Windows 10 b. Windows Server 2019 C. Mac OS X El Capitan d. Ubuntu for desktops Consider a civilization broadcasting a signal with a power of 1.110^4 watts. The Arecibo radio telescope, which is about 300 meters in diameter, could detect this signal if it is coming from as far away as 105 light-years. Suppose instead that the signal is being broadcast from the other side of the Milky Way Galaxy, about 70000 light-years away. How large a radio telescope would we need to detect this signal? (Hint: Use the inverse square law for light.)How large a radio telescope would we need to detect this signal? most chronic diseases are a natural consequence of aging regardless of a person's lifestyle behavior.A. TRUE B. FALSE if you had 2 linked genes each with 4 alleles, how many different haplotypes could there be Here are some milestones in the development of technology used bygeographers. Put them in the order in which they appeared in history.AstrolabeAerial photographyScale mapsCompass Choose the best answer below to the following question: Is the following CSS code valid?table { border: 2px #000000 solid;border-collapse: collapse;} Find the value of X. Carpeta de recuperacion de ingles de 5to de secundaria the mass of a nucleus is _______________ the sum of the masses of its nucleons. always more than sometimes equal to always less than sometimes less than always equal to Medicare Part A does not pay for medical benefits provided for treatment in a skilled nursing facility beyond 30 days 60 days 100 days 120 days. 100 days -.