Posts

RDBMS example of many to many relationship

-
Q.).    book ( bno, bname, pubname, price)            Author ( ano, aname)            Relationships between book and author is many to many.          Constraints:-primary key,                                 Aname and pubname should NOT NULL. SQL> select * from book_1;        BNO BNAME                PUBNAME                             PRICE ---------- -------------------- ------------------------------ ----------        101 C++                           nirali                                150   ...
Read more

RDBMS example of book and dept many to one relationship

-
Q.) Book( bno, bname, pudname, price)         Department( dno, dname)         Relationships between book and department is many to one.             Constraints:-primary key,  Price should bo>0. SQL> select * from department_1;     DNO DNAME ---------- ------------------------------        101 computer        102 science        103 arts        104 MBA        105 MSC SQL> select * from books_1;  BNO     BNAME   PUBNAME    PRICE  DNO -------   -------------  ---------------   --------- -------- 201      C++              nirali               150      101 1202    numerical     BPB         ...
Read more