Our database was made for the jewelry department at JCPenney. We made the database to keep track of customer’s repairs for their Careplans and regular repairs. Our forms include a customer log, a repair form and forms for WJS (the jeweler) and JCP employees. In the customers form we have a list of the customer’s name, address, and added a sub form that will tell us if they have a Careplan or not. If they do not have a plan with their jewelry there is a spot for how much the repair will cost them. As for the JCP and WJS employee forms, we have a list of names, position and contact information so employees can easily get in touch with the jeweler for information about the customers repairs. We also organized it so that each employee has an ID that matches up with the name of the customer they helped so the company can keep track of what employee helped that customer. As for our reports we have the customer log that combines the employee I.D. and customer’s information to summarize the outgoing repair. We also have a report that summarizes the associates and their I.D.’s and the customers. We also added a specific search bar where you can type in if you wanted to look at associate or manger information. The next report shows the gender statistic of who is purchasing/using the Careplans the most. The report shows the type of jewelry and what it is made out of, gold or silver. The report concluded that woman seem to use the plan the most for their jewelry. The next report shows the revenue from the repairs and summarizes the total at the bottom. This will help the company by showing how much they make off the repairs and the jewelry department. The last report displays the location of the stores customers showing where they receive the higher amount of people and maybe come up with a way to reach out to more people in a different area. A few enhancements for our system would be to have the number of times the customer brought the repair in. If we could keep track of how many times the item is repaired it will give the company a better idea of how their product holds up. Another enhancement would be to give the database to our jewelry to and have a system where they can enter the information of their side of the system and re-upload it to use so we can see the actual progress of the repair. Lastly, would be to include a password on the database/system so that customer’s information can be kept private and only viewed by jewelry associates or managers. Our maintenance strategy would be to have the jewelry department manager look at all the forms and reports once every month at the end of the month. What they can do is save the newly added customers/files on to a USB. Then uploading it to their computer in their office. This would have the database saved to three different location and provide a good backup strategy. Also, by having the associates check the database at the beginning and end of the day would provide adequate up keep of the information on the database.