RDB PRIME!
Engineering
Home
Research Paper(s)
Resume
Technology Items
Site Map
Site Search
 
 It is 16:25 PST on Thursday 03/28/2024

Annabelle School Supplies

RDB PRIME INC. -- Engineering

Created by: Robert Betterton

Date: Sun, Oct 21, 2001

Time: 03:51


Table of Contents

  1. Data Models
    1. Main
  2. Data Dictionary

Data Models

Document: AnnabelleSchoolSupplies.erd


Data Model

Image of Main

1-1 Main

Related Diagrams:

None:

Related Dictionary Entries:

Entities/Tables:

AES_CUSTOMER
AES_EMPLOYEE
AES_EMPLOYEE_COMMENT
AES_INVENTORY
AES_INVENTORY_PROFILE
AES_ORDER
AES_ORDER_LINES
AES_PRODUCT
AES_PRODUCT_PROFILE
AES_SHIP
AES_SUPPLIER
AES_SUPPLIER_PROFILE
AES_WAREHOUSE

Relationships:

Customer_Order
Employee_EmployeeComment
Employee_Warehouse
InventoryProfile_Warehouse
Inventory_InventoryProfile
OrderLines_Products
OrderLines_Ship
Order_OrderLines
ProductProfile_Warehouse
Product_ProductProfile
SupplierProfile_Warehouse
Supplier_SupplierProfile

Return To Contents


Data Dictionary

Name: AES_CUSTOMER
Composition:
*AES_CUSTOMER'CUSTOMER_ID +
AES_CUSTOMER'FIRST_NAME +
AES_CUSTOMER'LAST_NAME +
AES_CUSTOMER'REGION +
AES_CUSTOMER'PHONE +
AES_CUSTOMER'EMAIL +
AES_CUSTOMER'ADDRESS +
AES_CUSTOMER'CITY +
AES_CUSTOMER'ZIP +
AES_CUSTOMER'STATE
Definition: This is the customer entity which stores all information about the customer.


Customer Info
#Details
Physical: AES_CUSTOMER
##
#TableCode
##
#Notes
##
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_CUSTOMER'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the address for the customer. It is assumed they have only one address for both shipping and billing.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the customers city of resisidence.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'CUSTOMER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the customers ID number.
Qualify: notnull
Physical: CUSTOMER_ID
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'EMAIL
Composition:
Definition:
#Details
DataType: VARCHAR2(80)
Describe: This is the email for the customer. It is obtain from the web and is used to tell the cusomter that an order has been received. I t is also used to tell the customer when a shipment has been made.
Qualify: notnull
Physical: EMAIL
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'FIRST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the first name of a customer.
Qualify: notnull
Physical: FIRST_NAME
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'LAST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the last name of a Customer.
Qualify: notnull
Physical: LAST_NAME
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: This is the telephone number for the customer.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'REGION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the region the customer belongs to. It is used by the warehouse entity so that order filling and shipment is made from the proper warehouse.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the State where the customer lives. In the web application this will be a drop down menu.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the customers Zip code number.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE
Composition:
*AES_EMPLOYEE'EMPLOYEE_ID +
@AES_EMPLOYEE'WAREHOUSE_ID +
AES_EMPLOYEE'FIRST_NAME +
AES_EMPLOYEE'MIDDLE_NAME +
AES_EMPLOYEE'LAST_NAME +
AES_EMPLOYEE'PHONE +
AES_EMPLOYEE'ADDRESS +
AES_EMPLOYEE'CITY +
AES_EMPLOYEE'STATE +
AES_EMPLOYEE'ZIP +
AES_EMPLOYEE'TITLE +
AES_EMPLOYEE'SALARY +
AES_EMPLOYEE'START_DATE
Definition: This is the employee entity which stores all information about the employee.


Employee Infop
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_EMPLOYEE'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the address for each employee.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(49)
Describe: This is the city where each employee lives.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the employee ID
Qualify: notnull
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'FIRST_NAME
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_EMPLOYEE'LAST_NAME
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_EMPLOYEE'MIDDLE_NAME
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_EMPLOYEE'PHONE
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_EMPLOYEE'SALARY
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the employees salary.
Qualify: notnull
Physical: SALARY
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'START_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: This is the employee's start date with the company.
Qualify: notnull
Physical: START_DATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the state that each employee livies in.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'TITLE
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the employee title in the company.
Qualify: notnull
Physical: TITLE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Warehouse ID
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the employee's zip code.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT
Composition:
*AES_EMPLOYEE_COMMENT'EMPLOYEE_COM_ID +
@AES_EMPLOYEE_COMMENT'EMPLOYEE_ID +
AES_EMPLOYEE_COMMENT'COMMENT_DATE +
AES_EMPLOYEE_COMMENT'COMMENTS
Definition: This is the employee_comment entity which stores all information about the employee comments.


Employee Comment Infoh
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" ""

Name: AES_EMPLOYEE_COMMENT'COMMENTS
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: Attribute for storing employee comments.
Qualify: notnull
Physical: COMMENTS
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'COMMENT_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: The date the employee comment was made
Qualify: notnull
Physical: COMMENT_DATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'EMPLOYEE_COM_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The employee comment ID number.
Physical: EMPLOYEE_COM_ID
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The employee ID number.
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY
Composition:
*AES_INVENTORY'INVENTORY_ID +
AES_INVENTORY'AMOUNT_IN_STOCK +
AES_INVENTORY'MAX_STOCKING_LEVEL +
AES_INVENTORY'REORDER_POINT +
AES_INVENTORY'WHY_OUTOF_STOCK
Definition: This is the inventory entity which stores all information about the inventory.


Inventory Infol
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_INVENTORY'AMOUNT_IN_STOCK
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The amount in stock within the warehouse.
Qualify: notnull
Physical: AMOUNT_IN_STOCK
##
References:
ATTRIBUTE

Name: AES_INVENTORY'INVENTORY_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The inventory ID number.
Qualify: notnull
Physical: INVENTORY_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY'MAX_STOCKING_LEVEL
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The amount that is set for the maximum stocking level.
Qualify: notnull
Physical: MAX_STOCKING_LEVEL
##
References:
ATTRIBUTE

Name: AES_INVENTORY'REORDER_POINT
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: What is the oder point for the inventory.
Qualify: notnull
Physical: ORDER_POINT
##
References:
ATTRIBUTE

Name: AES_INVENTORY'WHY_OUTOF_STOCK
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: What is reason we are out of stock.
Physical: WHY_OUTOF_STOCK
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE
Composition:
*AES_INVENTORY_PROFILE'INVENTORY_PROFILE_ID +
@AES_INVENTORY_PROFILE'INVENTORY_ID +
@AES_INVENTORY_PROFILE'WAREHOUSE_ID
Definition: This is the association table between the Inventory and Warehouse tables.


Inventory Association Info
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_INVENTORY_PROFILE'INVENTORY_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the inventory ID number.
Qualify: notnull
Physical: INVENTORY_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE'INVENTORY_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the inventory profile ID number.
Qualify: notnull
Physical: INVENTORY_PROFILE_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Warehouse_ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_ORDER
Composition:
*AES_ORDER'ORDER_ID +
@AES_ORDER'CUSTOMER_ID +
AES_ORDER'ORDER_DATE +
AES_ORDER'ORDER_FILLED
Definition: This is the order entity which stores all information about the customer order.


Order Infon
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" ""

Name: AES_ORDER'CUSTOMER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Customer ID number.
Qualify: notnull
Physical: CUSTOMER_ID
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: This is the date the order was made by the customer.
Qualify: notnull
Physical: ORDER_DATE
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_FILLED
Composition:
[NO|YES|PARTIAL]
Definition:
#Details
DataType: VARCHAR2(8)
Describe: This is a flag used to single how much an order was filled. The flag takes on the values of NO, YES, PARTIAL.
Qualify: notnull
Physical: ORDER_FILLED
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order ID number.
Qualify: notnull
Physical: ORDER_ID
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES
Composition:
*AES_ORDER_LINES'ORDER_LINE_ID +
@AES_ORDER_LINES'ORDER_ID +
@AES_ORDER_LINES'PRODUCT_ID +
AES_ORDER_LINES'QUANTITY +
AES_ORDER_LINES'SELLING_PRICE +
AES_ORDER_LINES'LINE_COST +
@AES_ORDER_LINES'SHIPPING_ID +
AES_ORDER_LINES'SHIPPED
Definition: This is the association table-entity which stores all information about the order_lines.


Line Order Infoc
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" ""

