1 Select database management system Oracle SQL Server MYSQL

1. Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes.

2. Make sure all relationships have been addressed and corrected.

Orderitems Customer Order PK OrderltemlD PK CustomerlD PK OrderlD H----+FK1 ProductID CustomerName Address Phone OrderDate FK1 CustomerID TotalValue Quantity Toppings OtherDirections FK2 OrderID Product PK ProductID ProductName ProductType Price

Solution

1. Datatypes and sizes of all attributes:

Customer

CustomerID Int(30)

CustomerName char(30)

Address char(50)

phone Int(30)

Order

OrderID Int(30)

OrderDate Date()

CustomerID Int(30)

Totalvalue Int(30)

OrderItems

OrderItemID   Int(30)

ProductID Int(30)

Quantity Int(30)

Toppings char (50)

OtherDirections char (60)

OrderID Int(30)

Product

ProductID Int(30)

ProductName char (20)

ProductType char (20)

Price Int(30)

2. All is correct