You are required to: Provide a normalized relational logical schema for the same database (NB It is not mandatory to report the restructured ER diagram) Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema solution: AUTHOR( author_id , name, surname)BOOK ( ISBN , title , num_page s , price )CUSTOMER( customer_id , phone_number*, type, name*, surname*, vat_number*)CLERK( clerk_id , name)BUY( customer_id, clerk_id, ISBN )WRITTEN_BY( author_id, ISBN ) 1) WRITTEN_BY (author_id) REFERENCES AUTHOR(author_id) WRITTEN_BY (ISBN) REFERENCES BOOK(ISBN) 2) BUY(customer_id) REFERENCES CUSTOMER(customer_id) BUY (clerk_id) REFERENCES CLERK(clerk_id) BUY (ISBN) REFERENCES BOOK (ISBN) i gave the solution. but i do not have any idea where it came from and how im supposed to formulate a similar solution so please help me understand how was this was reached and how i should solve these type of questions in great detail. will give thumbs up to good answer phone number (0,1) 0NON PRIVATEvat_numbercustomer_idCUSTOMER(t.e)clerk_id(0,N)PRIVATECLERKname(0.N)surnameBUYname(0,N)price num_pagesBOOK(1,N)(1,N)AUTHORauthor_idWRITTEN BYISBNtitlenamesurname

A relational diagram (ERD) can be defined in such a way that it is a visual representation of…

Answered: ou are required to: Provide a…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 7TD: Delete the index named ITEM_INDEX3.

See similar textbooks

Related questions

Concept explainers

Question

You are required to:

Provide a normalized relational logical schema for the same database (NB It is not mandatory to report the restructured ER diagram)
Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema

solution:
AUTHOR( author_id , name, surname)

BOOK ( ISBN , title , num_page s , price )

CUSTOMER( customer_id , phone_number*, type, name*, surname*, vat_number*)

CLERK( clerk_id , name)

BUY( customer_id, clerk_id, ISBN )

WRITTEN_BY( author_id, ISBN )

1) WRITTEN_BY (author_id) REFERENCES AUTHOR(author_id)

    WRITTEN_BY (ISBN) REFERENCES BOOK(ISBN)

2) BUY(customer_id) REFERENCES CUSTOMER(customer_id)

     BUY (clerk_id) REFERENCES CLERK(clerk_id)

     BUY (ISBN) REFERENCES BOOK (ISBN)
i gave the solution. but i do not have any idea where it came from and how im supposed to formulate a similar solution so please help me understand how was this was reached and how i should solve these type of questions in great detail. will give thumbs up to good answer

phone number (0,1) 0
NON PRIVATE
vat_number
customer_id
CUSTOMER
(t.e)
clerk_id
(0,N)
PRIVATE
CLERK
name
(0.N)
surname
BUY
name
(0,N)
price num_pages
BOOK
(1,N)
(1,N)
AUTHOR
author_id
WRITTEN BY
ISBN
title
name
surname

Expert Solution

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions