Database Projects 2011 Library Education Assessment Database Contact: Jessica Olin, OlinJR @hiram.edu Description: One of the functions of the library is to conduct information literacy / library skills sessions. These sessions are conducted for first-year-experience (FYE) classes such as FRCL and FSEM, and others as requested by faculty. Sessions are conducted by various library employees. The purpose of this database will be to collect and mine information about these sessions. “We gather information from faculty when we conduct an information literacy/library skills session (the prof's name, department, class name, class number, # of students, topics to be discussed during class, associated assignment, etc.). We also gather evaluative data from the classes and professors once the session has been held. In the future, I will be gathering even more assessment data on these sessions. I want a database that will allow me to recombine the data in a wide variety of ways: How many times have we worked with Professor X? How often do we do sessions for Department Y? How do the perceptions of students in FYE classes (FRCL/FSEM/WSEM) compare with those of students in Intro to Major classes?” Internet Based Resale Store Database Contact: Karen Ising, [email protected] Description: This database would be the information repository for a student-run business, as described below. Although the student refers to developing ‘the site’, your project would primarily be to develop the database that goes behind the sites specified (which are views of the database). You are encouraged to provide additional views that would help Karen run her business. “First I’d like to give a little background on the potential business that this website would serve. The business enterprise that I hope to have a website for is essentially an internet based resale store where students can sell unwanted dorm items (microwaves, area rugs, desk lamps, etc.) for a little bit of cash. The items would then be refurbished and sold to other students via the website. For the site itself, I envision it to be similar to other purchasing sites where the user would see a main welcome page with maybe some items displayed or photos on a loop in the center of the page. There would also be options from this page to search various item categories (couches, bookshelves, lamps, small items, etc.). Each item would offer the user information about the product including size, condition, pictures, a description, and price. The customer would then be able to add items to their shopping cart and pay viapaypal or some other method. Upon checkout, the customer needs to be able to select a time for delivery as well as a location. The site would also need another aspect from the home page that would allow customers to offer their unwanted items. Perhaps a “Sell Here” tab that brings up a page where consumers can upload a photo of their item they hope to sell, describe its condition and provide other item specifications. They would also need a space to add their contact information if the company should want to purchase the item from the consumer.