Instructor: Ashish Goel
Handout 11: Homework 4. Given 12/02/05. Due 12/09/05.
Collaboration Policy: You are
allowed to discuss general strategies for solving a problem with other students
in the class, and also to clarify your understanding of the problem. You are
not allowed to copy or see somebody else’s homework.
This is a shorter homework, so
it is worth only 40 points.
- [0 pts] Read handout 10. Download and install the MySQL Query
browser. Use the MySQl browser to connect to kauveri.Stanford.edu using
the name and the password we gave out in class. You will now be logged on to the database server. You
can use “show databases;” to see the available databases. Then do “use
msande130;”. This database has three tables. Do “show tables;” to list the
tables. Do “describe MovieStar;” etc. to see a description of these
tables. You are now all set for the next two exercises.
- Write a query to list all the studios that ‘Arnold’ has worked
for. Export the result as an html file, and submit a printout of this
file. The studioNames should not be repeated.
- Write a query to list the name and the address of every actor
who has worked for Universal.
Export the result as an html file, and submit a printout of this
file. Again, there should be no duplicate records.
- [0 ps] Do ‘use DATABASE_FOR_X’ where X is your login name. You
are now ready for the next exercise.
- Create two tables of your own choosing which capture some
meaningful relationship. Populate them with at least 5-10 records each.
Run “select *” queries for each of the two tables. Write some meaningful
query that involves both tables.
Export the results of each of the three queries into html files and
submit a printout of the three html files. Please do not delete the tables
that you create.
- Write a short predictive essay (less than 300 words) on the
future of Internet advertising.
Please
do not forget to write down your login name on your homework