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

Attribute, a set of possible data value of an attribute is called??

a set of possible data value of an attribute is called??

Process of implementing system design in dynamic models, Process of impleme...

Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:

What are the authentication modes in sql server, What are the authenticatio...

What are the authentication modes in SQL Server? How can it be changed? Windows mode and Mixed Mode - SQL and Windows. To alter authentication mode in SQL Server click Start, P

List the reg-no of vehicles owned in relational algebra, Given the followin...

Given the following relations Vehicle (Reg_no, make, colour) Person(eno, name, address) Owner(eno, reg_no) Write expressions in the relational algebra to answer the following

Having clause-data manipulation language, Having clause This clause...

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Customer service, as a customer service employee, explain five measures you...

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

Answer, what is database management system? & why it is required?

what is database management system? & why it is required?

Define what Immediate database modification technique uses, Define what Imm...

Define what Immediate database modification technique uses?  Ans: Both undo and redo.

4, explain the level architectures of the database management system

explain the level architectures of the database management system

Describe the two alternatives for specifying structural, Describe the two a...

Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o

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