Business Driven Information Systems
5th Edition
ISBN: 9780073402987
Author: Paige Baltzan Instructor, Amy Phillips Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter C, Problem P1AYK
To determine
To Determine: An ERD from the given information of a database for keeping track of the sponsor, event, location and the contact person.
Expert Solution & Answer
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?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Moist air initially at T₁ = 140°C, p₁ = 4 bar, and p₁ = 50% is contained in a 2.0-m³ closed, rigid tank. The tank contents are cooled to T₂
35°C.
Step 1
Determine the temperature at which condensation begins, in °C.
8. Cash RegisterThis exercise assumes you have created the RetailItem class for Programming Exercise 5. Create a CashRegister class that can be used with the RetailItem class. The CashRegister class should be able to internally keep a list of RetailItem objects. The class should have the following methods:
A method named purchase_item that accepts a RetailItem object as an argument. Each time the purchase_item method is called, the RetailItem object that is passed as an argument should be added to the list.
A method named get_total that returns the total price of all the RetailItem objects stored in the CashRegister object’s internal list.
A method named show_items that displays data about the RetailItem objects stored in the CashRegister object’s internal list.
A method named clear that should clear the CashRegister object’s internal list.
Demonstrate the CashRegister class in a program that allows the user to select several items for purchase. When the user is ready to check out, the…
5. RetailItem ClassWrite a class named RetailItem that holds data about an item in a retail store. The class should store the following data in attributes: item description, units in inventory, and price.
Once you have written the class, write a program that creates three RetailItem objects and stores the following data in them:
Description Units in Inventory PriceItem #1 Jacket 12 59.95Item #2 Designer Jeans 40 34.95Item #3 Shirt 20 24.95
Chapter C Solutions
Business Driven Information Systems
Knowledge Booster
Similar questions
- Write a class named Patient that has attributes for the following data: First name, middle name, and last name Address, city, state, and ZIP code Phone number Name and phone number of emergency contact The Patient class’s _ _init_ _ method should accept an argument for each attribute. The Patient class should also have accessor and mutator methods for each attribute. Next, write a class named Procedure that represents a medical procedure that has been performed on a patient. The Procedure class should have attributes for the following data: Name of the procedure Date of the procedure Name of the practitioner who performed the procedure Charges for the procedure The Procedure class’s _ _init_ _ method should accept an argument for each attribute. The Procedure class should also have accessor and mutator methods for each attribute. Next, write a program that creates an instance of the Patient class, initialized with sample data. Then, create three instances of the Procedure class,…arrow_forward5. RetailItem ClassWrite a class named RetailItem that holds data about an item in a retail store. The class should store the following data in attributes: item description, units in inventory, and price. Once you have written the class, write a program that creates three RetailItem objects and stores the following data in them: Description Units in Inventory PriceItem #1 Jacket 12 59.95Item #2 Designer Jeans 40 34.95Item #3 Shirt 20 24.95arrow_forwardFind the Error: class Information: def __init__(self, name, address, age, phone_number): self.__name = name self.__address = address self.__age = age self.__phone_number = phone_number def main(): my_info = Information('John Doe','111 My Street', \ '555-555-1281')arrow_forward
- Find the Error: class Pet def __init__(self, name, animal_type, age) self.__name = name; self.__animal_type = animal_type self.__age = age def set_name(self, name) self.__name = name def set_animal_type(self, animal_type) self.__animal_type = animal_typearrow_forwardAir at T₁ = 24°C, p₁ = 1 bar, 50% relative humidity enters an insulated chamber operating at steady state with a mass flow rate of 3 kg/min and mixes with a saturated moist air stream entering at T2=7°C, p₂ = 1 bar. A single mixed stream exits at T3-17°C, p3=1 bar. Neglect kinetic and potential energy effectsarrow_forwardPlease show all workarrow_forward
- Two PCM encoders, PCMI is used to encode a signal which has maximum frequency of 8 kHz and has 150 voltage levels, while PCM2 is used to encode a signal with maximum frequency of 12.8 kHz and 29 voltage levels. Find the bit rate at the output of each encoder. then apply bit multiplexing and find the bit rate at the output of the multiplexer.arrow_forwardHand calculation of cooling loadarrow_forwardAn HEV has a 24kW battery. How many miles can it go on electricity alone at 40 mph on a flat straight road with no headwind? Assume the rolling resistance factor is 0.018 and the Coefficient of Drag (aerodynamic) is 0.29 the frontal area is 2.25m^2 and the vehicle weighs 1618 kg.arrow_forward
- Task 2: Comparable Interface and Record (10 Points) 1. You are tasked with creating a Java record of Dog (UML is shown below). The dog record should include the dog's name, breed, age, and weight. You are required to implement the Comparable interface for the Dog record so that you can sort the records based on the dogs' ages. Create a Java record named Dog.java. name: String breed: String age: int weight: double + toString(): String > Dog + compareTo(otherDog: Dog): int > Comparable 2. In the Dog record, establish a main method and proceed to generate an array named dogList containing three Dog objects, each with the following attributes: Dog1: name: "Buddy", breed: "Labrador Retriever", age: 5, weight: 25.5 Dog2: name: "Max", breed: "Golden Retriever", age: 3, weight: 30 Dog3: name: "Charlie", breed: "German Shepherd", age: 2, weight: 22 3. Print the dogs in dogList before sorting the dogList by age. (Please check the example output for the format). • 4. Sort the dogList using…arrow_forwardAs shown in the figure below, moist air at T₁ = 36°C, 1 bar, and 35% relative humidity enters a heat exchanger operating at steady state with a volumetric flow rate of 10 m³/min and is cooled at constant pressure to 22°C. Ignoring kinetic and potential energy effects, determine: (a) the dew point temperature at the inlet, in °C. (b) the mass flow rate of moist air at the exit, in kg/min. (c) the relative humidity at the exit. (d) the rate of heat transfer from the moist air stream, in kW. (AV)1, T1 P₁ = 1 bar 11 = 35% 120 T₂=22°C P2 = 1 bararrow_forward2. A moving bed adsorption column needs to be designed to separate hydrophobic proteins from a fermentation broth. The following adsorption equilibrium data was observed in preliminary isotherm studies. The resin used was activated carbon with a porosity of 0.2. The overall mass transfer coefficient was determined to be 10 h¹, and the ratio of volumetric flow rate of broth to resin is 10. Determine the diameter of the column if the column height is limited to 2.5 m (indoor operation) with a flow rate of 20 m³/h, influent concentration of 7 g/L, and effluent concentration of 0.1 g/L. qi (mg/kg) Ci (g/L) 0.1 4.7 7.5 0.25 10.6 0.5 15.0 1.0 23.7 2.5 33.5 5.0 41.1 7.5arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended 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 Applications
Engineering
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Essentials Of Materials Science And Engineering
Engineering
ISBN:9781337385497
Author:WRIGHT, Wendelin J.
Publisher:Cengage,
Industrial Motor Control
Engineering
ISBN:9781133691808
Author:Stephen Herman
Publisher:Cengage Learning
Basics Of Engineering Economy
Engineering
ISBN:9780073376356
Author:Leland Blank, Anthony Tarquin
Publisher:MCGRAW-HILL HIGHER EDUCATION
Structural Steel Design (6th Edition)
Engineering
ISBN:9780134589657
Author:Jack C. McCormac, Stephen F. Csernak
Publisher:PEARSON
Fundamentals of Materials Science and Engineering...
Engineering
ISBN:9781119175483
Author:William D. Callister Jr., David G. Rethwisch
Publisher:WILEY