Project

Only available on StudyMode
  • Download(s) : 17
  • Published : March 12, 2013
Open Document
Text Preview
Projects Manual for Developing Web-Enabled Decision Support Systems Using Access, VB .NET and ASP .NET

Sandra D. Ekşioğlu
Industrial and Systems Engineering Mississippi State University, Mississippi State

Abhijit A. Pol
Computer and Information Science and Engineering University of Florida, Gainesville

Ravindra K. Ahuja
Industrial and Systems Engineering University of Florida, Gainesville & Innovative Scheduling, Inc. Gainesville

Contents

PROJECT 1 PROJECT 2 PROJECT 3 PROJECT 4 PROJECT 5 PROJECT 6 PROJECT 7 PROJECT 8 PROJECT 9 PROJECT 10 PROJECT 11 PROJECT 12 PROJECT 13 PROJECT 14 PROJECT 15 PROJECT 16 PROJECT 17 PROJECT 18 PROJECT 19 PROJECT 20 PROJECT 21

Book Store Database Library Operations Housing Department Course Timetabling Marble Factory Regional Utilities Decision Rules for Race Horse Wagering Tennis Ranking System Redesigning the MBA curriculum Inventory Management at Blue Bell Selecting an All-Star Team Farm Management The Annual Bolder Boulder Race Supply Chain Design Inventory Routing Problem Billing System at University of North Carolina Pharmaceutical Care System Internet and Exchange Billing Database for Course Timetabling Outdoor Patient Division Management Database for a Blood Bank

1

PROJECT 22 PROJECT 23 PROJECT 24 PROJECT 25 PROJECT 26 PROJECT 27 PROJECT 28 PROJECT 29 PROJECT 30 PROJECT 31 PROJECT 32 PROJECT 33 PROJECT 34 PROJECT 35 PROJECT 36 PROJECT 37 PROJECT 38 PROJECT 39 PROJECT 40 PROJECT 41 PROJECT 42 PROJECT 43 PROJECT 44 PROJECT 45 PROJECT 46 PROJECT 47 PROJECT 48 PROJECT 49 PROJECT 50

Equipment Maintenance Database Spare Parts Management Allocating Crude Oil Supply to Refinery Tanks Job Scheduling Using Heuristic Approach Personnel Career Management Management of Health Care Services Tender Evaluation Using a Decision Support System Incentive Bonus Database Performance Based Compensation in an Organization DSS for an Electric Utilities Company: Compliance with Clean Air Act Wood Panel Manufacturing Knowledge Management Database Managing the Outdoor Patient Division in a Hospital Water Treatment Facilities in a Municipal Area Asset and Liability Management Personalization in Data Mining International Student Information System Vet-Med Decision Support System CD Warehouse Management Emerald Realty Group Inc Passenger Reservation System Decision Support System for a Financial Institution Decision Support System for Taiwan’s Federal Aviation Administration Decision Support System for a Car Rental Company Human Resources Management at Shand’s Hospital Information System for the “Clean-and-Go” Shop Information System for a Movie Theater Information System for an On-Line Electronics Shop Information System for the “Mediterranean Food” Store

2

Case Study 1

Bookstore Database

1

Book Store Database

Problem Description
A small sized bookstore has been keeping track of its business mainly on paper. The owner is planning to grow her business. She would like to improve the bookkeeping, and as a result provide better service to customers, through a state-of-the-art database system. As she is not familiar with recent technology and tools, she would like to hire a college student who would develop such a system over the next summer. The new system will help the bookstore maintain details about books, publishers, customers, receipts/payments, etc. A book may be a textbook, a novel, a comic, a children’s book, or a cookbook. Publishers are the suppliers of the books. The bookstore buys books from different publishers. Typical customers of the store are libraries, institutions, or individuals such as students, faculty, and others. Customers may open an account with the store if they wish and receive a customer number. The bookstore is planning to build a website that will allow customers to perform certain activities on-line. When customers place an order on-line, they can pay either by a major credit card or store credit. If the transaction takes place in the...
tracking img