Database Assignment

Price: $5.00 USD

Document Description

This is a small database assignment on relationships and database testing

Written By

Studypool Tutor
NameSchoolTopicCourseDatePart OneEntitiesMovieCustomerCashierTransactionPaymentReportMediumPART 3pk- Primary Keyfk- Foreign key1 NFSTOREStore Code, Store AddressCUSTOMERCustomer Name, Customer AddressMOVIEMovie Title, Disc Type, Date Rented2 NFSTOREStore Code (pk), Store AddressCUSTOMERCustomer Id (pk), Customer Name, Customer AddressDISC_TYPEDisc type id (pk), Disc type(Disc type example DVD/VHS)MOVIEMovie Id (pk), Movie Title, Disc Type id (fk), Date Rented3 NFMovie_OverdueOverdue_ d (pk), Store id (fk), Customer id (fk), Movie id (fk), AmountPART 31. Show all rental transactions for a given week.Select * from transactions where Issued_date Between '2015-04-27' AND '2015-05-2'2. List all movies & their formats in order of Directors surname.SELECT dir.Director_Name,mv.Movie_Title, mv.Movie_Duration, fm.Format_Type,mv.Release_Year FROM movie_directors AS dirINNER JOIN movie AS mv ON dir.Director_id = mv.Director_idINNER JOIN format fm ON fm.Format_id = mv.Format_id ORDER BY dir.Director_Name3. List all movies which came out in 2013.SELECT movie.Movie_Title, movie.Release_Year, movie.Movie_Duration, format.Format_TypeFROM,movieINNER JOIN format ON format.Format_id = movie.Format_idWHERE Release_Year='2013'4. A transaction reportSELECT cust.Customer_Name, mv.Movie_Title, trans.Issued_date,trans.Expected_return_date,pay.AmountFROM payment payINNER JOIN transactions trans ON trans.
lock_open Buy Document

Reviews from Students

Studypool Student
"Thanks, good work"
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors