PHP Search Engine

Oct 23 In-Class Exercise Thread .

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

Best,

Chris

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

-- Oct 23 In-Class Exercise Thread

''' slide 4''' Studios(name PK, address) Stars(name PK, address) Owns(Studio.name, Movie.title, Movie.year) Stars-in(Starts.name, Movie.title, Movie.year) Movies(title PK, year PK, length, genre)

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

''' Slide 7 ''' Movies(title PK, year PK, length, genre) Murder-Mysteries (weapon, Movies.title PK, Movies.Year PK) Cartoons (Movies.title PK, Movies.year PK) Cartoons-Murder-Mysteries(weapon, Movies.title PK, Movies.Year PK)

''' Slide 8 ''' Movies(title PK, year PK, length, genre, Studios.name) Studios(name PK, address, MovieExecs.cert#) Presidents(MovieExecs.cert#)

(Edited: 2019-10-23)

''' slide 4''' Studios(name PK, address) Stars(name PK, address) Owns(Studio.name, Movie.title, Movie.year) Stars-in(Starts.name, Movie.title, Movie.year) Movies(title PK, year PK, length, genre) ''' Slide 6 ''' Stars (name PK, address) Movies (title PK, year PK, length, genre) Stars-in (Stars.name, Movie.title, Movie.year, salary, resisual) ''' Slide 7 ''' Movies(title PK, year PK, length, genre) Murder-Mysteries (weapon, Movies.title PK, Movies.Year PK) Cartoons (Movies.title PK, Movies.year PK) Cartoons-Murder-Mysteries(weapon, Movies.title PK, Movies.Year PK) ''' Slide 8 ''' Movies(title PK, year PK, length, genre, Studios.name) Studios(name PK, address, MovieExecs.cert#) Presidents(MovieExecs.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#)

(Edited: 2019-10-23)

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

For the three class in slide 4 we have the Relation:

Movies(title, year, length, genre)

Stars(name, address)

Studio(name, address)

An association according to the UML Diagram we would have this Relational mapping:

StarsIn(starName, movieTitle, movieYear)

Owns(studioName, movieTitle, movieYear)

slide 6 we have:

Movies(title, year, length, genre),

Compensation(salary, residuals),

Stars(name PK, address)

An association according to the UML Diagram we would have this Relational mapping:

StarsIn(starsName, movieTitle, movieYear, salary)

Slide 7

(Edited: 2019-10-23)

For the three class in slide 4 we have the Relation: Movies(title, year, length, genre) Stars(name, address) Studio(name, address) An association according to the UML Diagram we would have this Relational mapping: StarsIn(starName, movieTitle, movieYear) Owns(studioName, movieTitle, movieYear) slide 6 we have: Movies(title, year, length, genre), Compensation(salary, residuals), Stars(name PK, address) An association according to the UML Diagram we would have this Relational mapping: StarsIn(starsName, movieTitle, movieYear, salary) Slide 7

-- Oct 23 In-Class Exercise Thread

Page 4: Studios(name PK, address), Movies(title PK, year PK, length, genre), Stars(name PK, address), Owns(name, title, year), Stars_In(name, title, year)

Page 6: Stars(name PK, address), Movies(title PK, year PK, length, genre), Stars_In(name, title, year, salary, residuals)

Page 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)

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

(Edited: 2019-10-23)

Page 4: Studios(name PK, address), Movies(title PK, year PK, length, genre), Stars(name PK, address), Owns(name, title, year), Stars_In(name, title, year) Page 6: Stars(name PK, address), Movies(title PK, year PK, length, genre), Stars_In(name, title, year, salary, residuals) Page 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) Page 8: Movies(title PK, year PK, length, genre, studioName), Studios(name PK, address), MovieExecs(cert# PK, name, address, networth), Presidents(cert# PK, name, address, networth, studioName)

-- Oct 23 In-Class Exercise Thread

'''Slide 4'''

Studios(name, address)

Movies(title, year, length, genre)

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

Stars(name, address)

'''Slide 6'''

Stars(name, address)

Movies(title, year, length, genre)

Stars-in(Stars.name, Movie.title, Movie.year, salary)

(Edited: 2019-10-23)

'''Slide 4''' Studios(name, address) Movies(title, year, length, genre) Owns(Studio.name, Movie.title, Movie.year) Stars(name, address) '''Slide 6''' Stars(name, address) Movies(title, year, length, genre) Stars-in(Stars.name, Movie.title, Movie.year, salary)

-- Oct 23 In-Class Exercise Thread

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

'''Slide 6''' Stars(name, address) movies(title, year, length, genre) Stars-in(name, title, year, salary, residual)

'''Slide 7''' Movies(title, year, length, genre) Mur-der-Mysteries(weapon, title, year) Cartoon-MuderMysteries(weapon, title, year) Cartoon(title, year)

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

(Edited: 2019-10-23)

'''Slide 4''' Studio(name, address) Stars(name, address) Movies(title, year, length, genre) Owns(name, title, year) Stars-in(name,title,year) '''Slide 6''' Stars(name, address) movies(title, year, length, genre) Stars-in(name, title, year, salary, residual) '''Slide 7''' Movies(title, year, length, genre) Mur-der-Mysteries(weapon, title, year) Cartoon-MuderMysteries(weapon, title, year) Cartoon(title, year) '''Slide 8''' Movies(title, year, length, genre) Studios(cert#, name, address,) Presidents(cert#) MovieExecs(cert#, name, address, networth)

-- 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

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

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

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

-- 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 MovieExecs (cert#, name, address, networth) Presidents (cert#, name) Studios (name, address) Movies (name, title, year, length, genre)

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 MovieExecs (cert#, name, address, networth) Presidents (cert#, name) Studios (name, address) Movies (name, title, year, length, genre)