Download
er to relational schemas n.
Skip this Video
Loading SlideShow in 5 Seconds..
ER to Relational Schemas PowerPoint Presentation
Download Presentation
ER to Relational Schemas

ER to Relational Schemas

101 Views Download Presentation
Download Presentation

ER to Relational Schemas

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. ER to Relational Schemas Lab3

  2. Case Study: Internet Shop

  3. Relation Schemas Books (isbn, title, author, qty_in_stock, price, year_published) Customers (cid, cname, address, cardnum) Orders (isbn, cid, qty, order_date, ship_date) isbn is a foreign key that references Books cid is a foreign key that references Customers

  4. Relation Schemas (Modified) Books (isbn, title, author, qty_in_stock, price, year_published) Customers (cid, cname, address, cardnum) Orders (isbn, cid, order-date, qty, ship_date) isbn is a foreign key that references Books cid is a foreign key that references Customers

  5. Relation Schemas (Modified2) Books (isbn, title, author, qty_in_stock, price, year_published) Customers (cid, cname, address, cardnum) Orders (ordernum, isbn, cid, qty, order_date, ship_date) isbn is a foreign key that references Books cid is a foreign key that references Customers