Using the descriptions given in the figure, convert the ERD shown in Figure P6.2 into a...

Using the descriptions given in the figure, convert the ERD shown in Figure P6.2 into a dependancy diagram that is in at least 3NF.

Solutions

Expert Solution

Dependency diagram for given ERD:

PRESENTATION:

REGISTRATION:

ATTENDEE:

Here,
REGISTRATION and ATTENDEE are 3NF
PRESENTATION is not 3NF

So, remove the attributes which are depending on a non-key attribute from the given relation to convert the PRESENTATION into 3NF.

Hence, the database can be divided into four relations as below.

PRESENTATION:

REGISTRATION:

ATTENDEE:

AUTHOR:

venereology answered 1 year ago

Next > < Previous

Related Solutions

Using my chosen figure Sargon. Introduce your chosen figure, and provide descriptions of the following elements:...

Using my chosen figure Sargon. Introduce your chosen figure, and provide descriptions of the following elements: the leader, when he or she lived, and the area over which he or she presided. Include notable actions and accomplishments associated with his or her period of leadership. Identify the lasting significance of this ruler on the modern world. Your response must be a minimum of 300 words in length.

Match the descriptions below with the correct answer, using the letter codes shown in the table...

Match the descriptions below with the correct answer, using the letter codes shown in the table below. (8 points) A. Realizable value B. Percentage of receivables method C. 1/10, n/60 D. Bad debt Expense E. Aging of receivables F. Direct write-off method G. Operating cycle H. Specific identification method I. FOB shipping point J. Time period assumption K. n/10 EOM L. Percentage of sales method M. Permanent accounts N. 2/10, EOM O. 2/10, n/30 P. FOB destination The economic life...

Given the two charged particles shown in the figure below, find the electric field at the...

Given the two charged particles shown in the figure below, find the electric field at the origin. (Let q1 = −26.00 nC and q2 = 7.00 nC. Express your answer in vector form.) q1 is at (2,4) and q2 is at (-2,3)

Consider the reversible Carnot cycle shown in the following figure given below with 1.19 mol of...

Consider the reversible Carnot cycle shown in the following figure given below with 1.19 mol of an ideal gas with C V,m =5R/2 as the working substance. The initial isothermal expansion occurs at the hot reservoir temperature of T hot = 890 K from an initial volume of 3.85 L ( V a ) to a volume of 10.5 L ( V b ) . The system then undergoes an adiabatic expansion until the temperature falls to T cold =...

What is the equivalent resistance for the circuit shown in the figure? (Figure 1) For the...

What is the equivalent resistance for the circuit shown in the figure? (Figure 1) For the circuit shown in the figure, find the current through resistor R1=6.0?(left). (Figure 1) For the circuit shown in the figure, find the potential difference across resistor R1=6.0?(left). For the circuit shown in the figure, find the current through resistor R2=15?. For the circuit shown in the figure, find the potential difference across resistor R2=15?. For the circuit shown in the figure, find the current...

A piece of insulated wire is shaped into a figure eight as shown in the figure...

A piece of insulated wire is shaped into a figure eight as shown in the figure below. For simplicity, model the two halves of the figure eight as circles. The radius of the upper circle is 4.00 cm and that of the lower circle is 8.00 cm. The wire has a uniform resistance per unit length of 7.00 Ω/m. A uniform magnetic field is applied perpendicular to the plane of the two circles, in the direction shown. The magnetic field...

(a) Using the root locus plot shown in figure Q2 (a), find the system damped natural...

(a) Using the root locus plot shown in figure Q2 (a), find the system damped natural frequency ( d) when the system is marginally stable, then find the maximum gain for stable system. [5 Marks ] (b) Using the Root locus plot shown in figure Q2 (a), determine the open loop transfer function. [ 5 Marks ] Figure Q2 (a) open-loop Transfer function Root Locus Plot (c) G(s) is an open loop system transfer functions that include an adjustable gain...

For the system of capacitors shown in the the figure below(Figure 1) , a potential difference...

For the system of capacitors shown in the figure below(Figure 1), a potential difference of 25.0V is maintained across ab.Part (a): What is the equivalent capacitance of this system between a and b in nF?Part (b): How much charge is stored by this system in nC?Part (c): How much charge does the 6.50 nF capacitor store in nC?Part (d): What is the potential difference across the 7.50 nF capacitor in V?

As shown in the figure (Figure 1) , a superball with mass m equal to 50...

As shown in the figure (Figure 1) , a superball with mass m equal to 50 grams is dropped from a height of hi=1.5m . It collides with a table, then bounces up to a height of hf=1.0m . The duration of the collision (the time during which the superball is in contact with the table) is tc=15ms . In this problem, take the positive y direction to be upward, and use g=9.8m/s2 for the magnitude of the acceleration due to...

The survey data shown as Figure 10 in Chapter 27 indicate that most economists invest using...

The survey data shown as Figure 10 in Chapter 27 indicate that most economists invest using low-cost index funds. Index funds invest in the whole stock market (or at least a large chunk of it). The “low-cost” part matters because even fees that seem small can have a big cumulative effect on your returns over time. Actively managed funds have higher fees. Index funds are not managed so they will have lower fees. Mutual funds typically come with two types...

Subjects