Unformatted text preview: MP#1 Name: Zhiyuan Tan NetID: ztan7 section: AYS TA: Sangkyum Kim Part I 1. /* This result set includes the opponent and their score that not greater than 72 */ Opponent OppScore Maryland 72 Missouri 70 Xavier 65 Michigan 71 Iowa 70 Wisconsin 71 2. /* This result set includes the opponent and attendance of teams that the number of people who came to see the game between 11000 and 15000, the results are ordered by the number of attendance */ Opponent Attendance Michigan 11023 Xavier 13256 3. /* This result set includes the points Illini scored that the opponent's name contain 2 "i"s in the word */ ILScore 73 61 64 4. /* This result set includes all the column in the table that the game illini lose, the results are ordered by the name of opponent name */ Opponent Attendance ILScore OppScore Arizona 15507 72 84 Maryland 16618 66 72 Michigan 11023 61 71 Wisconsin 16614 64 71 Xavier 13256 59 65 5. /* This result set includes opponent's name that either illini win the game or the number of people who came to see the game is greater than 16000, the results are ordered by opponent's name in descending order */ Oppinent Wisconsin Missouri Maryland Iowa Arizona Part III 1. /* This result set includes Tom Cruise's birthday */ select Dateofbirth from Actors where lastname="Cruise" and firstname = "Tom" 2. /* This result set includes all the actors' information sorting in descending order of their date of birth */ select * from Actors order by dateofbirth desc 3. /* This result set includes titles, language, and rating of Movies that their language is English or French, the rusults are oredered by rating */ select title, language, rating from Movies where language = "English" or language = "French" order by rating 4. /* This result set includeslastnames, firstnames and birthdaysof actors whose lastname begin with "C" or "T" */ select lastname, firstname, dateofbirth from Actors where lastname like "C%" or lastname like "T%" 5. /* This result set includes lastnames, firstnames and birthdays of actors whose lastname begin with "C" or "T", the results are ordered by lastname first, and then sort in order of firstname */ select lastname, firstname, dateofbirths from Actors where lastname like "C%" or lastname like "T%" order by lastname, firstname Part IV 1. English character is represented by a series of 1s and 0s in computer. And ASCII codes are used to represent character data. Computers not "understand" English, they only understand 1 and 0. With ASCII codes or other codes like Unicode, they can translate 1s and 0s into character data. 2. A database is a collection of data stored in some organized fashion. A table is a structured file that can store data of a specific type. So database is a kind of data and table is a structured file used to store these data. Imagine a database as a filing cabinet. When you store information in your filing cabinet you don't just toss it in a drawer.Rather,you creat files within the filing cabinet, and then you file related data in specific files. That file is called a table. My major is finance. A typical example database can be the information of all the stocks. It may has tables like "company", which contains the information about these stocks' company, "price", which contains the prices of different stocks, "analysis", which contains the different aspects of analysis about these stocks. ...
View Full Document
- Fall '08
- Computer file, Prime number, ASCII, Illini, Xavier 13256