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 Normalized logical relational schemaEMPLOYEE( CodE, NameE, Qualification*, Type)SEASIDE_RESORT(CodS, NameS, WebPage*)TIME (SDate)WORK_AT (CodE, CodS, SDate, EndDate, JobRole)BEACH_SEAT(CodS, CodBS, sea_distance, CodPR)PRICE_RANGE(CodPR, Amount) Referential integrities1) RELATIONSHIP INBEACH_SEAT(CodS) REFERENCES SEASIDE_RESORT(CodS) 2) RELAZIONE WORK_ATWORK_AT(CodE) REFERENCES EMPLOYEE(CodE)WORK_AT(CodS) REFERENCES SEASIDE_RESORT(CodS)WORK_AT(SDate) REFERENCES TIME(SDate) CodeSNameSO-WebPage(0,1)SDateTIMEQualification.SEASIDERESORT(1,N) EndDate(1,N)>WORK_AT(0,N) JobRoleLIFEGUARD(p.e)EMPLOYEE(0,N) (1,1)INCodeE-O NameECodeBSBEACHSEAT(1,1)HAS_PRICE(0,N)-O sea_distancePRICERANGECodePR-O Amount

Normalization is a process in database design that aims to organize and structure relational…

Answered: Provide a normalized relational logical…

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

Normalized logical relational schema
EMPLOYEE( CodE, NameE, Qualification*, Type)
SEASIDE_RESORT(CodS, NameS, WebPage*)
TIME (SDate)
WORK_AT (CodE, CodS, SDate, EndDate, JobRole)
BEACH_SEAT(CodS, CodBS, sea_distance, CodPR)
PRICE_RANGE(CodPR, Amount)

Referential integrities

1) RELATIONSHIP IN
BEACH_SEAT(CodS) REFERENCES SEASIDE_RESORT(CodS)

2) RELAZIONE WORK_AT
WORK_AT(CodE) REFERENCES EMPLOYEE(CodE)
WORK_AT(CodS) REFERENCES SEASIDE_RESORT(CodS)
WORK_AT(SDate) REFERENCES TIME(SDate)

CodeS
NameSO-
WebPage(0,1)
SDate
TIME
Qualification.
SEASIDE
RESORT
(1,N) EndDate
(1,N)
>WORK_AT
(0,N) JobRole
LIFEGUARD
(p.e)
EMPLOYEE
(0,N) (1,1)
IN
CodeE
-O NameE
CodeBS
BEACH
SEAT
(1,1)
HAS_PRICE
(0,N)
-O sea_distance
PRICE
RANGE
CodePR
-O Amount

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