Everyone I need some help on this school project. I know pretty much nothing about databases and would really appreciate some advice. I'm guessing there are a ton of you guys on the forum that could do this entire project in a day! below I have posted the details of what the project is for. THANKS!
Project Summary
?HW Video? has decided to sell and rent through the Internet. Your company has been awarded the sub contract to help HW Video purchase and prepare a database for the various environments.
Project History
HW Video is the world?s fifth largest video chain with over 1,800 stores. In the past two years, HW Video has seen a decline in its video rental and sale business due to increased competition from various online stores. Management believes that with the backing of its traditional store business, a web site geared towards selling and renting videos would complement HW Video?s business. Based on this direction, a prolonged requirement phase was started that collected the requirements for this online information system. Your company has been sub contracted to help with the purchase, and design of HW Video?s databases.
Project Objectives
This project was chosen for the following reasons:
1. There are a lot of video rental stores currently in the Internet. These can serve as examples to Students trying to finish this project.
? http://www.blockbuster.com
? http://www.netflix.com
? http://www.hollywoodvideo.com
2. Various Business to Consumer (B2C) web sites specialize in selling goods and services to customers presently in the Internet. Completing this project will give the Students an idea about how databases are used in these web sites.
3. Understanding the intricacies of this project will help students understand the database needs of Internet based Client/Server development model. At present, this model is the most prevalent model for new projects in the computing industry utilizing databases.
Project Description
The project should take into account the following business requirements:
? The web site shall allow customers to buy or rent VHS tapes, DVDs, gift cards, and gaming systems from the web site.
? The web site shall allow customers to search based on various criteria.
? The web site shall collect customer information including address (mailing, home), payment information should be captured by the system.
? The web site shall show customers the ?Top 10 Video Rentals? whenever they enter the web site.
? The web site shall show customers the ?Top 10 Video Rentals? based on category (Comedy, Action etc.) whenever they browse by a certain category in the web site.
? The web site should accommodate various membership options.
? The web site shall provide various rate options based on whether the movie rented is a new movie (equal to or less than 6 months since release date)or old movie (more than 6 months since release date).
? The web site shall use customer?s birth date to send an email to earn a free rental on their birthday.
? The web site shall provide adequate security to protect information stored and to provide access to private information only to the respective customers.
? The web site shall support listing of upcoming attractions.
? The web site shall provide the capability to preorder on upcoming attractions.
? The web site shall provide managers the capability to print a report that shows the list of customers and their order for a given area.
? The web site shall allow customers to find out the contact information (address, phone) of a nearby store based on an address.
? The web site shall allow management to declare special discounts for all rental during certain time periods (holiday season, for instance).
The following items need to be addressed in the project:
? Maintaining Historical Information
? User Authentication and Roles
? Domain Tables
Project Deliverables
The following documents will need to be delivered at the end of this project:
1. Database System Selection Summary (3 ? 5 pages) (Due: Week 4)
? Criteria Used
? Features comparison
? Selection Reason
2. Relational Database Design (ER Diagrams) (3 ? 5 pages) (Due: Week 4)
? Selecting entities
? Overall diagram
? Domain tables
? History tables
? Security tables
3. Normalization (with steps) (3 ? 5 pages) (Due: Week 7)
? Unnormalized data
? Applying normalization 1NF, 2NF, 3NF
? E-R diagram showing normalized tables (only table names required)
4. Sample Data Entry Forms with SQLs (5 - 7 pages) (Due: Week 7)
? Insert, Update, Delete Screens and SQLs (8 SQLs)
? Search screen SQLs (3 SQLs)
5. Sample Reports with SQLs (5 ? 7 pages) (Due: Week 7)
? Reports using multiple tables
Project Presentation
The team will make an oral presentation (20 - 30 minutes) to the class to explain the following:
? The various deliverables and how they fit together
? How were the deliverables constructed
? The reasoning behind various design decisions
Project Summary
?HW Video? has decided to sell and rent through the Internet. Your company has been awarded the sub contract to help HW Video purchase and prepare a database for the various environments.
Project History
HW Video is the world?s fifth largest video chain with over 1,800 stores. In the past two years, HW Video has seen a decline in its video rental and sale business due to increased competition from various online stores. Management believes that with the backing of its traditional store business, a web site geared towards selling and renting videos would complement HW Video?s business. Based on this direction, a prolonged requirement phase was started that collected the requirements for this online information system. Your company has been sub contracted to help with the purchase, and design of HW Video?s databases.
Project Objectives
This project was chosen for the following reasons:
1. There are a lot of video rental stores currently in the Internet. These can serve as examples to Students trying to finish this project.
? http://www.blockbuster.com
? http://www.netflix.com
? http://www.hollywoodvideo.com
2. Various Business to Consumer (B2C) web sites specialize in selling goods and services to customers presently in the Internet. Completing this project will give the Students an idea about how databases are used in these web sites.
3. Understanding the intricacies of this project will help students understand the database needs of Internet based Client/Server development model. At present, this model is the most prevalent model for new projects in the computing industry utilizing databases.
Project Description
The project should take into account the following business requirements:
? The web site shall allow customers to buy or rent VHS tapes, DVDs, gift cards, and gaming systems from the web site.
? The web site shall allow customers to search based on various criteria.
? The web site shall collect customer information including address (mailing, home), payment information should be captured by the system.
? The web site shall show customers the ?Top 10 Video Rentals? whenever they enter the web site.
? The web site shall show customers the ?Top 10 Video Rentals? based on category (Comedy, Action etc.) whenever they browse by a certain category in the web site.
? The web site should accommodate various membership options.
? The web site shall provide various rate options based on whether the movie rented is a new movie (equal to or less than 6 months since release date)or old movie (more than 6 months since release date).
? The web site shall use customer?s birth date to send an email to earn a free rental on their birthday.
? The web site shall provide adequate security to protect information stored and to provide access to private information only to the respective customers.
? The web site shall support listing of upcoming attractions.
? The web site shall provide the capability to preorder on upcoming attractions.
? The web site shall provide managers the capability to print a report that shows the list of customers and their order for a given area.
? The web site shall allow customers to find out the contact information (address, phone) of a nearby store based on an address.
? The web site shall allow management to declare special discounts for all rental during certain time periods (holiday season, for instance).
The following items need to be addressed in the project:
? Maintaining Historical Information
? User Authentication and Roles
? Domain Tables
Project Deliverables
The following documents will need to be delivered at the end of this project:
1. Database System Selection Summary (3 ? 5 pages) (Due: Week 4)
? Criteria Used
? Features comparison
? Selection Reason
2. Relational Database Design (ER Diagrams) (3 ? 5 pages) (Due: Week 4)
? Selecting entities
? Overall diagram
? Domain tables
? History tables
? Security tables
3. Normalization (with steps) (3 ? 5 pages) (Due: Week 7)
? Unnormalized data
? Applying normalization 1NF, 2NF, 3NF
? E-R diagram showing normalized tables (only table names required)
4. Sample Data Entry Forms with SQLs (5 - 7 pages) (Due: Week 7)
? Insert, Update, Delete Screens and SQLs (8 SQLs)
? Search screen SQLs (3 SQLs)
5. Sample Reports with SQLs (5 ? 7 pages) (Due: Week 7)
? Reports using multiple tables
Project Presentation
The team will make an oral presentation (20 - 30 minutes) to the class to explain the following:
? The various deliverables and how they fit together
? How were the deliverables constructed
? The reasoning behind various design decisions
Facebook
Twitter