Yioop - PHP Search Engine

-- Oct 23 In-Class Exercise Thread

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

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

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

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

(Edited: 2019-10-23)

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

-- Oct 23 In-Class Exercise Thread

Page4:

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

Page 6

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

Page 7

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

Page8

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

Page4: Stars (Name, address) Stars-in(name, title, year) Studios(name, address) Owns(name, title, year) Movies(title, year, length genre) Page 6 Movies(title, year, length, genre) Stars(name, address) Stars-in(name, title, year, salary, residuals) Page 7 Movies(title, year, length, genre) Murder-Mysteries(weapon, title, year) Cartoon(title, year) Cartoon-MurderMysteries(weapon, title, year) Page8 Movies(title, year, name, length, genre) Studios(cert#, name, address) MoviExecs(cert#, name, address, networth) Presidents (cert#)

-- Oct 23 In-Class Exercise Thread

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

6 Star-in(name,title,year,salary,residuals)
Stars(name,address) Movies(title,year,length,genre)
7
Movies(title, year, length, genre) MurderMysteries(weapon, title, year) CartoonMuderMysteries(weapon, title, year) Cartoon(title, year)
8
Presidents(cert#) Studios(name,address) MovieExces(cert#,name,address,network) Movies(title,year,length,genre,name)

(Edited: 2019-10-27)

'''4 Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-in(name, title, year) 6 Star-in(name,title,year,salary,residuals) Stars(name,address) Movies(title,year,length,genre) 7 Movies(title, year, length, genre) MurderMysteries(weapon, title, year) CartoonMuderMysteries(weapon, title, year) Cartoon(title, year) 8 Presidents(cert#) Studios(name,address) MovieExces(cert#,name,address,network) Movies(title,year,length,genre,name) '''

-- Oct 23 In-Class Exercise Thread

Slide 4: Studios (name, address), Movies (title, year, length, genre), Stars (name, address), Owns (name, title, year), Stars-in (name, title, year),

 ----

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

 ----

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

 ----

Slide 8: Movies (name, title, year, length, genre), Studios (name, address), MovieExecs (cert#, name, address, net worth), Presidents (cert#, name, address, net worth)

Slide 4: Studios (name, address), Movies (title, year, length, genre), Stars (name, address), Owns (name, title, year), Stars-in (name, title, year), ---- Slide 6: Stars (name, address), Movies (title, year, length, genre), Compensation (salary, residuals), Stars-in (name, title, year) ---- Slide 7: Movies (title, year, length, genre), Murder-Mysteries (title, year, weapon), Cartoons (title, year), Cartoon-MurderMysteries (title, year, weapon) ---- Slide 8: Movies (name, title, year, length, genre), Studios (name, address), MovieExecs (cert#, name, address, net worth), Presidents (cert#, name, address, net worth)

-- Oct 23 In-Class Exercise Thread

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) Compensation (salary, residuals) Movies (title, year, length, genre) Stars-In (name, title, year, salary, residuals)

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

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

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) Compensation (salary, residuals) Movies (title, year, length, genre) Stars-In (name, title, year, salary, residuals) page 7 Movies (title, year, length, genre) Murder-Mysteries (title, year, weapon) Cartoons (title, year) Cartoon-MurderMysteries (title, year, weapon) page 8 Movies (title, year, length, genre, name) Studios (name, address, cert#) Presidents (cert#) MovieExecs(cert#, name, address, networth)

-- Oct 23 In-Class Exercise Thread

Slide 4: Studios(name, address)

Movies(title, year, length, genre)

Stars(name, address)

Owns(Studio.name, Movies.title, Movies.year)

Stars-in(Stars.name, Movies.title, Movies.year)

Slide 6: Stars(name, address)

Movies(title, year, length, genre)

Stars-in(Star.name, Movies.title, Movies.year, salary, residuals)

Slide 7: Movies(title, year, length, genre)

Murder-Mysteries( Movies.title, Movies.year, weapon)

Cartoons(Movies.title, Movies.year)

Cartoon-Murder-Mysteries(Movies.title, Movies.year, weapon)

Slide 8: Movies(title, year, length, genre, Studios.name)

Studios(name, address, MovieExecs.cert#)

Presidents(MovieExecs.cert#)

MovieExecs(cert#, name, address, network)

(Edited: 2019-10-28)

* Slide 4: Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(Studio.name, Movies.title, Movies.year) Stars-in(Stars.name, Movies.title, Movies.year) * Slide 6: Stars(name, address) Movies(title, year, length, genre) Stars-in(Star.name, Movies.title, Movies.year, salary, residuals) * Slide 7: Movies(title, year, length, genre) Murder-Mysteries( Movies.title, Movies.year, weapon) Cartoons(Movies.title, Movies.year) Cartoon-Murder-Mysteries(Movies.title, Movies.year, weapon) * Slide 8: Movies(title, year, length, genre, Studios.name) Studios(name, address, MovieExecs.cert#) Presidents(MovieExecs.cert#) MovieExecs(cert#, name, address, network)

-- Oct 23 In-Class Exercise Thread

Page 4 Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-in(name, title, year)

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

Page 7 Movies(title, year, length, genre) Mysteries(title, year, weapon) Cartoons(title, year) MurderMysteries(title, year, weapon)

Page 8 Movies(title, year, length, genre, name) Studios(name, address) Presidents(name, cert_num) MovieExecs(name, address, cert_num, networth)

Page 4 Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-in(name, title, year) Page 6 Movies(title, year, length, genre) Stars(name, address) Stars-in(name, title, year, salary, residuals) Page 7 Movies(title, year, length, genre) Mysteries(title, year, weapon) Cartoons(title, year) MurderMysteries(title, year, weapon) Page 8 Movies(title, year, length, genre, name) Studios(name, address) Presidents(name, cert_num) MovieExecs(name, address, cert_num, networth)

-- Oct 23 In-Class Exercise Thread

Slide 4:

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

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

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

Slide 8 :

Movies(title, year, length, genre, name) Studios(name, address) Presidents(name, cert_num) MovieExecs(name, address, cert_num, networth)

Slide 4: Studios(name, address) Movies(title, year, length, genre) Stars(name, address) Owns(name, title, year) Stars-in(name, title, year) Slide 6 : Movies(title, year, length, genre) Stars(name, address) Stars-in(name, title, year, salary, residuals) Slide 7 : Movies(title, year, length, genre) Mysteries(title, year, weapon) Cartoons(title, year) MurderMysteries(title, year, weapon) Slide 8 : Movies(title, year, length, genre, name) Studios(name, address) Presidents(name, cert_num) MovieExecs(name, address, cert_num, networth)

-- Oct 23 In-Class Exercise Thread

Page 4

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

Page 6

 Stars(name,address)
 Movies(title,year,length,genre)
 Star-in(name,title,year,salary,residuals)
 
 Page 7	
 Movies(title,year,length,genre)
 MurderMysteries(title,year,weapon)
 Cartoons(title,year)
 Cartoon-MurderMysteries(title,year,weapon)

Page 8

 Movies(title,year,length,genre,name)
 Studios(name,address)
 MovieExces(cert#,name,address,network)
 Presidents(cert#)

'''Page 4''' Studios(name,address) Stars(name,address) Movies(title,year,length,genre) Owns(name,title,year) Star-in(name,title,year) ''' Page 6''' Stars(name,address) Movies(title,year,length,genre) Star-in(name,title,year,salary,residuals) ''' Page 7''' Movies(title,year,length,genre) MurderMysteries(title,year,weapon) Cartoons(title,year) Cartoon-MurderMysteries(title,year,weapon) ''' Page 8''' Movies(title,year,length,genre,name) Studios(name,address) MovieExces(cert#,name,address,network) Presidents(cert#)