To Determine: An ERD from the given information of a database for keeping track of the sponsor, event, location and the contact person.
Answer to Problem P1AYK
Solution: The Entity Relationship Diagram is commonly known as an ERD or an ER diagram. The ERD is used for illustrating various entities such as objects, concepts and people and their relation to one another within a specific system. Such diagrams are utilized to design and define relational database and is commonly used in business information systems, education and software engineering.
Explanation of Solution
Given: SportTech events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where event is located. Each event needs a description, date and cost. The company would also like to have a list of potential sponsors, but a particular sponsor may sponsor more than one event. Each location will need an ID, contact person and phone number. A particular event will use only one location, but a location may be used for multiple events.
An ERD displays the relationships of different entity sets of a database. An entity refers to a component of data. Hence, we can say that an ERD demonstrates the logical structure of a database. An ERD looks similar to a flowchart but its uniqueness lies in its specialized symbols and their meanings. The ER models have a defined set of symbols which are rectangle, oval or diamond-shaped. The connecting lines between these symbols display their relations and interconnection.
The given information includes the following that is to be incorporated to create the ERD.
- The attributes of the Event entity include event type, event date and the event cost.
- The attributes of the Sponsor entity include name, contact number and address.
- The attributes of the Contact Person entity include name and phone number.
- The attributes of the Location entity include location ID and the contact person.
The ERD created below contains all the given details. Each component of the database is related to one another as shown in the diagram.
Conclusion: Hence, the required ERD based on the given details has been created.
Want to see more full solutions like this?
Chapter C Solutions
PRINT COMPANION - BUS DRIVEN INFO SYS
- "I need an expert solution because the previous solution is incorrect." An antenna with a radiation impedance of 75+j10 ohm, with 10 ohm loss resistance, is connected to a generator with open-circuit voltage of 12 v and an internal impedance of 20 ohms via a 2/4-long transmission line with characteristic impedance of 75 ohms. (a) Draw the equivalent circuit (b) Determine the power supplied by the generator. (c) Determine the power radiated by the antenna. (d) Determine the reflection coefficient at the antenna terminals.arrow_forward--3/5- b) g(t) = 3 1441 g(t+mT) = g(t) -31 (i) Complex fourier coefficient Cn. (ii) Complex fourier coefficients - real fourier coefficient (the first 5 non-zero terms) of (iii) sketch the amplitude spectrum g(t) |Cal against n. n= -3 ⇒n=3 (labelling the axis).arrow_forwardQ4) (i) Calculate the fourier transform of : h(t) 2T (is) h(t) 2T -T о T 2T ·(-++T). cos2t ost≤T (iii) hro (4) ((-++T). cos otherwisearrow_forward
- Q2)a) consider the Circuit in figure 2 with initial conditions of Vc (o) = 5V, I₁ (o) = 1A, (i) redraw the circuit in the frequency domain using laplace Wansforms. (ii) using this circuit derive an equation for the Voltage across the inductor in the time domain.. 3.12 ww =V/3F ZH (figure 2) d) Solve the following second order differential equation using laplace transforms. d12 + 5 dx 3x=71 dt - with initial conditions x² (0) = 2, α(0) = 1arrow_forwardb) Another periodic waveform is defined by T c) g(t)= T with g(t+mT) = g(t) and m is an integer. (i) Sketch g(t) over two full cycles in the time domain, labelling the axes. (ii) Derive the formulae for the complex Fourier coefficients c₁ for g(t). For a periodic waveform h(t), if its complex Fourier coefficients are T T when n is odd T 2n²² T 4nn when n is even and not zero 4nn please derive the first five non-zero terms of the real Fourier series for h(t).arrow_forwardQ3)α) f(t) = (-+- 1 Isto f(t+mT) = f(t). L+- I Ost ST integer (i) sketch f(t) 2 full cycles time domain. (labelling the axis). (ii) Derive the formula for the real fourier Coefficients (i) Real Fourier series f(t), first 5 non-terms. an bn for f(t).arrow_forward
- Q3. a) A periodic waveform is defined by T 3 0≤t< f(t) = SIarrow_forwardQ2. a) Sketch the following waveform f(t)=Vo -1/2≤t≤1/2 =0 otherwise and show that its Fourier transform is 2V ωτ ωτ F(s)-sinotsinc) 2 Use this result to sketch a fully labelled graph of the amplitude spectrum of a single square voltage pulse, of amplitude 24V and pulse width 1.4μs, using units of Hz for the frequency axis. (Note: graph paper is not required - a clear, fully-labelled sketch is adequate).arrow_forwardBased on Fig 2, there are 5 states: A, B, C, D, and the goal state. The goal state, when reached gives 80 points as reward, and the discount factor is 0.5. What is the total reward at state A when you first start playing the game? A 60 20 20 50 50 25 C 4 Goal 26 80 B a 80 O b. 60 O c. 20 Od. 50 20 20 -10 D 30arrow_forwardc) Another periodic waveform is defined by 4t g(t)= 0≤tarrow_forwardQ1. a) A periodic waveform is defined by f(t)= 3 0≤tarrow_forwardBased on Fig 2, there are 5 states A, B, C, D, and the goal state. The goal state, when reached, gives 80 points as reward, and the discount factor is 0.5. When you first start playing the game, what action would you take at state A? A 50 C 60 20 25 5 B 20 -10 Down Ob Right Oc. Left Od Up 26 Goal 80 0B 30 Darrow_forwardarrow_back_iosSEE MORE QUESTIONSarrow_forward_iosRecommended textbooks for you
MATLAB: An Introduction with ApplicationsEngineeringISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Essentials Of Materials Science And EngineeringEngineeringISBN:9781337385497Author:WRIGHT, Wendelin J.Publisher:Cengage,
Industrial Motor ControlEngineeringISBN:9781133691808Author:Stephen HermanPublisher:Cengage Learning
Basics Of Engineering EconomyEngineeringISBN:9780073376356Author:Leland Blank, Anthony TarquinPublisher:MCGRAW-HILL HIGHER EDUCATION
Structural Steel Design (6th Edition)EngineeringISBN:9780134589657Author:Jack C. McCormac, Stephen F. CsernakPublisher:PEARSON
Fundamentals of Materials Science and Engineering...EngineeringISBN:9781119175483Author:William D. Callister Jr., David G. RethwischPublisher:WILEY
MATLAB: An Introduction with ApplicationsEngineeringISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncEssentials Of Materials Science And EngineeringEngineeringISBN:9781337385497Author:WRIGHT, Wendelin J.Publisher:Cengage,Industrial Motor ControlEngineeringISBN:9781133691808Author:Stephen HermanPublisher:Cengage LearningBasics Of Engineering EconomyEngineeringISBN:9780073376356Author:Leland Blank, Anthony TarquinPublisher:MCGRAW-HILL HIGHER EDUCATIONStructural Steel Design (6th Edition)EngineeringISBN:9780134589657Author:Jack C. McCormac, Stephen F. CsernakPublisher:PEARSONFundamentals of Materials Science and Engineering...EngineeringISBN:9781119175483Author:William D. Callister Jr., David G. RethwischPublisher:WILEY