Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if itis available in the library. For each borrowing, the borrowing and return dates are registered in the database.Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {'F' or 'M'})Book (ISBN:long Title:string (unique), Author:string)BorrowedItems(stSID:long, book|SBN:long, serialNo:int (unique), BorrowingDate:date, ReturnDate:date)Write SQL statements to:1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN.2. List SID, Name, and Major of all female students doing major in CS'and their name starts with 'S'.For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

SELECT ISBN, Title, AuthorFROM BookWHERE (Title LIKE…

1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in CS' and their name starts with 'S'. For the toolbar, press ALT+F10 (PC) or ALT+FN+F1O (Mac)

1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in CS' and their name starts with 'S'. For the toolbar, press ALT+F10 (PC) or ALT+FN+F1O (Mac)

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

FUNDAMENTAL DATABASE SUBJECT: Case: A car wash owner wants to monitor the inventory of products and sales of the business. Create a database design in preparation for a system development that would: Store and monitor the supply of products; The number of vehicle washed by a car wash boy. Vehicles can be classified according to its type (motorcycle, van, bus, etc.). The list of vehicles washed by a car wash boy can be monitored. Salary per employee and the vehicles washed can be retrieved. Car wash history per vehicle can be check also. We already Identified the possible tables, so your task will be: 1. Add data on the tables (assume that this is not normalized yet) 2. reflect on the table and follow the normalization steps base on the rules. 3. normalize its table 4. add all table in one document (lucidchart/google docs), should have relationships and cardinality. 5. make sure that it is in highest normal form, highest will be BCNF (if needed).
Software Engineering The recruitment agency TEMPO proposes internship employees for enterprises for a periodof time. An internship employee is a temporary employee that will be recruited for a periodof time. You must develop a database application in order to satisfy these specifications: The enterprises (id, name, address and phone number) define the posts for which theyneed one or many employees. A post is defined with a label, a daily remuneration, thestart date, the end date and the number of employees for this post. A post needseventually diploma(s) and a list of many skills. An internship employee is described by a ssn, first name, last name, an address, aphone number, his/her diplomas (we store for each diploma the year when it isobtained) and his/her skills. An employee could be recruited for one or many posts. This recruitment of anemployee for a given post is validated by a chief (ssn, first name, last name, address)designated by the enterprise. This chief is unique to an…
DATABASE: library (library_name [pk], City, Phone, manager_SSN[pk, fk]) book (book_name [pk], Genre, Country) borrower (SSN[pk], Name, Birthyear, Fav book [fk], Gender) likes (SSN[pk, fk], book [pk, fk]) bookLoans (library [fk], books [fk]) manager (SSN[pk], Name, City, Address, Phone) Provide OPTIMIZED relational algebra for the following queries: 1 a) List name, gender, and age of all borrowers. b) List all male borrowers older than 65 years of age. c) List the book names loaned by at least one library and liked by at least one borrower. d) List the name and ssn of all borrowers who like their favorite book
Data base systmes: Design an ER schema diagram for a sport league database to keep track of the teams and games of it. The database is organized into teams. Each team has a unique name, a unique number, and particular colors. A team may have several colors. Each team plays several games. It is desired to keep track of the result of each game. A team has a number of players, not all of whom participate in each game. Each player has a unique name, a unique number, and a particular position. It is desired to keep track of the players participating in each game for each team, the performance they played in that game, and the time played by each player in each game.
c# Create a small Sports database with two tables: Team and Athlete. The Team table should include fields for the type of team (e.g., basketball), coach's name (both last and first), and the season the sport is most active (S for spring, F for Fall, or B for both). The Athlete table should include fields for student number, student first and last names, and type of sport. Use the same identifier for type of sport in both tables to enable the tables to be related and linked. Populate the tables with sporting teams from your school. Write a C# program that displays information about each team, including the names of the athletes. The data base we have provided to us just need to know how to program it in with the other guidelines given.
Suppose in a movie database, a movie is identified by id, name, year and ratings where a movie might have a sequel. [Example: Mission: Impossible 2 is a 2000 American action spy film. This movie is sequel to 1996 film Mission: Impossible]. Movies are casted by actors where an actor has specific role [Example: MI 2 is starred (i.e., main character) by Tom Cruise] and an actor is identified by id, firstname, lastname and gender. A movie might have multiple genres [Example: MI 2 is characterized by three genres: Action | Adventure | Thriller]. A director who directs a movie is identified by id, firstname and lastname. We assume a movie can have at-most one director. [Example: John Woo is the director of MI 2 and he also directed well-known movies like 'A better tomorrow', 'Red Cliff', ‘Hard Boildeď’, ‘Face/Off'] Draw ER diagram with proper notation.
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. List all copies of the book title “Lord of the Rings” that are available for borrowing. List the names of borrowers who currently have the book title “Lord of the Rings” on loan. List the names of borrowers with overdue books.
Database Question:In this problem, you will come up with decision trees to predict if a planet is habitable based only on features observed by the telescope.In the table below, you are given the data from all 800 planets surveyed so far. The features observed by telescope are Size (“Big” or “Small”), and Orbit (“Near” or “Far”). Each row indicates the values of the features and habitability, and how many times that set of values was observed. So, for example, there were 20 “Big” planets “Near” their star that were habitable.Determine if Planet=Big and Orbit=Far is habitable? Derive and draw the decision tree learned by ID3 on this data.
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra and tuple relational calculus: 5.27 List all copies of book titles that are available for borrowing. 5.28 List all copies of the book title “Lord of the Rings” that are available for…
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. a. List all copies of the book title “Lord of the Rings” that are available for borrowing. b. List the names of borrowers who currently have the book title “Lord of the Rings” on loan. c. List the names of borrowers with overdue books.
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra and tuple relational calculus: a. List all book titles. b. List all borrower details. c.List all book titles published in the year 2012. d. List all copies of book titles that are…
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra only. a. How many copies of ISBN “0-321-52306-7” are there? b. How many copies of ISBN “0-321-52306-7” are currently available c. How many times has the book title with ISBN…