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.