Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109

    Unanswered: Is It Enough Give Me Idea

    here is the tables for the lms library management systems any one give me the idea how to make my system more gud so please give me the suggestion and your comments to make it more reliable do i have enter more columns and other to make it good



    PHP Code:
    CREATE TABLE B_DETAILS(
    B_ID             NUMBER(5PRIMARY KEY,
    B_NAME             VARCHAR2(50NOT NULL,
    B_AUTHOR        VARCHAR2(30NOT NULL,
    B_COMPOSER        VARCHAR2(30NOT NULL,
    B_CATEGORY        VARCHAR2(30NOT NULL,
    B_DETAILS        VARCHAR2(100NOT NULL,
    B_I_DATE            DATE
    B_L_DATE            DATE,
    B_P_DATE            DATE,
    B_PRICE            NUMBER(5NOT NULL,
    B_STAT            VARCHAR2(1NOT NULL );

    -------------------------------------------------

    CREATE TABLE EMPLOYEE(
    E_ID        NUMBER(5PRIMARY KEY,
    E_NAME        VARCHAR2(40NOT NULL,    
    E_NIC        NUMBER(14NOT NULL,
    E_EMAIL        VARCHAR2(30),
    E_CELL        VARCHAR2(11NOT NULL,
    E_PHONE        VARCHAR2(11),
    E_ADDRESS    VARCHAR2(100NOT NULL,
    E_SALARY    NUMBER(5NOT NULL,
    E_STAT        VARCHAR2(1));

    -------------------------------------------------

    CREATE TABLE P_READERS(
    P_ID        VARCHAR2(5PRIMARY KEY,
    P_NAME        VARCHAR2(40NOT NULL,    
    P_NIC        NUMBER(14NOT NULL,
    P_SEX        VARCHAR2(5NOT NULL,
    P_M_STATUS    VARCHAR2(8NOT NULL,
    P_EMAIL        VARCHAR2(30),
    P_CELL        VARCHAR2(11),
    P_PHONE        VARCHAR2(11),
    P_ADDRESS    VARCHAR2(100NOT NULL,
    P_C_BOOK     VARCHAR2(50));

    -------------------------------------------------

    CREATE TABLE BCATEGORY(
    C_NAME    VARCHAR2(30NOT NULL);

    ---------------------------------------------------
    CREATE TABLE U_LOGIN(
    U_ID        NUMBER(4PRIMARY KEY,
    U_NAME        VARCHAR2(30NOT NULL,
    U_PASS        VARCHAR2(20NOT NULL,
    U_STAT        VARCHAR2(1NOT NULL );

    --------------------------------------------------- 

  2. #2
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109
    Also give me the idea where do i have make primary and foreign key also and point out pl/sql tutorials also;;;;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •