SQL_Project.docx - Movie Rental Database Description and...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Movie Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1. MOVIE_I D MOVIE_TITLE MOVIE_VALUE MOVIE_QTY MOVIE_CAT_ID MOVIE_CATEGORY 1 Alien 10 5 1 SciFi 2 Bladerunner 8 3 1 SciFi 3 Star Wars 15 11 1 SciFi 4 Texas Chainsaw Masacre 7 2 2 Horror 5 Jaws 7 1 2 Horror 6 The good, the bad and the ugly 7 2 3 Western 7 Silverado 7 1 3 Western 8 Duck Soup 5 1 4 Comedy 9 Planes, trains and automobiles 5 3 4 Comedy 10 Waking Ned Devine 12 4 4 Comedy 11 Deep Blue Sea 14 3 5 Drama 12 The Fifth Element 15 5 5 Drama Columns Descriptions ------------- ----------------------------------------- movie_id Movie ID movie_title Movie Title movie_value The value (cost) of each movie movie_qty The number of copies available for each movie movie_cat_id Movie Category ID movie_category The category for each movie UNNORMALIZED TABLE 2. Columns Descriptions --------- ---------------------------------------- Member_id Member's ID
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Last Member's last name First Member's first name License# Member's driver license number St Member's driver license issuing state Credit_card Member's credit card number Rental_id Rental transaction ID Rent_date Movie rent date Return_date Movie return date Pay_method Member's payment method for each rental transaction Part I: Datbase Design (30 Points) 1. Please draw the Entity-Relationship Diagram for your database below (15 points) Hint: you should identify 4 entities if you correctly normalize the data, and please name them as movie, movie_type, rental and member respectively. 1) Entity-Relationship Diagram 007Ac007A STEP 1: Grouped the similar objects into entity sets. Identified the entities in the database. Movie, movie_type, member and rental are separate entities.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern