E-R Diagram, Database Management System

Assignment Help:
The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keeps track of each graduate’s student number, name when a student, country of birth, current country of citizenship, current name, current address, and the name of each major the student completed (each student has up to two majors). To maintain strong ties to its alumni, the school holds various events around the world. Events have a title, date, location, and type (eg, reception, dinner, or seminar). The school needs to keep track of which graduates have attended which events. When an alumni attends an event, notes are recorded about information school officials learned from that graduate at that event.

The school also keeps in contact with graduates by mail, email, telephone, and fax interactions. As with events, the school records each time an alum is contacted as well as information learned from the graduate from each of these communications. When a school official knows that he or she will be meeting or talking to a graduate, a report is produced showing the latest information about that graduate including the information learned during the past two years from all communications with the graduate, and events the graduate attended. Design the ERD for this business school.


Related Discussions:- E-R Diagram

Database incident table, The Incident table, with an auto-incrementing in...

The Incident table, with an auto-incrementing incident number, etc, looks like: incident_num reporter date time incide

Oracle, how oracle can be used

how oracle can be used

Why a report generator is used, Why a report generator is used ? Report...

Why a report generator is used ? Report generator is used for print files on paper.

Define tables students and teachers as sub tables of people, Write a query ...

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people

Define the immediate update, Define the Immediate Update The immediate...

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

Private Tuition, Hi, Do you offer private tuition for DBMS?

Hi, Do you offer private tuition for DBMS?

Explain mechanism of nested queries, Explain mechanism of nested queries? ...

Explain mechanism of nested queries? SQL gives a mechanism for nesting subqueries. A subquery is a select from where expression that is nested within one more query. A common u

What are uncommitted modifications, What are uncommitted modifications? ...

What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd