Computer Science, asked by Adarsh671, 9 months ago

Consider an online bookstore OLTP model with the entities and attributes as follows.

Publisher(PUBLISHER_ID, NAME)

Subject(SUBJECT_ID, NAME)

Author(AUTHOR_ID, NAME)

Publication(PUBLICATION_ID, SUBJECT_ID (FK), AUTHOR_ID (FK), TITLE)

Edition(PUBLISHER_ID (FK), PUBLICATION_ID (FK), PRINT_DATE, PAGES, PRICE, FORMAT)

Review(REVIEW_ID, PUBLICATION_ID, (FK), REVIEW_DATE, TEXT)

Draw the equivalent OLAP Conceptual model, Logical model, and Physical data model.

Answers

Answered by ıtʑFᴇᴇʟɓᴇãᴛ
0

tex

bold

Publisher(PUBLISHER_ID, NAME)

Subject(SUBJECT_ID, NAME)

Author(AUTHOR_ID, NAME)

Publication(PUBLICATION_ID, SUBJECT_ID (FK), AUTHOR_ID (FK), TITLE)

Edition(PUBLISHER_ID (FK), PUBLICATION_ID (FK), PRINT_DATE, PAGES, PRICE, FORMAT)

Review(REVIEW_ID, PUBLICATION_ID, (FK), REVIEW_DATE, TEXT)

Similar questions