Yioop - PHP Search Engine

-- Oct 23 In-Class Exercise Thread

Page 4

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

Page 6

 Stars(name, address)
 Movies(title, year, length, genre)
 Compensation(salary, residuals)
 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, name, length, genre)
 Studios(name, address>)
 Presidents(name)
 Moviexecs(cert#, name, address, networth)

(Edited: 2019-10-23)

Page 4 Studios(name, address) Owns(name, title, year) Stars(name, address) Stars-in(name, title, year) Page 6 Stars(name, address) Movies(title, year, length, genre) Compensation(salary, residuals) 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, name, length, genre) Studios(name, address>) Presidents(name) Moviexecs(cert#, name, address, 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#)

-- Oct 23 In-Class Exercise Thread

4.)

 Studios(name, address)

 Owns(name, title, year)

 Movies(title, year, length, genre)

 Stars-in(name, title, year)

 Stars(name, address)

6.)

 Stars(name, address)

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

 Movies(title, year, length, genre)

7.)

 Movies(title, year, length, genre)

 Mur-der-Mysteries(weapon, title, year)

 Cartoon(title, year)

 Cartoon-MurderMysteries(weapon, title, year)

8.)

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

 Studios(cert#, name, address)

 MovieExecs(cert#, name, address, networth)

 Presidents(cert#)

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

-- Oct 23 In-Class Exercise Thread

4.) Studios(name PK, address)

 Starts(name PK, address)
 Owns(Studio.name, Movie.title, Movie.year)
 Stars-in(Starts.name, Movie.title, Movie.year)

Slide 6

 Stars (name PK, address)
 Movies (title PK, year PK, length, genre)
 Stars-in (Stars.name, Movie.title, Movie.year, salary, resisual)

7.) Movies(title, year, length, genre)

 MurderMysteries(weapon, title, year)
 Cartoon(title, year)
 CartoonMurderMysteries(weapon, title, year)

8.)

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

4.) Studios(name PK, address) Starts(name PK, address) Owns(Studio.name, Movie.title, Movie.year) Stars-in(Starts.name, Movie.title, Movie.year) Slide 6 Stars (name PK, address) Movies (title PK, year PK, length, genre) Stars-in (Stars.name, Movie.title, Movie.year, salary, resisual) 7.) Movies(title, year, length, genre) MurderMysteries(weapon, title, year) Cartoon(title, year) CartoonMurderMysteries(weapon, title, year) 8.) Movies(title, year, length, genre) Studios(title, year, cert#, name, address) MovieExecs(cert#, name, address, networth) Presidents(cert#)

-- Oct 23 In-Class Exercise Thread

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

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

-- Oct 23 In-Class Exercise Thread

Slide 4:

Studios(name,address)

Stars(name,address)

Movies(title, year, length, genre)

Owns(names, title, year)

Stars-in(names, title, 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:

MovieExecs (cert#, name, address, networth)

Presidents (cert#, name)

Studios (name, address)

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

(Edited: 2019-11-12)

Slide 4: Studios(name,address) Stars(name,address) Movies(title, year, length, genre) Owns(names, title, year) Stars-in(names, title, 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: MovieExecs (cert#, name, address, networth) Presidents (cert#, name) Studios (name, address) Movies (name, title, year, length, genre)

-- Oct 23 In-Class Exercise Thread

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

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

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

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

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

-- Oct 23 In-Class Exercise Thread

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

Stars (name, address)

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

Movies (title, year, length, genre

Slide 7

Movies (title, year, length, genre)

Murder-Mysteries (title, year, weapon)

Cartoons (title, year)

Cartoon-MurderMysteries (title, year, weapon)

Slide 8

MovieExecs (cert#, name, address, networth)

Presidents (cert#, name)

Studios (name, address)

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

(Edited: 2019-10-23)

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

-- Oct 23 In-Class Exercise Thread

4

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

6

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

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