CSC 4480: Principles of
Sample Deliverable for Phase 1: Project Proposal
This project will focus on QVC. QVC is a company
that produces products that they advertise on television in infomercials, which
vary from 5 minutes to about 20 minutes in length. QVC is a unique company in
that it does all of its business solely through these infomercial
demonstrations. The products can only be ordered from their website or through
their website or money order.
- A customer
may create an account with QVC. The Account has a unique
ID, a Username and Password, and the Account Type (Admin, Employee, Customer). The
first and last name of the user is also known and the date that it was
created. QVC requires an email, pin, title (Ms., etc.), name(first, last), address, ZIP, country, and home
person may buy many products. A
product may be sold to many customers. A customer may place many orders.
A product can be in many orders.
- A product
has a product line can be placed in many orders. A product
line An order may have many products . QVC will keep
track of the and has a shipping date and
the arrival date.
categories of QVC will grow over time, but for now includes Fashion, Shoes
& Handbags, Jewelry, Beauty, Kitchen & Food, Home & Harvest,
Electronics, Holiday Décor, Clearance, and more.
customer may cancel a product at any time.
A customer may cancel an order of many products at any time. A customer may cancel an order at
any time before the products are shipped.
- QVC hires
many Employees such as Administrative, Affiliate Relations, Apparel Design
& Development, Bus Strategy & Tech Integration, Consumer Insights,
creative Execution, Customer Service Corporate, Distribution/Warehousing,
Executive, Facilities, Finance, Food services, Fulfillment, Human
Resources, Information Services, Information Technology J, Internal
Events/Communications, International, Inventory Control, Jewelry
Manufacturing, Legal, Legal & Internal Audit, Marketing,
Merchandising, Multichannel, Operations & Services, Other, Outlet
Division, Programming, Publishing/Recording, QA-Site, Quality Assurance,
Retail, Returns, Security, Strategy & Analysis, and Workplace
can work at different locations such as Chesapeake, VA, Florence, SC,
Frazer Outlet, PA, Lancaster, PA, Mebane Outlet, SC, Port St Lucie, FL,
Rehoboth Beach Outlet, DE, Rockvale Outlet, PA,
Rocky Mount, NC, San Antonio, TX, Suffolk, VA, and QVCs main base is in
West Chester, PA, but
the Employee is assigned to only one location. From those locations the can either work
for Media, Service, and Warehouse.
- An Employee
can be Full Time or Part Time but not both.
may also apply for a QCard. Some benefits are sneak peeks at Today’s
Special Value® offers, private sale opportunities, and special
promotions, one free Studio Tour pass for you and 5 friends at our
state-of-the-art broadcasting facility in West Chester, PA., Easy-to-read, itemized monthly
statements for all your QCard purchases,
conveniently view and pay your bill online, receive paper or online
statement (customers choice)
- If a
customer is dissatisfied with the product, he or she may return the
product within a certain time period for a full refund.
- What is the
product quantity for each product?
What is the
product quality for each product?
products were sold in a day? Week? Month? Quarter? Year?
- What was
the profit/loss in a day? Week? Month? Quarter? Year?
really stand for Quality, Value, and Convenience
are being promoted?
What is the
day’s special offer?
- What is
currently being sold on TV?