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

Transaction managenment, can you please explain with the help of suitable e...

can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Graphical user interface tools, These are interactive interfaces, graphical...

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Modular growth, Modular growth: In distributed environments, it is simple t...

Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat

Query to delete constraint from alter table, A constraint named less_than_2...

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Need database normalization and database analysis, Developer is required to...

Developer is required to do a task including: - Database Normalization - Database Analysis - ERM Diagram Details can be provided and then you can change your bid accord

In e-r diagram how relationship type is represented, In E-R Diagram how rel...

In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Stock market, need requirement analysis for database management of stock ma...

need requirement analysis for database management of stock market

Explain the terms data warehousing and data mining, Question: i) Explai...

Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n

Data warehouse, 1) Define a job scheduling strategy that will meet business...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

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