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

PK Customer_ID

INVOICE

Invoice_ID

sent to

PK FK1 Date Subtotal

Tax

Total Customer_ID First_Name Last_Name

Middle_Initial

Phone

E-mail

Address City State ZIP

ORDER_ITEMS

PK PK,FK1 Order_Item_ID Product_ID Quanity

has

PK PK,FK1

ORDER

Order_ID Customer_ID FK2 orderDate Employee_ID

manages has

PK

EMPLOYEE

Employee_ID First_Name Last_Name

Middle_Initial

Phone E-mail PK

PRODUCT

Product_ID Product_Description Price

places mails

PK

SHIPMENT

Shipment_ID FK1 FK2 Shipment_Date Employee_ID Customer_ID

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.