hello,

so i have an Assignment for database for SQL 

please check the attached file for more details.

Thanks

CSCI 2141Intro to Database SystemsFall-2016Assignment 2[50 marks]Submission Deadline: TUESDAY, 11thOCTOBER at 12:00 noonPROBLEM STATEMENT:Carefully study the Data Model given below. You are required to implement this database usingMySQL, populate the tables with the data provided, and use that database to answer theAssignment Tasks that follow.DVDVidRental Database:DVDVidRental is a new company that provides DVD Video Rentals. DVDVidRental can own severalcopies (VIDEO) of each movie (MOVIE).For example, the store may have 10 copies of the movie“The Shawshank Redemption”.“The Shawshank Redemption” would be one MOVIE and each copywould be a VIDEO.A rental transaction (RENTAL) involves one or more videos being rented to amember (MEMBERSHIP).A video can be rented many times over its lifetime, therefore, there is aM:N relationship between RENTAL and VIDEO.DETAILRENTAL is the bridge table to resolve thisrelationship.The complete ERD is provided in Figure below:SUBMISSION INSTRUCTIONS:Use this document as an answer template.Complete and submit this document with your answers filled in (scripts and screenshots ofthe results of each task) through Brightspace, before the submission deadline.Remember to rename the document with your ID (e.g.B00123456.docordocx)Doing with this assignment on your own will immensely improve your knowledge of SQL (Themore you struggle with it, the more you learn. Do ask for help if you get “really” stuck)Dalhousie UniversityFaculty of Computer Science

• 1495425772-Assignment 2.docx

ComputerScienceExpert

(11)

Status NEW Posted 22 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1495425775-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer