-1
SQL> DESC TOPPING;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TOPPINGID                                 NOT NULL NUMBER
 TOPPING                                            VARCHAR2(10)
 TOPPINGTYPE                                        VARCHAR2(5)
 TOPPINGCOST                                        NUMBER(4,2)

SQL> DESC PIZZATOPPING;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PIZZAID                                   NOT NULL NUMBER
 TOPPINGID                                 NOT NULL NUMBER

SQL> DESC PIZZA;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PIZZAID                                   NOT NULL NUMBER
 PIZZANAME                                          VARCHAR2(30)
 BASECOST                                           NUMBER(4,2)

SQL> DESC PIZZAORDER;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ORDERID                                   NOT NULL NUMBER
 CUSTOMERID                                         NUMBER
 PIZZAID                                            NUMBER
 ORDERDATE                                          DATE
 QUANTITY                                           NUMBER

How to draw ER-diagram (TOPPINH , PIZZATOPPING,PIZZA, PIZZAORDER) ?

Votes + Comments
please do not ask the same question all over the forums
2
Contributors
1
Reply
5
Views
5 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.