Attempt 2 Assessment 4Scenario (Part C) Data Dictionary PDF

Preview

Summary

Attempt 2 Assessment 4Scenario (Part C) Data Dictionary...

Description

TABLE: MEMBERS Members ID First Name Last Name Street No Street Name Suburb State Country Gender Credit Card No Password Phone No Email Address

Primary Key Y

Foreign Key

Y

Data Type INT VARCHAR(50) VARCHAR(50) VARCHAR(12) VARCHAR(50) VARCHAR(30) VARCHAR(30) VARCHAR(30) Char(1) INT(16) VARCHAR(12) INT VARCHAR(30)

Default Value Autoinc

M

Null N N N N N N N N N Y N N N

Comments Unique

Unique

TABLE: SELLERS Seller Id Member Id Bank Account No Bank BSB Payment Preference Account Name

Primary Key Y Y

Foreign Key

Data Type INT INT INT INT VARCHAR VARCHAR(50)

Default Value Autoinc

Null N N N N N N

Comments Unique Unique

TABLE: AUCTION Member Id Item Id Bid Time Bid Amount

Primary Key Y Y

Foreign Key

Data Type INT INT TIME MONEY

Default Value

Null N N N N

Comments Unique Unique

TABLE: ITEMS Item Id For Auction Sell It Now Price Winning Bid Is Sold No of Days Auction Start Date Title Description Photo Category Id Seller Id Quantity

Primary Key Y

Foreign Key

Data Type INT VARCHAR(50) MONEY MONEY INT INT(31) DATE VARCHAR(50) VARCHAR(50)

Y Y

INT INT INT

Default Value autoinc

Null

Comments Unique

Unique Cascade Cascade

TABLE: CATEGORY Category Id Unique Category No Category Description Category Name

Primary Key Y

Foreign Key

Data Type INT INT VARCHAR(50) VARCHAR(50)

Default Value

Null N N N N

Comments Unique

TABLE: ITEMS SOLD Transaction Id Item Id Seller Id Mumber Id Quantity

Primary Key Y

Foreign Key Y Y Y

Data Type INT INT INT INT INT(20)

Default Value

Null N N N N N

Comments Unique Cascade Cascade Cascade

TABLE: PAYMENT Payment Id Transaction Id Payment Method

Primary Key Y

Foreign Key Y

Data Type INT INT CHAR(10)

Default Value

PAYPAL

Null N N N

Comments Unique Cascade...