Name: AES_ORDER_LINES'LINE_COST
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the extended cost for each line product/item purchased.
Qualify: notnull
Physical: LINE_COST
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'ORDER_ID
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_ORDER_LINES'ORDER_LINE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order line ID number.
Qualify: notnull
Physical: ORDER_LINE_ID
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'PRODUCT_ID
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_ORDER_LINES'QUANTITY
Composition:
Definition:
#Details
DataType: NUMBER(4)
Describe: This is the quantity that a customer orders for each line product/item.
Qualify: notnull
Physical: QUANTITY
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SELLING_PRICE
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the selling price for each product/item that a customer orders.
Qualify: notnull
Physical: SELLING_PRICE
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SHIPPED
Composition:
[FULL|PARTIAL]
Definition:
#Details
DataType: VARCHAR2(8)
Describe: This is the Shipping States of a Customers order. This is FULL, or PARTIAL.
Qualify: notnull
Physical: SHIPPED
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SHIPPING_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the shipping ID for each complete and partial order that is filled.
Qualify: notnull
Physical: SHIPPING_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT
Composition:
*AES_PRODUCT'PRODUCT_ID +
AES_PRODUCT'PRODUCT_NAME +
AES_PRODUCT'PRODUCT_DESCRIPTION +
AES_PRODUCT'SUGGESTED_PRICE
Definition: This is the product entity which stores all information about the product.


Product Infot
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" ""

Name: AES_PRODUCT'PRODUCT_DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(100)
Describe: This is a description for the product.
Qualify: notnull
Physical: PRODUCT_DESCRIPTION
##
References:
ATTRIBUTE

Name: AES_PRODUCT'PRODUCT_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the product ID.
Qualify: notnull
Physical: PRODUCT_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT'PRODUCT_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(25)
Describe: This is the products name.
Qualify: notnull
Physical: PRODUCT_NAME
##
References:
ATTRIBUTE

Name: AES_PRODUCT'SUGGESTED_PRICE
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This holds the suggested price for a product.
Qualify: notnull
Physical: SUGGESTED_PRICE
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE
Composition:
*AES_PRODUCT_PROFILE'PRODUCT_PROFILE_ID +
@AES_PRODUCT_PROFILE'PRODUCT_ID +
@AES_PRODUCT_PROFILE'WAREHOUSE_ID
Definition: This is the association table between the Product and Warehouse tables.


Product Association Infos
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_PRODUCT_PROFILE'PRODUCT_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the product ID number.
Qualify: notnull
Physical: PRODUCT_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE'PRODUCT_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The product profile ID number.
Qualify: notnull
Physical: PRODUCT_PROFILE_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_SHIP
Composition:
*AES_SHIP'SHIPPING_ID +
AES_SHIP'SHIP_DATE +
AES_SHIP'SHIPPER +
AES_SHIP'COMMENTS
Definition: This is the table-entity ship which stores all information about shipments.


Shipping Infob
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_SHIP'COMMENTS
Composition:
Definition:
#Details
DataType: VARCHAR2(500)
Describe: Comments about the shipping.
Physical: COMMENTS
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIPPER
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the shippers name.
Qualify: notnull
Physical: SHIPPER
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIPPING_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the shp ID number.
Qualify: notnull
Physical: SHIPPING_ID
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIP_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: This is the date the shippment was made.
Qualify: notnull
Physical: SHIP_DATE
##
References:
ATTRIBUTE

Name: AES_SUPPLIER
Composition:
*AES_SUPPLIER'SUPPLIER_ID +
AES_SUPPLIER'SUPPLIER_NAME +
AES_SUPPLIER'REGION +
AES_SUPPLIER'PHONE +
AES_SUPPLIER'ADDRESS +
AES_SUPPLIER'CITY +
AES_SUPPLIER'STATE +
AES_SUPPLIER'ZIP
Definition: This is the table-entity supplier which stores all information about supplier.


Supplier Infoi
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_SUPPLIER'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the suppliers address.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This the suppliers city of resisdence.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: This is the suppliers telephone number.
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'REGION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the region were the supplier is located.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the suppliers state of residence.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'SUPPLIER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the supplier ID number.
Qualify: notnull
Physical: SUPPLIER_ID
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'SUPPLIER_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the suppliers name.
Qualify: notnull
Physical: SUPPLIER_NAME
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This the suppliers zip code.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE
Composition:
*AES_SUPPLIER_PROFILE'SUPPLIER_PROFILE_ID +
@AES_SUPPLIER_PROFILE'SUPPLIER_ID +
@AES_SUPPLIER_PROFILE'WAREHOUSE_ID
Definition: This is the association table between the suplier_profile and Warehouse tables.


