ZuoTi.Pro
Question

Tutorial 5 Assignment Complete the following Question "SportTech Events". You must draw your diagram in LucidChart....

Tutorial 5 Assignment

Complete the following Question "SportTech Events". You must draw your diagram in LucidChart. Explain your works in step by step and explain how to draw the diagram in LucidChart.

SportTech Events: 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 the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information, such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create an ERD from the information described above and then to create a normalization structure in 3NF.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

If you have any doubts, please give me comment...

description ame date phone_number Event have Sponsor cost address use location ID phone_number contact_person

0 0
Add a comment
Know the answer?
Add Answer to:
Tutorial 5 Assignment Complete the following Question "SportTech Events". You must draw your diagram in LucidChart....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • you can draw it out it use lucidchart whichever is easier for you. this is database...

    you can draw it out it use lucidchart whichever is easier for you. this is database and we are using ERD's THE FINAL ERD Seminar This is the final ERD. We'll discuss the final marks in the videos Seminar IR Integer Seminar Date Date Seminar Time Time Location Address Seminar Title String Customer Email Address String Cust_Last_Name String Attended-- oCust_First_Name String Cust Address Address CustPhone String Do Not Contact Boolean Customer contacted Contact About_Seminar Contact Contact Date Date - Contact...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • First Drawing Assignment: Draw as complete a Class diagram as you can for the following possible...

    First Drawing Assignment: Draw as complete a Class diagram as you can for the following possible application. We wish to BUILD A SOCIAL NETWORKarrow-10x10.png for COMPUTERarrow-10x10.png Science graduate students. This network will allow any graduate student to login and logout. Once logged in, the student may do any of the following: 1. Join a group of fellow students 2. Leave a group of fellow students 3. Create a group which fellow students may join if they wish. Creating a group...

  • Use the case study description and list of requirements below to create an entity-relationship diagram showing...

    Use the case study description and list of requirements below to create an entity-relationship diagram showing the data requirements of the All You Need Are Toys Library database. Your ERD should be able to be implemented in a relational DBMS. Toy libraries operate in a manner similar to book libraries, with members able to borrow a toy for a number of weeks then return it. As with book libraries, toy libraries enable families to have access to a wider range...

  • Please develop an EER Model for the following situation. Your EER diagram must be complete, meaning...

    Please develop an EER Model for the following situation. Your EER diagram must be complete, meaning that all necessary information must be presented. Make appropriate assumptions if necessary and clearly state them. The appropriateness of your assumption will be evaluated. Situation An international school of technology (IST) has hired you to create a database system to assist in its daily operation. After several interviews with the administrators, you have come up with the following list of entities, attributes, and initial...

  • Exercise 4.31 Draw a collaboration diagram for the following booking-to-cash (please draw business process) process. Fotof...

    Exercise 4.31 Draw a collaboration diagram for the following booking-to-cash (please draw business process) process. Fotof provides photography services in the fields of family photography, personal event photography (e.g. weddings and party photography) and commercial photography (e.g., corporate events). One of the core processes of Fotof is its booking-to-cash process, which goes all the way from the moment a customer makes a booking for a photo shooting session, through the order placement, to the moment the customer pays and obtains...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

  • Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to p

    Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results.Figure 7-16: Class scheduling relations (for Problems and Exercises 1-5Figure 7-17 Adult literacy program (for Problems and Exercises 6-14)1. Write SQL retrieval commands for each of the following queries:a....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT