You are tasked with creating an online video store. The new system will do the following:

1. Store all aspects of movies including:

A. tblVideos (VideoID, Title, ProductionDate, Copies, RentalCost, VideoDescription)

B. tblCustomers (CustomerID, CustomerName, CustomerAddress1, CustomerAddress2, CustomerCity, CustomerState, CustomerZipCode, CustomerTelephoneNumber, CustomerEmail)

C. tblMovieRentals (VideoID, CustomerID, DateRented, Date Returned, AmountPaid

2. Will be available to employees through an internal system via an internal web-based data-driven system. You should recommend a specific programming language and database. Do not worry if you do not know how to develop as this is just a design document. However, you should provide at least 3 solid statements in your own words with at least 1 supporting reference as to why you selected this programming language and database.

3. Design an Employee Login with appropriate security.

Below are the specific items:

1. System Name (make one up and place it in the Title) along with the doctors name and a fictitious address and contact information

2. Table of Contents (more will be added in future assignments)

3. Add a section titled System Description and provide at least 50 words of the system goals

4. Add a section titled System Requirements and add to it using from the requirements above and your research; include at least one reference from another source

5. Add a section titled Questions and Facts" with all of the following:

A) System Development Team Members

B) Hardware and Software

C) Time and Costs

D) Other (anything else you have)

6. Add a new section titled System Design Models

A. Create a Basic System Flowchart (use any flowchart tool such as MS Visio, MS Word, or even Paint)

B. The diagram should show the inputs, processes, and outputs

C. The diagram should show inputs, processes, outputs, and conditional branching

D. Label this diagram Logical Model and include it in the System Design Models section

E. Include at least a 100 word narrative of the Logical Model. The target audience should be the System Owner and be more of a high-level.

7. Add a new section titled Database Design and create a table with at least 3 tables showing the database design

8. Add a new section titled Graphical User Interface and design Create, Read, Update, and Delete (CRUD) screens for the tables