Homework 9, Chapter 9:

Database Design Continuing Case: Online Tutoors, Inc.

Online Tutoors, Inc. provides Online tutoring. They are doing well with scheduled tutoring sessions, but would like to offer on demand tutoring in addition. Online Tutoorss president, Mary Montgomery, sent a letter to IT consultant, Julie Martin, to help develop the system for the new services. During the project, Julie will work closely with Ryan Lewis, who manages Online operations. You, as an intern will assist Julie. You are eager for the chance to make a good impression in your first professional job. Background After evaluating various development strategies, Julie prepared a system requirements document and submitted her recommendations to Mary Montgomery, Online Tutoors's president. During her presentation, Julie discussed in-house development and outsourcing options. She did not feel that a commercial software package would meet Online Tutoors's needs. Based on her research, Julie felt it would be premature to select a development strategy at this time. Instead, she recommended to Mary that an in-house team should develop a design prototype, using a relational database as a model. Julie said that the prototype would have two main objectives: It would represent a user-approved model of the new system, and it would identify all systems entities and the relationships among them. Julie explained that it would be better to design the basic system first, and then address other issues, including Web enhancements and implementation options. She proposed a three-step plan: data design, user interface design, and application architecture. She explained that systems analysts refer to this as the systems design phase of a development project. Mary agreed with Julies recommendation, and asked her to go forward with the plan.

Tasks

Review the Online Tutoors fact-finding summary and draw an ERD with cardinality notation. Assume that system entities include members, classes, merchandise, and tutoors.

Design tables in 3NF.

Create the database, include various codes for at least three of the fields. For this assignment, you are to submit a database in addition to the Word document.