Supplier Association Infos
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_SUPPLIER_PROFILE'SUPPLIER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Supplier ID number.
Qualify: notnull
Physical: SUPPLIER_ID
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE'SUPPLIER_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the supplier profile ID number.
Qualify: notnull
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE
Composition:
*AES_WAREHOUSE'WAREHOUSE_ID +
AES_WAREHOUSE'WAREHOUSE_NAME +
AES_WAREHOUSE'REGION +
AES_WAREHOUSE'PHONE +
AES_WAREHOUSE'ADDRESS +
AES_WAREHOUSE'CITY +
AES_WAREHOUSE'STATE +
AES_WAREHOUSE'ZIP
Definition: This is the table-entity warehouse which stores all information about warehouse.


Warehouse Infoi
References:
ERD(ENTITY) "AnnabelleSchoolSupplies.erd" "Main"

Name: AES_WAREHOUSE'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: The address of the warehouse.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the city where the warehouse is located.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: The phone for the warehouse.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'REGION
Composition:
[EASTERN-US|NORTHERN-US|CENTRAL-US|SOUTHERN-US|WESTERN-US]
Definition:
This Attribute is a drop down list that holds the Regions.
#Details
DataType: VARCHAR2(30)
Describe: The region the warehouse is located in.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR(15)
Describe: The state where the warehouse is located.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'WAREHOUSE_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: The name of the warehouse.
Qualify: notnull
Physical: WAREHOUSE_NAME
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the zip for the warehouse.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: ALABAMA
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: ALASKA
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: ARIZONA
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: ARKANSAS
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: CALIFORNIA
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: CENTRAL-US
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: COLORADO
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: Customer_Order
Composition:
Definition:
[Customer] can place many [Order], and an [Order] has but one [customer].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: EASTERN-US
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: Employee_EmployeeComment
Composition:
Definition:
An [Employee] can have many [Employee_Comment], and [Employee_Comment] belongs to one [Empolyee].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: Employee_Warehouse
Composition:
Definition:
An [Employee] works for one [Warehouse], and [Warehouse] can have many [Empolyee].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: etc.
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: FULL
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: InventoryProfile_Warehouse
Composition:
Definition:
A [Inventory_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Inventory_Profile].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: Inventory_InventoryProfile
Composition:
Definition:
[Inventory] can have many [Inventory_Profile], and [Inventory_Profile] has only one [Inventory].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: NO
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: NORTHERN-US
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: OrderLines_Products
Composition:
Definition:
An [0rder-LInes] is made up of one [Product], and a [Product] can be part of many [Order-LInes].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: OrderLines_Ship
Composition:
Definition:
An [Order_Line] can be made up of many [Ship] products, a [Ship] can have one [Order_Lines].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: Order_OrderLines
Composition:
Definition:
An [0rder] can have many [Order_Lines], and an [Order-lines] can have but one [Order].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: PARTIAL
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: ProductProfile_Warehouse
Composition:
Definition:
A [Product_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Product_Profile].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: Product_ProductProfile
Composition:
Definition:
A [Product] can have many [Product_Profile], and [Product_Profile] has only one [Product].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: SOUTHERN-US
Composition:
Definition: This is a drop-down menu item/element.
References: MENU

Name: SupplierProfile_Warehouse
Composition:
Definition:
A [Supplier_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Supplier_Profile].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: Supplier_SupplierProfile
Composition:
Definition:
[Supplier] can have many [Supplier_Profile], and [Supplier_Profile] has only one [Supplier].
References:
ERD(RELATION) "AnnabelleSchoolSupplies.erd" "Main"

Name: WESTERN-US
Composition:
Definition: This is a drop-down menu item/element.
References:MENU

Name: YES
Composition:
Definition: This is a drop-down menu item/element.
References: MENU


Back to Top
Back | Home | Top | Feedback | Site Search


E-Mail Me

This site is brought to you by
Bob Betterton; 2001 - 2011.

This page was last updated on 02/08/2004
Copyright, RDB Prime Engineering



This Page has been accessed " 2033" times.