Blog

Which suppliers remain in the Supplier table after the DELETE statement executes? Supplier SupplierID CompanyName ContactName CountryID 2 Oshkosh Bgosh Martina Perry 2 3 LittleGuppies Cierra Martinez 1 4 Sugarplum Miranda Adams 2 5 Rosebuds for Girls Adan Stevens 2 6 Lin Ming C. Linda Ming 3 7 Periwinkle Sarah Gomez 2 DELETE FROM SupplierWHERE CountryID

A/An (blank) is a rule enforced on a table’s data.

In the Reservation table below, a room may be reserved several times, so the RoomNumber column is not unique. To ensure that a room can only be reserved by only one guest for the day, the minimal primary key consists of which columns? Reservation RoomNumber DateOfStay Guest ModeOfPayment 201 2020-01-10 Guest A cash 202 2020-01-15 Guest B cash 203 2020-01-18 Guest C credit card 204 2020-01-18 Guest D credit card 205 2020-01-19 Guest D credit card 206 2020-01-21 Guest E cash

Show the average rating for movies in each genre. Image Long Description Results Grid gen_title AVG(rating.rev_rating) Action 7.02308 Adventure 7.13023 Animation 6.59167 Comedy 7.45000 Crime 6.78182 Drama 6.84239 Horror 7.12500 Music 6.64444 Mystery 6.74048 Romance 7.35000 Thriller 6.75417 War 7.08333

Image Long Description This image is an entity-relationship diagram (ERD) for a movie review system, visually displaying five database tables—director, movie, rating, reviewer, and genre—and how they interrelate through their attributes and foreign keys. Director Primary Key id Attributes dir_firstName dir_last Relationships One-to-many relationship with movie Movie Primary Key id Attributes mov_title mov_year mov_time mov_lang mov_dt_rel mov_rel_country Foreign Keys gen_id dir_id Relationships Many-to-one relationship with director One-to-many relationship with rating Many-to-one relationship with genre Genre Primary Key id Attributes gen_title Relationships One-to-many relationship with movie Rating (Junction Table) Primary Key (Composite) rev_id (foreign key) mov_id (foreign key) Attributes rev_rating Relationships Many-to-one relationship with movie Many-to-one relationship with reviewer Reviewer Primary Key id Attributes rev_name Relationships One-to-many relationship with rating

Escoger pronombres reflexivos Complete each sentence with the correct reflexive pronoun.   Nosotros [answer1] maquillamos antes de ir a una discoteca. Tú [answer2] secas el pelo después de duchar. Uds. [answer3] levantan temprano los miércoles, ¿no? Yo [answer4] cepillo los dientes después de comer. ¿A qué hora [answer5] acuesta el bebé?

¿Qué palabra es? Write each word that has been spelled out for you.   hache – o – ele – a  [word1] be– i– e– ene [word2] ce – ele – a – ese – e [word3] ele – i – be – ere – o [word4] e – equis – ce – e- ele -e – ene -te -e [word5]  

Create a new view that shows the same information as #10 EXCEPT it should show the average rating of each movie. Use the view from #10 in the FROM clause (creating a view from a view). Name the average rating column AvgRating. Results Grid ID title Director First Name Director Last Name genre year AvgRating 901 Vertigo Alfred Hitchcock Mystery 1958 7.21250 902 The Innocents Jack Clayton Horror 1961 7.12500 903 Lawrence of Arabia David Lean Adventure 1962 7.87273 904 The Deer Hunter Michael Cimino War 1978 7.08333 905 Amadeus Milos Forman Drama 1984 6.85000 906 Blade Runner Ridley Scott Thriller 1982 6.87273 907 Eyes Wide Shut Stanley Kubrick Mystery 1999 7.00000 908 The Usual Suspects Bryan Singer Crime 1995 7.05455 909 Chinatown Roman Polanski Mystery 1974 6.22727 910 Boogie Nights Paul Thomas Anderson Drama 1997 6.76667 911 Annie Hall Woody Allen Comedy 1977 6.63333 912 Princess Mononoke Hayao Miyazaki Animation 1997 6.59167 913 The Shawshank Redemption Frank Darabont Crime 1994 6.50909 914 American Beauty Sam Mendes Romance 1999 7.11429

Select the movie title, duration, genre, and average rating for movies that had a run time of 2 hours and 45 minutes or more. Order the results in ascending order with the shortest movie at the top. Hint: Do not use a subquery. Results Grid mov_title mov_time gen_title avg(ra.rev_rating) Braveheart 178 Drama 6.85385 The Deer Hunter 183 War 7.08333 Titanic 194 Romance 8.17500 Seven Samurai 207 Drama 6.43000 Lawrence of Arabia 216 Adventure 7.87273

Select everything from the movies view that we created in class. Results Grid ID Title Director First Name Director Last Name Genre Year Rating Reviewer 901 Vertigo Alfred Hitchcock Mystery 1958 5.9 Paul Monks 901 Vertigo Alfred Hitchcock Mystery 1958 6.3 Mike Salvati 901 Vertigo Alfred Hitchcock Mystery 1958 6.0 Sasha Goldstein 901 Vertigo Alfred Hitchcock Mystery 1958 6.5 Krug Stillo 901 Vertigo Alfred Hitchcock Mystery 1958 9.1 Vincent Cadena 901 Vertigo Alfred Hitchcock Mystery 1958 6.2 Richard Adams 901 Vertigo Alfred Hitchcock Mystery 1958 8.7 Bonita Daly 901 Vertigo Alfred Hitchcock Mystery 1958 9.0 Miranda Hatfield 902 The Innocents Jack Clayton Horror` 1961 6.9 Righty Sock 902 The Innocents Jack Clayton Horror` 1961 8.1 Jack Malvern 902 The Innocents Jack Clayton Horror` 1961 6.1 Alec Shaw 902 The Innocents Jack Clayton Horror` 1961 8.4 NULL 902 The Innocents Jack Clayton Horror` 1961 8.0 Victor Woeltjen 902 The Innocents Jack Clayton Horror` 1961 9.1 Simon Wright