tranquilidad

Nice Job, everyone

My apologies for the delayed observations, but I just wanted to say that I really enjoyed seeing the culmination of a semester's worth of BIT320 via Thursday's presentations.  The great thing about this class is that we actually get to apply what we are learning to create tangible value for another organization and I must say, it was really exciting to see how everyone chose to do this utilizing the same toolset, but creating different outcomes and interfaces.  There seemed to be a high level of accomplishment from all of the groups, both functionally and stylistically.  Hopefully, everyone got some good ideas from other presentations as we polish up our finalized project.  Best of luck this week!

Comments?

The project 2 requirements description says we need to comment for our XSQL pages and XSLT stylesheets, but based on Bud's response  to  Smiling Chen's post, it doesnt sound like we need to worry about it at all.  I just want to make sure that I am correct in this interpretation.  Thanks!

Oracle Issues

Working through our project these past couple of weeks, our group has had problems working on our database simultaneously. We were under the impression that one of the main benefits of using Oracle was that multiple users could utilize the database and make changes at the same time. Yet for some reason, several times while all of us are logged on, one of us will try to run a query and will get the response "no rows selected" yet the other person can run the query and get results just fine. Just an observation...Have other groups had similar problems?

Multi-table query

Hard at work on our database project as evidenced by our group photo kindly submitted by Big Blog in the Sky, I am having trouble getting this three-table query to work correctly. The question we are trying to ask is "What services has the club provided to the AALC and what are the associated deliverables and resources?" Deliverables, resources, and project service all come from different tables and I have basically divided the query into three parts. Contained in each part is a nested query and each nested query displays the correct results when run separately. Any suggestions on how to get them to work simultaneously? The AND operator seems to be causing some problems.

Here is a copy of the query:

SELECT proj_concentration.service, proj_resources.r_filename, deliverables.d_filename
FROM proj_concentration, proj_resources, deliverables
WHERE proj_concentration.service IN
(SELECT DISTINCT proj_concentration.service
FROM proj_concentration
WHERE proj_concentration.org_ID = 'AALC')

AND WHERE proj_resources.r_filename IN (SELECT DISTINCT proj_resources.r_filename
FROM proj_resources, proj_services, proj_concentration
WHERE proj_resources.service = proj_services.service
AND proj_concentration.service=proj_services.service
AND proj_concentration.org_ID='AALC')

AND WHERE deliverables.d_filename IN
(SELECT DISTINCT deliverables.d_filename from deliverables
WHERE deliverables.org_ID IN
(SELECT org_ID from project WHERE Org_ID = 'AALC'));

Thanks for the help!

test

test