Provide a normalized relational logical schema for the same database (N.B. It is not mandatory to report the restructured E-R diagram) Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema solution: CUSTOMER(FiscalCode, Name, Surname, Address, LoyaltyCard*, Type) INTOLERANCES(Intolerances, FiscalCode) TICKET(CodS, CodF, Date, FisclaCode, Price) SEAT(CodS, CodF, Class) FLIGHT(CodF, Departure, Arrival, Departure_date, Arrival_date, Airplane_type) Integrity constraints: SEAT(CodF) REFERENCES FLIGHT(CodF) TICKET(CodS, CodF) REFERENCES SEAT(CodS, CodF) TICKET(FiscalCode) REFERENCES CUSTOMER(FiscalCode) i provided the solution but i dont understand where it came from. when do we and when do we not consider the black circles in the diagram and if we do for what and on what basis do we consider them? what is type? what are the references and how do i understand which ones i should take and not? please explain every single detail in the above question alongside the questions i proposed here as i do not understand whatsoever what is happening in this question. thank you and ofcourse i will give thumbs up for good answer. please.let.it.be.detailed.and.significant.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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

solution:

CUSTOMER(FiscalCode, Name, Surname, Address, LoyaltyCard*, Type)

INTOLERANCES(Intolerances, FiscalCode)

TICKET(CodS, CodF, Date, FisclaCode, Price)

SEAT(CodS, CodF, Class)

FLIGHT(CodF, Departure, Arrival, Departure_date, Arrival_date, Airplane_type)

Integrity constraints:

SEAT(CodF) REFERENCES FLIGHT(CodF)

TICKET(CodS, CodF) REFERENCES SEAT(CodS, CodF)

TICKET(FiscalCode) REFERENCES CUSTOMER(FiscalCode)

i provided the solution but i dont understand where it came from. when do we and when do we not consider the black circles in the diagram and if we do for what and on what basis do we consider them? what is type? what are the references and how do i understand which ones i should take and not? please explain every single detail in the above question alongside the questions i proposed here as i do not understand whatsoever what is happening in this question. thank you and ofcourse i will give thumbs up for good answer. please.let.it.be.detailed.and.significant.

Expert Solution

Step by step

Solved in 3 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