Search for movies by movie name or kind of movie

Assignment Help Computer Engineering

Reference no: EM1332893

RENT-A-MOVIE DATABASE PROJECT

I want to design a relational database to store information about my store (video rental store) customers and videotapes.

I think the database will improve my ability to market to and provide enhanced service to my customers. Among the things I would like to be able to do, once the database is up and running are:

1- Search for customers by last name or phone number

2- When entering new customers, enter a zip code and the database will find the city and state

3- Keep track of which movies their customers rented, on what dates, and how much they spent on each date and in total

4- Search for movies by movie name or type of movie

5- Search for movies that have a certain actor (note that some movies will have more than one actor worth searching on)

Some things you might need to know are:

1 - Movies rent for $3-$5 each, plus a 10% entertainment tax and late fee of $1 each day it is past due.

2- The possible types of movies are "Comedy", "Drama", "Family", "Horror", "SciFi",
and "Romance"

Guidelines:

1- Make sure all tables have a primary key that will be unique

2- Avoid many-to-many relationships between tables

THE ASSIGNMENT

1- Create a database using Microsoft Access

2- Create the appropriate tables and keys

3- Create the appropriate table relationships, enforcing Referential Integrity

Add records (feel free to be creative), including at least:

1. 5 different customers

2. 10 different videos

Specify a variety of prices and movie types

Associate more than one actor with some of the movies

15 rental transactions

At least 5 of them should include more than one movie

Every customer has at least 2 transactions

Specify a variety of movies and customers

Create the following queries, including at least the indicated fields:

Customer List: ID, Phone Number, Customer Name, Street Address, City, State, Zip

No duplicate rows (a duplicate row is one where ALL the same data appears in another row)

Sorted in ascending order by Customer's Last Name

Transaction List: Date, Customer Name, Video Name, Price, Tax, Total Price (for each movie rented). Format each field appropriately.

No duplicate rows (a duplicate row is one where ALL the same data appears in another row)

Sorted by Customer's Last Name and, within each customer, by Date with the most recent rental appearing first

THE VB.NET SIDE OF THE PROJECT

I want you to create a form using vb.net and connect to the access database using ADO.NET. This form should allow me to add new movie, customer or search for movie or customer

I want to be able to search the database by last name, phone, actor or movie title. Put the access database in the bin with the vb.net code

Arwo Studio is my store name. the word ARWO should be on top left of every GUI

Reference no: EM1332893

Questions Cloud

Explain using technology to fit e-business goals : Explain Using technology to fit E-business goals and When conducting business and businesses must first determine how technology and e-business will help the company operate more efficiently

What kind of employee information will the organization need : What kind of employee information will the organization need to give to the concerned government agencies and Which HR function is responsible for collecting information related to a deceased or injured employee?

Decision tree to model process of developing new drug : A pharmaceutical company is in the process of developing a new drug. The development is planned in twostages. Draw a decision tree to model this problem. Solve the problem by rolling back the tree.

Imortance of study of research methods : Discuss why the study of research methods is important and how it can enhance reports in criminal justice and criminology.

Search for movies by movie name or kind of movie : Search for movies that have a certain actor (note that some movies will have more than one actor worth searching on). Search for customers by last name or phone number.

Explain the responsibility of the employee : In the employment relationship, explain the responsibility of the employee and The employer? Are the responsibilities equal, or does one circumvent the other? What if one party doesn't fulfill their obligations? What is the result?

Discussing ethical conduct in research : Discuss regulating ethical conduct and researcher misconduct.

Suppose initially the prices of these stocks : Suppose DJIA records the changes in prices of 4 stocks. Suppose initially the prices of these stocks are $40. $20, $60. and $80. What is the DJIA.

Social influences affects decision-making by us consumers : Select one of the social influences that affects consumer decision-making. Provide a definition for it and discuss how this affects decision-making by U.S. consumers.

User Account

All Pages