------------------------------ ------
AUTHOR                         TABLE
BONUS                          TABLE
BOOKS                          TABLE
BOOK_AUTH                      TABLE
CUSTOMER                       TABLE
DEPT                           TABLE
EMP                            TABLE
PUBLISHER                      TABLE
SALES_DETAIL                   TABLE
SALES_MASTER                   TABLE
SALGRADE                       TABLE
STOCK_DETAIL                   TABLE
STOCK_MASTER                   TABLE

SQL> desc author;
 Name                            Null?    Type
 ------------------------------- -------- ----
 A_ID                            NOT NULL VARCHAR2(4)
 AUT_NAME                                 VARCHAR2(15)
 CITY                                     VARCHAR2(15)
 STATE                                    VARCHAR2(15)
 SUBJECT                                  VARCHAR2(10)

SQL> desc book_auth;
 Name                            Null?    Type
 ------------------------------- -------- ----
 B_ID                                     VARCHAR2(4)
 A_ID                                     VARCHAR2(4)
 PHONE                                    NUMBER(7)
 A_EMAIL                                  VARCHAR2(20)


SQL> desc books;
 Name                            Null?    Type
 ------------------------------- -------- ----
 B_ID                            NOT NULL VARCHAR2(4)
 TITLE                                    VARCHAR2(15)
 TYPE                                     VARCHAR2(10)
 EDITION                                  VARCHAR2(10)
 PRINT                                    VARCHAR2(10)
 COPIES                                   NUMBER(5)
 COST                                     NUMBER(6,3)
 P_ID                                     VARCHAR2(4)
 DATE_OF_PUB                              DATE


SQL> desc customer;
 Name                            Null?    Type
 ------------------------------- -------- ----
 C_ID                            NOT NULL VARCHAR2(4)
 C_NAME                                   VARCHAR2(15)
 CITY                                     VARCHAR2(15)
 STATE                                    VARCHAR2(15)
 PHONE                                    NUMBER(7)
 EMAIL                                    VARCHAR2(20)


SQL> desc publisher;
 Name                            Null?    Type
 ------------------------------- -------- ----
 P_ID                            NOT NULL VARCHAR2(4)
 P_NAME                                   VARCHAR2(15)
 CITY                                     VARCHAR2(15)
 STATE                                    VARCHAR2(15)
 PHONE                                    NUMBER(7)
 P_EMAIL                                  VARCHAR2(20)


SQL> desc sales_detail;
 Name                            Null?    Type
 ------------------------------- -------- ----
 T_ID                                     VARCHAR2(4)
 B_ID                                     VARCHAR2(4)
 QUANTITY                                 NUMBER(5)
 PRICE                                    NUMBER(5)

SQL> desc sales_master;
 Name                            Null?    Type
 ------------------------------- -------- ----
 T_ID                            NOT NULL VARCHAR2(4)
 SALES_DATE                               DATE
 C_ID                                     VARCHAR2(4)
 C_NAME                                   VARCHAR2(15)
 TOT_COST                                 NUMBER(6,3)


SQL> desc stock_detail;
 Name                            Null?    Type
 ------------------------------- -------- ----
 T_ID                                     VARCHAR2(4)
 B_ID                                     VARCHAR2(4)
 QUANTITY                                 NUMBER(5)
 RATE                                     NUMBER(6,3)


SQL> desc stock_master;
 Name                            Null?    Type
 ------------------------------- -------- ----
 T_ID                            NOT NULL VARCHAR2(4)
 P_ID                                     VARCHAR2(4)
 T_DATE                                   DATE
 TOT_COST                                 NUMBER(6,3)
