/
/




Daily XP
3191
Exercise
Exercise
Referential integrity violations
Given the current state of your database, what happens if you execute the following SQL statement?

DELETE FROM universities WHERE id = 'EPF';
Instructions
50 XP
Possible answers


It throws an error because the university with ID "EPF" does not exist.

The university with ID "EPF" is deleted.

It fails because referential integrity from universities to professors is violated.

It fails because referential integrity from professors to universities is violated.

Take Hint (-15 XP)
query.sql
1
query result
universities
professors
affiliations
organizations
id	organization_sector
2014 IARU Congress, Copenhagen, Denmark	Education & research
42matters AG	Technology
A*Star IMB Biopolis, Singapour	Education & research
A*star Singapore, Inst. High Performance Computing	Education & research
A. Peneveyre SA	Industry, construction & agriculture
ACP Advanced Circuit Pursuit AG, Zürich	Industry, construction & agriculture
ADREAM, Crans-Montana, Switzerland	Education & research
AERES, Paris	Education & research
AFF Architekten, Berlin, Germany	Industry, construction & agriculture
AICOS Technologies AG, Bâle	Technology
AIP Publishing Center, Melville, NY, USA	Media & communication
AISBL (non-profit Association)	Not classifiable
AISTS, EPFL-Innovation Park, Lausanne	Education & research
ALID AG	Financial industry & insurances
ALSTOM Inspection Robotics AG	Industry, construction & agriculture
AMYRIS, California, USA	Technology
ANF SA, Lausanne	Financial industry & insurances
ANR, Paris	Education & research
ANTIA Therapeutics, Bern	Pharma & health
ARDEX GmbH	Industry, construction & agriculture
ARE, Office fédéral du développement territorial, Berne	Energy, environment & mobility
ASG Strategy Group AG	Consulting, public relations, legal & trust
ATG Advanced Technology Group GmbH	Consulting, public relations, legal & trust
AYU Association (no longer active)	Not classifiable
AZAD Pharmaceutical Ingredients AG	Pharma & health
Abionic, Innovation Park	Pharma & health
AbsolventUM	Education & research
Academy of Management	Education & research
Académie internationale des sciences et technique du sport	Education & research
Académie suisse de la magistrature	Education & research
Académie suisse des sciences humaines et sociales	Society, Social, Culture & Sports
Activités académiques	Education & research
Acutronic Schweiz AG	Industry, construction & agriculture
Adolphe Merkle Institute, Université de Fribourg	Education & research
Advanced Silicon SA, Lausanne	Industry, construction & agriculture
Advances in Water Resources (Elsevier Journal)	Media & communication
Advisory Board Novartis Venture Fund	Financial industry & insurances
Advokatenkammer Basel-Stadt	Politics, administration, justice system & security sector
Aeon Scientific AG	Pharma & health
Aeroport Genève	Energy, environment & mobility
African Institute for Mathematical Science, Cape Town, South Africa	Education & research
Agence Nationale de la Recherche (ANR), Paris	Education & research
Airbus EADS, France	Energy, environment & mobility
Airport Casino Basel 	Commerce, trade & services
Akkreditierungsagentur FIBAA	Politics, administration, justice system & security sector
Albert Lück-Stiftung	Education & research
Albert-Heim-Stiftung	Society, Social, Culture & Sports
Albert-Ludwigs-University	Education & research
Albrecht-von-Haller-Stiftung der Burgergemeinde Bern	Education & research
Alcoa Howmet, Whitehall, USA	Industry, construction & agriculture
Alexander von Humboldt Institut für Internet & Society	Education & research
Alexander von Humboldt Stiftung	Education & research
Algofin AG	Consulting, public relations, legal & trust
Alpes Lasers S.A.	Industry, construction & agriculture
Alterniity GmbH	Technology
Amazentis	Technology
Amazentis, Ecublens	Technology
Amazentis, Ecublens, Switzerland	Technology
America Software Lab, Santa Clara, CA	Technology
American Chemical Society	Technology
American Chemical Society, USA	Education & research
American Chemical Society, Washington, USA	Education & research
American Institute of Phyiscs Publishing (AIPP), NY, USA	Media & communication
Amherst - USA	Not classifiable
Ammann BauAusrüstung AG	Commerce, trade & services
Ammarkt	Consulting, public relations, legal & trust
Amphiro AG	Industry, construction & agriculture
Anadec GmbH	Consulting, public relations, legal & trust
André und Hedy Knoll-Spring Stiftung	Education & research
Anokion SA, Lausanne	Pharma & health
Anokion, Ecublens, CH	Pharma & health
Antidoping Suisse, Berne	Pharma & health
Antlia SA, Lausanne	Pharma & health
Appellationsgericht des Kantons Basel-Stadt	Politics, administration, justice system & security sector
Appenzeller Kantonalbank	Financial industry & insurances
AquaDiva, Fredrich-Schiller-Universität Jena, Germany	Education & research
Archiv der Mathematik	Media & communication
Argo Innovations, Atlanta	Consulting, public relations, legal & trust
Asgalium Unitec SA, Cortaillod	Industry, construction & agriculture
Asian. J. Org. Chem. Wiley	Media & communication
Association ARMINES, Paris, France	Education & research
Association Amies et Amis de la Fondation EPFL-WISH	Education & research
Association Climate-KIC	Energy, environment & mobility
Association Ecoparc, Neuchâtel	Energy, environment & mobility
Association pour l'histoire des chemins de fer en France	Society, Social, Culture & Sports
Association pour le Concours International de Chronométrie, Le Locle	Industry, construction & agriculture
Association suisse du droit public de l'organisation (ASDPO)	Politics, administration, justice system & security sector
Atelier International du Grand Paris, Paris	Society, Social, Culture & Sports
Athemis	Consulting, public relations, legal & trust
AtlanticLux Lebensversicherung S.A.	Financial industry & insurances
Atlas Photonics Sàrl	Technology
CUREM	Education & research
Autorité fédérale de surveillance en matière de révision	Commerce, trade & services
Avatarion Technology	Technology
Avenir Suisse	Society, Social, Culture & Sports
BAK, Heimatschutz und Denkmalpflege, Bern	Society, Social, Culture & Sports
BASF Societas Europeae (Schweden)	Technology
BCA, Singapore	Not classifiable
BEG & Partners	Consulting, public relations, legal & trust
BEG & Partners AG	Consulting, public relations, legal & trust
Showing 100 out of 1287 rows