Big Dog

Project 2 questions

We have two quick questions about the project requirements. The first one is about the comments that are to be included in the stylesheets and XSQL pages. How in depth do you want them to be? We just made little comments where we edited the stylesheets made by the professor with our own information. Is this sufficient or is more explanation needed? Second, we were wondering where the lsttab report is? Is it in a directory or is it a command that we have to run on Oracle to generate our list of views and tables? We were just wondering about these little issues. Any help would be nice.

Project 2

I think the second have of our project is coming along nicely. We have yet to tackle the dynamic aspects of the projects which will most likely be the most diffiuclt part of the project but we have a good handle on our views and the forms we want to use. I was just wondering if when you implement your views into HTML is there a way to put a title above the table. For example one of our views from our project selects certain Diet Restrictions of Dance Marathon dancers. I was wondering if you could make a title to indicate that because the column titles in the table aren't very describtive. Just something that I was wondering about while working on project two.

Success at Last

Link: maulin: Stage 2 on Project 2 COMPLETE!!!!.

It took awhile, but I finally managed to figure out how to covert the XML documents that contained the views we created for our project into HTML format on the web. Now all our views are on the web. It was a little tricky at first and I sort of stumpled across the correct way to do it while looking back at the slides from the previous classes. After that it was pretty easy to convert the rest. The big key though as Maulin pointed out is having the root.xsl file in the directory that contains your xsql files. I tried to move the root into another file and HTML didn't work. My best advice is to mess around with it for awhile if you have time and look back on the notes from class. Also working through this also helped me better understand the connection between all the types of documents and what needs to be where to make this happen and that sort of thing. Good Luck with your Projects

Project XSQL

I attempted to convert SQL views from our project into XSQL pages. Believe it or not, I was successful on my first five attempts at converting our views. However, I came across some troubles when it came to a few of our queries. I think the source of the problem has to do with making the XSQL page well-formed. In two of our queries we have the not equal to symbol (<>). I remember somewhere hearing or reading that the processes views the < sign as the beginning of a new element or something. There has to be a way to represent <> without using the < sign. If anybody knows the code please blog back. Other than that my XSQL pages worked fine. However, I was a little curious with the id-attribute part of the XSQL page. What is the purpose of the id-attribute function? I had no idea so I left it blank in all the queries I did.   

recursive realtionship

In our ER diagram we have a recursive realtionship with our dancer table. A dancer can be requested by another dancer and a dancer can request another dancer. The problem we are running into is basically we need the emails from both the requester and the requested thus we have two column headings that are the same (dancer email). How would we reference that to the dancer table in our foreign key contraints. Can dancer email be used twice in the composite foreign key or is there something else we can do.

Project clarifications

Just to Clarify: When you say that the database has to have 5 views that just refers to to 5 differert queries just saved as views right? Also what do you mean by drop all tables and views, is that just sql commands for deleting the tables? I just want to make sure I got everything right

Entity Subtypes

If you divided up an entity type into two subtypes and you wanted to normailze the tables would you include the primary key of both subtype tables as foreign keys or part of the primary key in the original entity table?

The Project Begins

I'm looking forward to starting the project finally. ER Diagrams and normalization are fine, but now we finally get do use them in a context that can be fun and interesting while providing experience and growth dealing with database development and management. I work with databases and spreadsheets everyday through my job, but this project will allow me to experiment freely and try some new applications and ideas. This should be a fun project and I hope everyone in my team is looking forward to starting.

Project #1

I was just wondering if we were going to go over the project requirements and expectations in class because I have a few questions