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