1. Databases surround us on the web and everyday life. Now that you have a clearer
idea of what database systems do, find two examples of web sites that you believe
are likely to use databases and discuss what kinds of data they might be storing, as
in the example answer.

1. Facebook.com uses database to store all of its users and their information. They have databases for users, quotes, pictures, links, almost anything you can think of, it is possible that Facebook.com utilizes it.
   Also, GeekBrief.TV uses databases to store their daily podcast and show it in a chronological display.

2. Identify relationships. Suppose you are creating a database to help a university
keep track of its course offerings. You might have the following entities in your
database, since they are distinct items in real life that are related to each other in
important ways: course, classroom, professor, and department. In the space
below, draw an ER diagram with a box for each of these four entities and arrows
between the boxes labeled with the relationships they denote. (Don’t worry about
what fields each of these entities should have for now.) See the example ER
diagram in your textbook and in Part 1 of this lab.

2. course (*) ---> classroom (*)---> professor(*) <--- (1)department
	* many to one
	1 one to one

3. Identify many-to-one relationships. For each of the relationships you diagrammed
above, which ones are many-to-one? Which ones are many-to-many? Indicate
the relationships by writing 1 or 8 at each end of the relationship arrows. If you
are not sure about whether a relationship is one-to-many or many-to-many,
explain why.

3. course ---> classroom - one to many because there are many courses taught in one classroom
   classroom ---> professor - one to many because a prefessor can teach more than one class
   department ---> professor - one to many because there are many professors in one department

4. Identify entities. Suppose you are creating a database to keep track of a radio
station’s record collection. What are some of the entities your database might
include?

4. Entities are distinct items in real life that are related to each other in important ways. song, dj, station, city, state, country

5. Query results and tables look very similar—like a set of tuples. How are query
results and tables different, however?

5. In tables all of the information is stored in tuples; however queries do not hold data themselves but are ways of building new tables
out of the existing tables.

6. Queries

(1) Which movies were released before 1980, ordered by year of release?
	The Wrong Man 		1956
	Psycho			1960
	The Bad Sleep Well	1960
	High and Low		1963
	Dersu Uzala		1974
	Jaws			1975

(2) When were each of the Psycho movies released?
	1960
	1998

(3) Which movies have titles that start with the letter R?
	Ran (Chaos)
	Red

(4) Which directors have last names that start with the letter S?
	John Sayles
	Steven Soderbergh
	Steven Spielberg

(5) Which movies were directed by directors who were born after 1955?
	Traffic
	Cinema Paradiso
	The Legend of 1900
	The Children of Heaven
	The Color of Paradise