Project Part 1 ER Diagram1) Word (Product Activation Failed) FILE HOME INSERT DE

Question

Project Part 1 ER Diagram1) Word (Product Activation Failed) FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW s Cut Ph Find ? Replace Select- Copy Paste Blu. aicx, x' A.?.?. :??,-. ?Norrmal" No Spac Heading 1 Heading 2 Title Subtitle subtle Erm Emphasis Format Painter Font Paragraph Styles Editing STUDENT StudentID Name Address City State 2ipCode PhoneNumber Email BUYER SELLER BuyeriD SellerlD BPUB CHECK BookID BuyeriD DateSold BookID BSN Title Edition Author UNIVERSITY IBSN CourselD DateReceived PAGE 1 OF 1 49WORDS + 100% rP ?9??Qs 4/16/2018 245 PM O Type here to search ?

Explanation / Answer

Entity name

Entity discription

Column name

Column description

Data type

Length

Primary key

Nullable

Unique

Student

Student is a class which stores all the details about the student

StudentID

integer

10

True

False

true

Name

varcha

20

false

false

false

Address

varchar

50

false

false

false

City

varchar

15

false

false

false

State

varchar

15

false

false

false

Zipcode

varchar

10

false

false

false

PhoneNumber

integer

15

false

False

true

Email

varchar

30

false

False

true

Buyer

All the list of buyers

BuyerID

varchar

10

true

false

true

Seller

List of Sellers

SellerID

varchar

10

true

false

true

Check

BookID

varchar

10

true

false

false

BuyerID

varchar

10

true

false

false

DateSold

date

-

false

false

false

PurchaseAmount

float

5,2

False

False

false

Bpub

BookID

varchar

10

true

false

True

ISBN

Varchar

20

false

false

true

Title

varchar

10

false

false

false

Edition

integer

5

false

false

false

Author

Text

20

DesiredPrice

float

5,2

University

University is defined by its IBSN and it contains all the details of university

IBSN

Varchar

20

true

false

true

CourseID

varchar

20

false

false

true

Distributer

Books distributer details

DistributerID

varchar

20

true

false

true

Name

Text

25

false

false

False

Address

varchar

50

false

false

False

City

varchar

15

false

false

False

State

varchar

15

false

false

False

Unsold books

All the unsold books

BookID

varchar

20

true

false

true

PickUpDate

Date

-

false

False

false

Sold Books

Details of sold books

BookID

varchar

20

true

false

true

SellingPrice

float

5,2

false

False

false

Unretrieved

BookID

varchar

20

true

false

true

Retrieved

BookID

varchar

20

true

false

true

Entity name

Entity discription

Column name

Column description

Data type

Length

Primary key

Nullable

Unique

Student

Student is a class which stores all the details about the student

StudentID

integer

10

True

False

true

Name

varcha

20

false

false

false

Address

varchar

50

false

false

false

City

varchar

15

false

false

false

State

varchar

15

false

false

false

Zipcode

varchar

10

false

false

false

PhoneNumber

integer

15

false

False

true

Email

varchar

30

false

False

true

Buyer

All the list of buyers

BuyerID

varchar

10

true

false

true

Seller

List of Sellers

SellerID

varchar

10

true

false

true

Check

BookID

varchar

10

true

false

false

BuyerID

varchar

10

true

false

false

DateSold

date

-

false

false

false

PurchaseAmount

float

5,2

False

False

false

Bpub

BookID

varchar

10

true

false

True

ISBN

Varchar

20

false

false

true

Title

varchar

10

false

false

false

Edition

integer

5

false

false

false

Author

Text

20

DesiredPrice

float

5,2

University

University is defined by its IBSN and it contains all the details of university

IBSN

Varchar

20

true

false

true

CourseID

varchar

20

false

false

true

Distributer

Books distributer details

DistributerID

varchar

20

true

false

true

Name

Text

25

false

false

False

Address

varchar

50

false

false

False

City

varchar

15

false

false

False

State

varchar

15

false

false

False

Unsold books

All the unsold books

BookID

varchar

20

true

false

true

PickUpDate

Date

-

false

False

false

Sold Books

Details of sold books

BookID

varchar

20

true

false

true

SellingPrice

float

5,2

false

False

false

Unretrieved

BookID

varchar

20

true

false

true

Retrieved

BookID

varchar

20

true

false

true

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.