Er to relational schemas
Download
1 / 6

ER to Relational Schemas - PowerPoint PPT Presentation


  • 76 Views
  • Uploaded on

ER to Relational Schemas. Lab3. Case Study: Internet Shop. 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' ER to Relational Schemas' - shelby-hensley


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


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


Relation schemas
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


Relation schemas modified
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


Relation schemas modified2
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