DAD 220 Quantigration RMA ERD Text Version The database you are building is based on the relationship between the tables and the information that they have. These tables, the data

in them, and how they relate are described below. Each of these tables represents an entity. Each entity contains attributes or fields. Attributes have data types, and some are identified as primary or foreign keys. The ERD is the blueprint for building your relational database. Each table's primary key is denoted by the letters "PK". There are three separate tables. One in the bottom left corner, labeled "RMA", with another directly over it in the top left-hand corner, labeled "Orders". Directly to the right of the Orders table, in the upper right-hand corner, is another table labeled "Customers". The relationship between these tables is represented by a line connecting them. That line begins in the bottom left RMA table. It then goes to the Orders tables, and finally to the Customers table. Following the path of this relationship, the tables feature the following information: RMAID (PK) OrderID (FK) Step Status Reason Southern New Hampshire University OrderID (PK) CustomerID (FK) SKU Description CustomerID (PK) FirstName LastName StreetAddress Then, the line goes to the Orders table, which has the following information: City State RMA ZipCode Telephone INT INT VARCHAR(50) VARCHAR(15) VARCHAR(25) Orders Finally, the line coming out of the Orders table goes to the Customers table, which has the following information: INT INT VARCHAR(20) VARCHAR(50) Customers INT VARCHAR(25) VARCHAR(25) VARCHAR(50) VARCHAR(50) VARCHAR(25) VARCHAR(10) VARCHAR(15)