User Account

All Pages

Create video store database in mysql

Assignment Help PL-SQL Programming
Reference no: EM131797701

Create 'Video Store' database in MySQL.

Create a table called "movies" with below information:

movie_id movie_name movie_date movie_length movie_director genre
1 The Shawshank Redemption 1994 122 Frank Dirabont Crime
2 The Godfather 1972 175 Francis Cappola Crime
3 The Godfather Part 2 1974 222 Francis Cappola Crime
4 The Dark Knight 2008 152 Christopher Nolan Action
5 Schindler's List 1993 195 Steven Spielberg Drama
6 12 Angry Men 1957 96 Sidney Lumet Crime
7 Pulp Fiction 1994 154 Quentin Tarantino Crime
8 The Lord of the Rings 2003 201 Peter Jackson Action
9 The Good, the Bad and the Ugly 1966 161 Sergio Leone Western
10 Fight Club 1999 139 David Fincher Drama
11 Forrest Gump 1994 144 Robert Zemeckis Drama
12 Inception 2010 148 Christopher Nolan Action
13 Goodfellas 1990 146 Martin Scorsese Drama
14 The Matrix 1999 136 Lana Wachowski Action
15 City of God 2002 130 Fernando Meirelles Crime
16 It's a Wonderful Life 1946 130 Frank Capra Drama
17 The Usual Suspects 1995 106 Bryan Singer Crime
18 Spirited Away 2001 125 Hayao Miyazaki Adventure
19 Saving Private Ryan 1998 169 Steven Spielberg Action
20 City Lights 1931 87 Charles Chaplin

Comedy

Create a table called "customers" with below information:

cust_id cust_name cust_address cust_city cust_state cust_phone
1 John Wilkins 456 Alberta Ave Topeka KS 4629349456
2 Albert Fonso 657 Sifter Road Phoenix AZ 4238593512
3 Susie Cue 987 Mull Ave San Jose CA 9874639554
4 Rosie Sims 987 Tiffany St Tucson AZ 4657389253
5 Tommy Jones 7654 Ribbit Circle New York NY 4485693045
6 Matt Smith 124 Lowe Tide Rd San Francisco CA 7594123465
7 Stephen Storch 345 Loft Ave Sacramento CA 9874561234
8 Lucy Mills 1756 Guadalupe Ave San Jose CA 2233473056
9 Jenny Tims 923 Ifter Circl Miami FL 7750982354
10 Susan Quats 1752 Ross Rd Phoenix AZ 8546034455

Create a table called "rentals" that connects the two tables above with the following information:

movie_id date_checked_out date_to_return chkout_charge customer_id customer_name

Create a database model for the video store.

Use Foreign Keys to link between the "rental" table, "customer" table and "movie" table.

a. the rental table will need to link to the video that is checked out and the customer. Each customer should have a video checked out.

b. The rental table must indicate whether is has been checked out so another customer can't rent it.

c. The rental table needs an event that can generate a query of customers who are past due on rentals.

Create a localhost.php folder named VideoStore containing Web pages for your video store.

a. Create an index to the web pages

b. Create a simple input and search page for customers

c. Create a simple input and search page for the videos

d. Create a simple page for rental checkouts, including indication of overdue rentals.

Submit at least two backup files created by a schedule.

Reference no: EM131797701

Questions Cloud

How do i figure out the depreciation : I am having a hard time figuring out depreciation on buildings and equipment. I am working on the 9-2A problem for ACC291. How do I figure out the depreciation?
Construct confidence interval : Compute sample proportions and then construct confidence interval estimates for each nation at the 95% level.
Electronics? engineers-procurers-metallurgists : services of many types of experts such as design and electronics? engineers, procurers,? metallurgists-the list is extensive.
What are the effects of night shifts on nurses : Write a research proposal on what are the effects of night shifts on nurses in relation to their circadian rhythm - Clearly stated problem and purpose of study
Create video store database in mysql : Create Video Store database in MySQL, Create a table called movies with below information
What is the project discounted payback : Fernando Designs is considering a project that has the following cash flow and WACC data. What is the project's discounted payback
How much is equivalent units of production for the period : A process with 1,600 units of beginning work in process completed and transferred. How much is equivalent units of production for the period for material costs?
Brings value to our customers and patients : This means using our definition of strategic advantage – providing a service that is different from our competitors that brings value to our customers/patients.
Declining membership over the past several : The fraternities and sororities at St. Algebra College have been plagued by declining membership over the past several years and want to know

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd