Problem 2: Map the relational schema of Figure 6.14 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make. BOOK Book_id Title Publisher_name BOOK_AUTHORS Book_id Author_name PUBLISHER Name Address Phone BOOK_COPIES Book_id Branch_id No_of_copies BOOK LOANS Book_id Branch_id Card_no Date_out Due_date LIBRARY_BRANCH Branch_id Branch_name Address BORROWER Card_no Name Address Phone Figure 6.14 A relational database schema for a LIBRARY database. • Problem 1: Map the ER model given in the Figure to the corresponding relational model. The ER model is a representation of SHIP TRACKING database. Date Timestamp Time SHIP MOVEMENT Longitude Latitude HISTORY SName SHIP Owner (0,*) Type Tonnage Hull N TYPE SHIP_TYPE StartDate EndDate Name Continent (1,1) HOME PORT VISITS VISITS (0,") N IN PName PORT N ON STATE/COUNTRY Name SEA/OCEAN/LAKE
Problem 2: Map the relational schema of Figure 6.14 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make. BOOK Book_id Title Publisher_name BOOK_AUTHORS Book_id Author_name PUBLISHER Name Address Phone BOOK_COPIES Book_id Branch_id No_of_copies BOOK LOANS Book_id Branch_id Card_no Date_out Due_date LIBRARY_BRANCH Branch_id Branch_name Address BORROWER Card_no Name Address Phone Figure 6.14 A relational database schema for a LIBRARY database. • Problem 1: Map the ER model given in the Figure to the corresponding relational model. The ER model is a representation of SHIP TRACKING database. Date Timestamp Time SHIP MOVEMENT Longitude Latitude HISTORY SName SHIP Owner (0,*) Type Tonnage Hull N TYPE SHIP_TYPE StartDate EndDate Name Continent (1,1) HOME PORT VISITS VISITS (0,") N IN PName PORT N ON STATE/COUNTRY Name SEA/OCEAN/LAKE
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
Related questions
Question
solve this questions for me .
Transcribed Image Text:Problem 2:
Map the relational schema of Figure 6.14 into an ER schema. This is part of a process known
as reverse engineering, where a conceptual schema is created for an existing implemented
database. State any assumptions you make.
BOOK
Book_id Title Publisher_name
BOOK_AUTHORS
Book_id Author_name
PUBLISHER
Name Address Phone
BOOK_COPIES
Book_id Branch_id No_of_copies
BOOK LOANS
Book_id Branch_id Card_no Date_out Due_date
LIBRARY_BRANCH
Branch_id Branch_name Address
BORROWER
Card_no Name
Address Phone
Figure 6.14
A relational database
schema for a LIBRARY
database.
Transcribed Image Text:• Problem 1: Map the ER model given in the Figure to the corresponding relational model. The ER model is
a representation of SHIP TRACKING database.
Date
Timestamp
Time
SHIP MOVEMENT
Longitude
Latitude
HISTORY
SName
SHIP
Owner
(0,*)
Type
Tonnage
Hull
N
TYPE
SHIP_TYPE
StartDate
EndDate
Name
Continent
(1,1)
HOME PORT
VISITS
VISITS
(0,")
N
IN
PName
PORT
N
ON
STATE/COUNTRY
Name
SEA/OCEAN/LAKE
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning