Data Definition

Data Definition

SALES_REPRESENTATIVE TABLE |

FIELD NAME | DATA TYPE | DESCRIPTION |

Salesrep_ID | VARCHAR | This is the primary key used to identify the sales representatives. |

Branch_ID | VARCHAR | This is a foreign key from Branch table and is used to identify the location of the branches. |

Salesrep_firstname | VARCHAR | This is the first name of the sales representative. |

Salesrep_lastname | VARCHAR | This is the last name of the sales representative. |

Salesrep_phoneno | Int | This is the contact number of sales representative. |

Salesrep_email | VARCHAR | This is the email address of the sales representative. |

BRANCH_AREA TABLE |

Branch_ID | VARCHAR | This is the primary to identify the Branch table. |

Branch_name | VARCHAR | This is the name of the branch. |

CUSTOMER TABLE |

Customer_ID | VARCHAR | This is the primary key to identify the customers. |

Customer_firstname | VARCHAR | This is the first name of the customer. |

Customer_lastname | VARCHAR | This is the last name of the customer. |

Customer_address | VARCHAR | This is the address of the customer. |

Customer_zipcode | Int | This is the zip code of the customer’s location address. |

Customer_phoneno | Int | This is the contact number of the customer. |

Customer_email | VARCHAR | This is the email address of the customer. |

ORDER TABLE |

Order_ID | VARCHAR | This is the primary key to identify the orders. |

Customer_ ID | VARCHAR | A foreign key from Customer table. |

Date_of_Order | Date | This is the date of the customer’s order. |

ORDER LINE TABLE |

Order_ID | VARCHAR | This is a foreign key acting as a primary key to identify the orders from the ORDER table. |

Product_ ID | VARCHAR | A foreign key from Customer table. |

Ordered_Quantity | Int | This is the number of ordered products. |

PRODUCT TABLE |

Product_ID | VARCHAR | This is a primary key to identify the product. |

Product_info | VARCHAR | The information about the...