Member MemberID Name - Last Name - First Name DOB Borrowed By Checkout Date Checkin Date Book ISBN Title Year Published Published By Publisher PubID Pub_name Written By Author Author ID Name - Last Name - First Name has has Phone PNumber Type
Added by Courtney P.
Close
Step 1
Create the tables for the database. Author (table) Phone (table) Publisher (table) Book (table) Member (table) Show more…
Show all steps
Your feedback will help us improve your experience
Aarya B and 84 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
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. c. Find the highest salary of any instructor. d. Find all instructors earning the highest salary (there may be more than one with the same salary). e. Find the enrollment of each section that was offered in Autumn 2009. f. Find the maximum enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
Sri K.
Consider the University DB with the following relations/tables: Student (studno, name, hons, tutor, year) FK: tutor references Staff (lecturer) Staff (lecturer, roomno) Enrolled (studno, courseno, labmark, testmark) FK: studno references Student (studno) Write queries in relational algebra that return the following: 1) The names of the lecturers who are tutoring a student who had a test mark worse than the lab mark. 2) The names of the lecturers who are tutoring a 3rd year student. 3) The names of the tutors who are tutoring more than one student. 4) The names of the tutors who are tutoring no more than one student.
Shyam P.
A car rental company maintains a database for all vehicles in its current fleet. For all vehicles, it includes the vehicle identification number, license number, manufacturer, model, date of purchase, and color. Special data is included for certain types of vehicles: - Trucks: cargo capacity. - Sports cars: horsepower, renter age requirement. - Vans: number of passengers. - Off-road vehicles: ground clearance, drivetrain (four- or two-wheel drive). Construct an SQL schema definition for this database. Use inheritance where appropriate.
Supreeta N.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD