EMPLOYEE_PAY_TBL

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Appendix D.  CREATE TABLE Statements for Book Examples


 CREATE TABLE EMPLOYEE_PAY_TBL  (EMP_ID              VARCHAR(9)        NOT NULL    primary key, POSITION            VARCHAR(15)       NOT NULL, DATE_HIRE           DATE, PAY_RATE            DECIMAL(4,2), DATE_LAST_RAISE     DATE, SALARY              DECIMAL(8,2), BONUS               DECIMAL(6,2), CONSTRAINT EMP_FK FOREIGN KEY  (EMP_ID) REFERENCES EMPLOYEE_TBL (EMP_ID)); 

Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net