What do you want to Modify?
Which table would you like to modify?
Visitor(
IPAddress
):
Search(
IPAddress, date, time
, keyword):
RegisteredUser(
IPAddress, username
, password, emailAddress, birthName, mailingAddress)
purchases(
IPAddress, username, itemID, confirmationNo, paymentID
, time, date):
purchasableItem(
itemID, title
author, year) :
Book(
itemID, title
, ISBN):
Audiobook(
itemID, title
, narrator):
owns(
itemID, title, publisherName
):
Publisher(
name
, address):
reads(
IPAddress, itemType
):
PaymentMethod(
paymentID
, payType):
Cash(
paymentID, amount
):
Credit(
paymentID, cardNo
, name, expDate, type):
Checking(
paymentID, acctNo, routingNo
, name):
ViewableItems(
itemType
):
Catalog(
itemType, uploaded
):
Journals(
itemType, title, author, volNo
, publisher):
ShortStories(
itemType, title, author
, publisher, year):
listsStories(
uploaded,title,author
):
listsJournals(
uploaded,title,author,volNo
):
listsPurchaseItems(
uploaded,ItemID,title
,author, year):
Change which attribute?
To what value?
By which condition?
Homepage
Search Items
Modify Tables
Add New
Delete