Jackson_Eddie_IT525_Unit_6_Research_Project

Report
Unit 6 Research Project
Eddie S. Jackson
Kaplan University
IT525: Database Design and Data Modeling
06/15/2014
Summary

Robot Emporium needs a database
 Sells robot parts
 Manage customer information
 Employees must manage orders
 Shipment must be a part of the
database
Entities

Customer
 Order
 Order Items
 Product
 Employee
 Shipment
 Invoice
Business Rules

There are four business rules
 Customer - Invoice
 Order - Products
 Employee - Customer
 Employee - Shipments
Normalization

There are 3 normalization forms used in
this database design
 First Form
 Second Form
 Third Form
Database Changes


Try to reduce unnecessary null entries
Remove the relationship between
Product and Shipment
Database Changes - ERD
CUSTOMER
INVOICE
PK
Invoice_ID
FK1
Date
Subtotal
Tax
Total
Customer_ID
sent to
PK
Customer_ID
First_Name
Last_Name
Middle_Initial
Phone
E-mail
Address
City
State
ZIP
ORDER
ORDER_ITEMS
PK
PK,FK1
Order_Item_ID
Product_ID
Quanity
has
PK
PK,FK1
Order_ID
Customer_ID
FK2
orderDate
Employee_ID
mails
places
SHIPMENT
PK
Shipment_ID
FK1
FK2
Shipment_Date
Employee_ID
Customer_ID
manages
EMPLOYEE
has
PK
PRODUCT
PK
Product_ID
Product_Description
Price
Employee_ID
First_Name
Last_Name
Middle_Initial
Phone
E-mail
prepares
Lessons Learned 1 of 2

RDBMS
 Entities
 Tables
 Attributes
 Relationships
Lessons Learned 2 of 2




Crow’s Foot Notation
Many-to-Many
One-to-One
One-to-Many
Reference
3ders. (n.d.). Robot Shop. Retrieved from http://www.3ders.org/images/robotshop-
3d-printing-service.jpg
Coronel, C., Morris, S., & Rob, P. (2012). Database systems: design,
implementation, and management (10th ed.). Boston, MA:
Cengage Learning.
Staff, Borland. (n.d.). The definition of first, second, third, fourth and fifth normal forms. Retrieved
http://edn.embarcadero.com/article/25209.

similar documents