Member Avatar for on93 
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) ?

  • 2 Contributors
  • 1 Reply
  • 272 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
happygeek commented: please do not ask the same question all over the forums -2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.