Description Data Type Format Range Label

1154 Words5 Pages
Attribute Name Description Data type Format Range Label Table: Employee EmpNum Unique Employee ID Varchar2(4) L999 E001-E999 PK, Emp_pk EmpFName First name Varchar2(15) LL..LL EmpLName Last name Varchar2(15) LL..LL CommissionRate Commission Rate Number(2,2) 99.99 0-40 YrlySalary Annual salary Number(8,2) 999999.99 0-200,000 DepID Employee’s Department Varchar2(4) L999 D01-D99 FK, Emp_dept_fk JobID Job ID Varchar2(4) L999 J01-J99 FK, Emp_job_fk Table: Invoice InvNum Unique ID Number(6) 999999 0-999999 PK, Inv_pk InvDate Date of invoice Date dd:mm:yyyy EmpNum Employee associated with the invoice Varchar2(4) L999 E001-E999 FK, Inv_emp_fk InvAmount Total amount Number(8,2) 999999.99 0-999999.99 CustomerID Customer Varchar2(4) L999 C001-C999 FK, Inv_cust_fk Table: InvoiceLine InvLineNum Line number of the invoice Number(2) 99 0-99 PK, InvLine_pk InvNum Unique ID for the invoice Number(6) 999999 0-999999 PK, InvLine_pk ProductNum Product ID Varchar2(4) L999 P001-P999 FK, InvLine_prod_fk Quantity Quantity of each product Number(4) 9999 1-9999 Table: Product ProductNum Unique ID for each product Varchar2(4) L999 P001-P999 PK, Prod_pk ProductDes Description of the product Varchar2(40) LL..LL ProductCost Cost price of the product Number(8,2) 999999.99 0-999999.99 Table: Department DepID Unique ID for each department Varchar2(4) L999 D001-D999 PK, Dept_pk DepDes Name of the department Varchar2(30) LL..LL Table:

More about Description Data Type Format Range Label

Get Access