Yioop - PHP Search Engine

Oct 24 In-Class Exercise.

Hi Everyone,

Post your solutions to the Oct 24 In-Class Exercise to this thread.

Best,

Chris

Hi Everyone, Post your solutions to the Oct 24 In-Class Exercise to this thread. Best, Chris

-- Oct 24 In-Class Exercise

Slide 4
Movies(title, year, length, genre)
Studios(name, address)
Stars(name, address)
Owns(studio_name, movie_title, movie_year)
StarsIn(movie_title, movie_year, star_name)

Slide 6
Movies(title, year, length, genre)
Stars(name, address)
Compensation(movie_title, movie_year, star_name, salary, residuals)

Slide 7
Movies(title, year, length, genre)
Cartoons(title, year)
MurderMysteries(title, year, weapon)
CartoonMurderMysteries(title, year, weapon)

Slide 8
Movies(title, year, length, genre)
Studios(name, address)
Presidents(cert#, studio_name)
MovieExecs(cert#, name, address, networth)

(Edited: 2018-10-24)

Slide 4 Movies(title, year, length, genre) Studios(name, address) Stars(name, address) Owns(studio_name, movie_title, movie_year) StarsIn(movie_title, movie_year, star_name) Slide 6 Movies(title, year, length, genre) Stars(name, address) Compensation(movie_title, movie_year, star_name, salary, residuals) Slide 7 Movies(title, year, length, genre) Cartoons(title, year) MurderMysteries(title, year, weapon) CartoonMurderMysteries(title, year, weapon) Slide 8 Movies(title, year, length, genre) Studios(name, address) Presidents(cert#, studio_name) MovieExecs(cert#, name, address, networth)

-- Oct 24 In-Class Exercise

Student name: Alexander Duong

Page 4

Studios(name, address)

Movies(title, year, length, genre)

Stars(name, address)

Owns(name, title, year)

Stars-in(name, title, year)

Page 6

Stars(name, address)

Movies(title, year, length, genre)

Stars-in(name, title, year, salary, residuals)

Page 7

Movies(title, year, length, genre)

Cartoons(title, year)

Murder-Mysteries(title, year, weapon)

Cartoon-MurderMysteries(title, year, weapon)

Page 8

MovieExecs(cert#, name, address, networth)

Presidents(cert#, studio-name)

Movies(title, year, length, genre, name)

Studios(name, address)

(Edited: 2018-10-24)

Student name: Alexander Duong Page 4 Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-in(name, title, year) Page 6 Stars(name, address) Movies(title, year, length, genre) Stars-in(name, title, year, salary, residuals) Page 7 Movies(title, year, length, genre) Cartoons(title, year) Murder-Mysteries(title, year, weapon) Cartoon-MurderMysteries(title, year, weapon) Page 8 MovieExecs(cert#, name, address, networth) Presidents(cert#, studio-name) Movies(title, year, length, genre, name) Studios(name, address)

-- Oct 24 In-Class Exercise

 4. Studios(name, address) Movies(title, year, length, genre) Stars(name, address), Owns(studioName, movieTitle, movieYear), StarsIn(starName, movieTitle, movieYear)

 6. StarsIn(starName, movieTitle, movieYear, starAddress, movieLength, movieGenre, salary, residuals)

 7. Movies(title, year, length, genre), MurderMysteries(title, year, length, genre, weapon), Cartoons(title, year, length, genre), CartoonMurderMysteries(title, year, length, genre, weapon)

 8. Movies(title, year, length, genre, studioName), Studios(name, address), Presidents(studioName, cert#, name, address, networth), MovieExecs(cert#, name, address, networth)

4. Studios(name, address) Movies(title, year, length, genre) Stars(name, address), Owns(studioName, movieTitle, movieYear), StarsIn(starName, movieTitle, movieYear) 6. StarsIn(starName, movieTitle, movieYear, starAddress, movieLength, movieGenre, salary, residuals) 7. Movies(title, year, length, genre), MurderMysteries(title, year, length, genre, weapon), Cartoons(title, year, length, genre), CartoonMurderMysteries(title, year, length, genre, weapon) 8. Movies(title, year, length, genre, studioName), Studios(name, address), Presidents(studioName, cert#, name, address, networth), MovieExecs(cert#, name, address, networth)

-- Oct 24 In-Class Exercise

student name: Hongbin Zheng

((resource:inclass157a.jpg|Resource Description for inclass157a.jpg)) student name: Hongbin Zheng

-- Oct 24 In-Class Exercise

 Slide 4

 Movies(title	, year, length, genre) 
 Studios(name	, address)
 Stars(name	, address)
 Owns(studio_name, movie_title, movie_year)
 StarsIn(movie_title	, movie_year, star_name)

 Slide 6

 StarsIn(starName	, movieTitle	, movieYear	, salary, residuals)

 Slide 7
 Movies(title	, year	, length, genre) 
 Cartoons(title	, year	)
 MurderMysteries(title	, year	, weapon)
 CartoonMurderMysteries(title	, year	, weapon)

 Slide 8

 Movies(title	, year	, length, genre) 
 Studios(name	, address)
 Presidents(cert#	, studio_name)
 MovieExecs(cert#	, name, address, networth)

(Edited: 2018-10-24)

Slide 4 Movies('''title''', year, length, genre) Studios('''name''', address) Stars('''name''', address) Owns(studio_name, movie_title, movie_year) StarsIn('''movie_title''', movie_year, star_name) Slide 6 StarsIn('''starName''', '''movieTitle''', '''movieYear''', salary, residuals) Slide 7 Movies('''title''', '''year''', length, genre) Cartoons('''title''', '''year''') MurderMysteries('''title''', '''year''', weapon) CartoonMurderMysteries('''title''', '''year''', weapon) Slide 8 Movies('''title''', '''year''', length, genre) Studios('''name''', address) Presidents('''cert#''', studio_name) MovieExecs('''cert#''', name, address, networth)

-- Oct 24 In-Class Exercise

 pg 4 
 Movies(title, year, length, genre) 
 Studios(name, address)
 Stars(name, address)
 Owns(studio_name, movie_title, movie_year)
 StarsIn(movie_title, movie_year, star_name)

 pg 6
 Stars(name, address) 
 Movies(title, year, length, genre)
 Stars-in(name, title, year, salary, residuals)

 pg 7
 Movies(title, year, length, genre)
 Cartoons(title, year)
 Murder-Mysteries(title, year, weapon)
 Cartoon-MurderMysteries(title, year, weapon)

 pg 8
 MovieExecs (cert#, name, address, worth) 
 Presidents(cert#, studio_name)
 Studio(name, address)
 Movies(title, year, genre, length, studio_name)

(Edited: 2018-10-24)

pg 4 Movies(title, year, length, genre) Studios(name, address) Stars(name, address) Owns(studio_name, movie_title, movie_year) StarsIn(movie_title, movie_year, star_name) pg 6 Stars(name, address) Movies(title, year, length, genre) Stars-in(name, title, year, salary, residuals) pg 7 Movies(title, year, length, genre) Cartoons(title, year) Murder-Mysteries(title, year, weapon) Cartoon-MurderMysteries(title, year, weapon) pg 8 MovieExecs (cert#, name, address, worth) Presidents(cert#, studio_name) Studio(name, address) Movies(title, year, genre, length, studio_name)

-- Oct 24 In-Class Exercise

 Slide 4
 Studios(name, address)
 Stars(name, address)
 Movies(title, year, length, genre)
 Owns(studio_name, movie_title, movie_year)
 Stars-In(star_name, movie_title, movie_year)

 Slide 6
 Stars(name, address)
 Movies(title, year, length, genre)
 Stars-In(name, title, year, salary, residuals)
 
 Slide 7
 Movies(title, year, length, genre)
 Murder-Mysteries(title, year, weapon)
 Cartoons(title, year)
 Cartoon-MurderMysteries(title, year, weapon)
 
 Slide 8
 Movies(title, year, length, genre)
 Studios(name, address)
 MovieExecs(cert#, name, address, networth)
 Presidents(cert#, studio_name)

(Edited: 2018-10-24)

Slide 4 Studios(name, address) Stars(name, address) Movies(title, year, length, genre) Owns(studio_name, movie_title, movie_year) Stars-In(star_name, movie_title, movie_year) Slide 6 Stars(name, address) Movies(title, year, length, genre) Stars-In(name, title, year, salary, residuals) Slide 7 Movies(title, year, length, genre) Murder-Mysteries(title, year, weapon) Cartoons(title, year) Cartoon-MurderMysteries(title, year, weapon) Slide 8 Movies(title, year, length, genre) Studios(name, address) MovieExecs(cert#, name, address, networth) Presidents(cert#, studio_name)

-- Oct 24 In-Class Exercise

Done in text editor, so primary keys were written after the relational schema Slide 4: Movies(title, year, length, genre) PK: title and year Studios(name, address) PK: name Stars(name, address) PK: name Owns(studio_name, movie_title, movie_year) StarsIn(movie_title, movie_year, star_name)

Slide 6: Movies(title, year, length, genre) PK: title and year Stars(name, address) PK: name Compensation(movie_title, movie_year, star_name, salary, residuals)

Slide 7: Movies(title, year, length, genre) PK: title and year Cartoons(title, year) PK: title and year MurderMysteries(title, year, weapon) PK: title and year CartoonMurderMysteries(title, year, weapon) PK: title and year

Slide 8: Movies(title, year, length, genre) PK: title and year Studios(name, address) PK: name Presidents(cert#, studio_name) PK: cert# MovieExecs(cert#, name, address, networth) PK: cert#

Done in text editor, so primary keys were written after the relational schema Slide 4: Movies(title, year, length, genre) PK: title and year Studios(name, address) PK: name Stars(name, address) PK: name Owns(studio_name, movie_title, movie_year) StarsIn(movie_title, movie_year, star_name) Slide 6: Movies(title, year, length, genre) PK: title and year Stars(name, address) PK: name Compensation(movie_title, movie_year, star_name, salary, residuals) Slide 7: Movies(title, year, length, genre) PK: title and year Cartoons(title, year) PK: title and year MurderMysteries(title, year, weapon) PK: title and year CartoonMurderMysteries(title, year, weapon) PK: title and year Slide 8: Movies(title, year, length, genre) PK: title and year Studios(name, address) PK: name Presidents(cert#, studio_name) PK: cert# MovieExecs(cert#, name, address, networth) PK: cert#

-- Oct 24 In-Class Exercise

4.

 Studios(name, address)
 Movies(title, year, length, genre)
 Stars(name, address)
 Owns(name, title, year)
 Stars-In(name, title, year)

6.

 Stars(name, address)
 Movie(title, year, length, genre)
 Stars-In(name, title, year, salary, residuals)

7.

 Cartoons(title, year)
 Murder-Mysteries(title, year, weapon)
 Cartoon-MurderMysteries(title, year, weapon)

8.

 Movies(title, year, length, genre, name)

name is a foreign key from Studios

 Studios(name, address)
 Presidents(cert#, studioName)
 MovieExecs(cert#, name, address, networth)

4. Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-In(name, title, year) 6. Stars(name, address) Movie(title, year, length, genre) Stars-In(name, title, year, salary, residuals) 7. Cartoons(title, year) Murder-Mysteries(title, year, weapon) Cartoon-MurderMysteries(title, year, weapon) 8. Movies(title, year, length, genre, name) name is a foreign key from Studios Studios(name, address) Presidents(cert#, studioName) MovieExecs(cert#, name, address, networth)