CMSC 243: Assignment 9: Database Design
You will submit the paper, Lastname_Firstname_database.docx in
Blackboard under assignments.
Continuing Case: Online Tutors, Inc.
Online Tutors, Inc. provides Online tutoring. They are doing well with
scheduled tutoring sessions, but would like to offer on demand tutoring in
addition.
Online Tutors’ 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, the team prepared a
system requirements document and submitted the recommendations to the
client. During the presentation, they discussed in-house development and
outsourcing options. They did not feel that a commercial software package
would meet the client’s needs. Based on their research, they felt it would be
premature to select a development strategy at this time. Instead, they
recommended that an in-house team should develop a design prototype,
using a relational database as a model. They 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. They 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. The client accepted the recommendation, and asked the team to go
forward with the plan.
Tasks
Create a professional looking document to address the issues noted below.
Be sure that you have corrected all spelling and grammar errors and clearly
label all sections of the report. Be sure to review previous assignments to
make sure you use the same items and names. 5 points
1. Task 1: Un-normalized table: Select two entities that are part of the new
project. Name the entity and list the attributes. If the cardinality is not 1 and
only 1, make a note of that.
2. Task 2: First Normal Form: Show each entity without repeating fields. Create
a separate entity for the relationship.
3. Task 3: Second/Third Normal Form: Show the key or keys for each table. All
values in the table must depend on the full key. Do this by making the key or
keys bold in task 2.
4. Task 4: Show an example for each table. If possible, represent the same
entity in each table to show the relationship.