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
Business Driven Information Systems
- The shelf bracket is subjected to the force F = 372 Newtons at an angle = 21.4°. Compute the moment (in N-m) that this force exerts about each of the two attachment points (screw locations in the figure). Take counterclockwise moments to be positive. a duk F -0 2013 cc Michael Swanbom BY NC O SA Values for dimensions on the figure are given in the following table. Note the figure may not be to scale. Variable Value a 43.0 cm b 32.3 cm с 2.58 cm The moment about the upper attachment point is N-m. The moment about the lower attachment point is N-m.arrow_forwardNEED HANDWRITTEN SOLUTION PLEASE DO NOT USE AIarrow_forwardA man skis down a slope. His initial elevation was 150 m and his velocity at the bottom of the slope is 17 m/s. What percentage of his initial potential energy was consumed due to friction and air resistance? Use the accounting equation in your calculations.arrow_forward
- 9.5. The input & to a PI controller is shown in Fig. P9-5. Plot the output of the controller if Ke 2 and 0.50 min. - E 0.5 0 -0.5 0 FIGURE P9-5 2 4 t, minarrow_forwardNot: I need also pictures cct diagram and result Question: I need a MATLAB/Simulink model for a Boost Converter used to charge a battery, powered by a PV solar panel. The model should include: 1. A PV solar panel as the input power source. 2. A Boost Converter circuit for voltage regulation. 3. A battery charging system. 4. Simulation results showing voltage, current, and efficiency of the system.arrow_forward9.3. An ideal PD controller has the transfer function P Ke (TDs + 1) E An actual PD controller had the transfer function P = Ke E TDS +1 (TDIẞ)s +1 where ẞis a large constant in an industrial controller. If a unit-step change in error is introduced into a controller having the second transfer function, show that P(1) = Kc (1 + Ae˜¯BD) where A is a function of ẞwhich you are to determine. For ẞ=5 and K = 0.5, plot P(t) versus tl tp. As ẞ, show that the unit-step response approaches that for the ideal controller.arrow_forward
- In direct calorimetry, a person is placed in a large, water-insulated chamber. The chamber is kept at a constant temperature. While in the chamber, the subject is asked to perform a number of normal activities, such as eating, sleeping, and exercising. The rate of heat released from the subject’s body can be measured by the rate of heat gain by the water bath. Would direct calorimetry be a practical way to measure metabolic rate? Why or why not?A person is placed inside a calorimetric chamber for 24 hours. During this time, the 660-gallon water bath heats up by 3.2°F. What is the subject’s metabolic rate during this period? Report your answer in kcal/day. Assume that there is no heat loss from the water to the surroundings.arrow_forwardDetermine the node voltages V1, V2, V3, and V4, for the circuit shown in the figure where R1-15.2, R2=652, R3-72 and R4=5.2. 5 V V2 R1 w V1 R2 V3 R3 + 1.25 A R4 ①1.25 V4 15 Varrow_forwardUpon reentry into the Earth’s atmosphere, the bottom of a space shuttle heats up to dangerous levels as the craft slows for landing. If the velocity of the shuttle is 28,500 km/hr at the beginning of reentry and 370 km/hr just prior to landing, how much energy is lost as heat? The shuttle has a mass of 90,000 kg. Assume that the change in potential energy is negligible compared to the change in kinetic energy.arrow_forward
- 9.1. A pneumatic PI temperature controller has an output pressure of 10 psig when the set point and process temperature coincide. The set point is suddenly increased by 10°F (i.e., a step change in error is introduced), and the following data are obtained: Time, s psig 0- 10 0+ 8 20 7 60 90 5 3.5 Determine the actual gain (psig per degree Fahrenheit) and the integral time.arrow_forwardhow to know the weight to data and data to weight also weight by infomraion gain in rapid miner , between this flow diagram retrieve then selecte attrbuite then set role and split data and decision tree and apply model and peformance ,please show how the operators should be connected:arrow_forwardPlease show how to solve each item.arrow_forward
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