Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 1 Day Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Computer Science Posted 25 Apr 2017 My Price 3.00

Write the following referential integrity

 

Write the following referential integrity constraints for the battleships database as in Exercise 7.1.4. Use your assumptions about keys from that exercise, and handle all violations by setting the referencing attribute value to NULL.

 a) Every class mentioned in Ships must be mentioned in C lasses.

b) Every battle mentioned in Outcomes must be mentioned in Battles.

c) Every ship mentioned in Outcomes must be mentioned in Ships.

 

 

 
 

Answers

Alpha Geek
(8)
Status NEW Posted 25 Apr 2017 08:04 AM My Price 3.00

-----------

Attachments

file 1493108528-Answer.docx preview (149 words )
W-----------rit-----------e t-----------he -----------fol-----------low-----------ing----------- re-----------fer-----------ent-----------ial----------- in-----------teg-----------rit-----------y c-----------ons-----------tra-----------int-----------s f-----------or -----------the----------- ba-----------ttl-----------esh-----------ips----------- da-----------tab-----------ase----------- as----------- in----------- Ex-----------erc-----------ise----------- 7.-----------1.4-----------. U-----------se -----------you-----------r a-----------ssu-----------mpt-----------ion-----------s a-----------bou-----------t k-----------eys----------- fr-----------om -----------tha-----------t e-----------xer-----------cis-----------e, -----------and----------- ha-----------ndl-----------e a-----------ll -----------vio-----------lat-----------ion-----------s b-----------y s-----------ett-----------ing----------- th-----------e r-----------efe-----------ren-----------cin-----------g a-----------ttr-----------ibu-----------te -----------val-----------ue -----------to -----------NUL-----------L. -----------  -----------a) -----------Eve-----------ry -----------cla-----------ss -----------men-----------tio-----------ned----------- in----------- Sh-----------ips----------- mu-----------st -----------be -----------men-----------tio-----------ned----------- in----------- C -----------las-----------ses-----------. -----------b) -----------Eve-----------ry -----------bat-----------tle----------- me-----------nti-----------one-----------d i-----------n O-----------utc-----------ome-----------s m-----------ust----------- be----------- me-----------nti-----------one-----------d i-----------n B-----------att-----------les-----------. -----------c) -----------Eve-----------ry -----------shi-----------p m-----------ent-----------ion-----------ed -----------in -----------Out-----------com-----------es -----------mus-----------t b-----------e m-----------ent-----------ion-----------ed -----------in
Not Rated(0)