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