【edited】 Constraints on database -


i have following table called students. if want put constraint -- each state, there no more 2 students can come same state, how express such constraint in relational algebra?

   name   |  hometown      |  gender  -----------------------------------    bob    |  nyc           |  male    alice  |  washington d.c|  female    linda  |  london        |  female    peter  |  miami         |  male    amy    |  philadelphia  |  female    lucy   |  nyc           |  female    james  |  albany        |  male    jason  |  los angeles   |  male    cindy  |  salt lake city|  female    jackson|  princeton     |  male    judy   |  seattle       |  female    marcia |  san francisco |  female    steve  |  nyc           |  male    john   |  miami         |  male

you're going need relation providing state each town. join table (on town) , give state. group result state , count occurrences, constraining count less or equal two. haven't provided required relation or relation names, can't give algebra, should find helps homework done.


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more