Lab 3.2 Post-lab Questions


1.)	I belive Ebay is a good example of a database, storing and providing information on many different products
	and services that diffent people/businesses are providing to consumers.

	Another example would be pubmed.com, which is a database that stores different researchers publications and
	there respective research.  It can provide links to different studies, experiments, references, etc.


2.)	Department--->(A department will contain professors specific to that department)--->Professor--->
	(Each professor will teach only a set few courses)--->Course--->(Each course may have different
	sections that may occur in different classrooms)--->Classroom


3.)	I belive the department to professor relationship would be many to one.  There would be many professors
	in any one specific department.  Also, the professor to course relationship would be many to many,
	because many professors may teach a course or one professor may teach many courses.  The course to classroom
	relationship should be many to one, due to the fact that a course may have multiple sections in different
	classrooms, but more than one classrooms would not problably be used for one course.  This last relationship
	is a bit fuzzy and could be more explicit with the addition of additional relationship criteria such as
	section or time.

	Department(1)--->(A department will contain professors specific to that department)--->(Many)Professor(Many)
	--->(Each professor will teach only a set few courses)--->(Many)Course(1)--->(Each course may have different
	sections that may occur in different classrooms)--->(Many)Classroom
	
	
4.)	Genre of music--->Artists within that genre--->Songs of the individual artist--->Most popular song played
	--->etc.
	
	
5.)	Query results are from a database that gives information on a specific query imput into the database and
	displayed in a certain order as requested.  It is not static, but rather dynamic due to the fact that a
	user may go back to the database and enter a new query or order the existing query differently in order
	to suit their needs.  A table, on the other hand, is static information that is made for one purpose, and
	cannot be actively changed to suit a user's needs.  While useful for certain tasks, tables are less
	capable than query results overall.


Part 5. Submission Checklist


1.)	Movies released before 1980: (ordered by release date)
	The Wrong Man 1956
	Psycho 1960
	The Bad Sleep Well 1960
	High and Low 1963
	Dersu Uzala 1974
	Jaws 1975

2.)	Psycho movie release dates:
	1960
	1998

3.)	Movies with title starting with R:
	Ran (Chaos)
	Red

4.)	Directors with last names starting with S:
	Sayles
	Soderbergh
	Spielberg

5.)	Movies directed by directors born after 1955
	The Color of Paradise (Majidi)
	The Children of Heaven (Majidi)
	Traffic (Soderbergh)
	The Legend of 1900 (Tornatore)
	Cinema Paradiso (Tornatore)