A+ Work 2023 Business Finance
2023 SportTech Events SportTech Events puts on athletic events for local high school athletes The company needs a database designed
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 in- cludes 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, contact person, and 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 create a normaliza- tion structure in 3NF.
2. Course and Student Schedules Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the depart- ment. In addition, Dick would like the database to include each instructor’s basic contact information, such as ID number, name, office location, and phone number. Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department. For each course, Dick would like to keep track of the course ID, title, and number of credit hours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course. Finally, Dick needs to be able to keep track of the IT students and to know which courses each student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student re- ceives in each course. Dick has asked you to create an ERD from the information described above, and then create a normalization structure in 3NF.
We give our students 100% satisfaction for their assignment, which is one of the most important reasons students prefer us from other helpers. Our professional group and planners have more than ten years of rich experience. The only reason that our inception days, we have helped more than 100000 students with their assignments successfully. Our expert’s group have more than 2200 professionals of different topics, and that not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.
Place Order Now