Member Avatar for Mallika_2 
create table customer
(
  cname char(20) not null,
  street char(30),
  city char(30),
  primary key(cname)
)
  create table branch
  create table account
(
  bname char(15) not null,
  bcity char(30),
  assets integer,
  primary key(bname),
  check(assets>0)
)
(
account # char(10) not null,
    (
        bname char(15),
        balance integer,
        primary key(account#)
        forigen key (bname) reference branch,
        check(balance>0)
    )
)
  • 2 Contributors
  • 1 Reply
  • 28 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by pritaeas
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.