Consider the following ER diagram that represents a Library Management System. Convert this ER diagram into a relational schema? Publisher PK ID Name PhoneNumber Book Author PK ISBN PK ID Publish Title Write Author Genre Name Nationality {Awards} Patron ID PK ID DueDate Borrow OverDue Name MemberType
Added by Misty F.
Close
Your feedback will help us improve your experience
Supreeta N and 88 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Consider the following ER-Diagram of a LIBRARY which is used to keep track of books, borrowers, and book loans. Convert the given ER-Diagram to an equivalent Relational Schema. Show Primary keys and Foreign keys in the resulting schema.
Supreeta N.
How to Translate the following ER-diagram into relational schema? report code name DEPARTURE AIRPORT Leg AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG M N ARRIVAL AIRPORT CAN LAND N Instances LEGS Number type name Max_seats INSTANCE_OF Airline Arr_time N (Weekdays Company FLIGHT AIRPLANE TYPE DEPARTS ARRIVES Restrictions ARE Dep_time TYPE N Amount FARE Airplane_id Total_no_of_seats No_of_avail_seats AIRPLANE N ASSIGNED LEG INSTANCE Date Customer_name Cphone Seat_no RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight. A LEG_INSTANCE is a particular occurrence of a LEG on a particular date. SEAT Figure 3.21 An ER diagram for an AIRLINE database schema.
Akash M.
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
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD
