A library catalog system must be designed to store and maintain data on books in a library. The system must be able to track titles, authors, ISBNs, publishers, subjects, and publication dates.
The library database should track information on books, patrons, and checkouts. For books, this includes the title, author, and ISBN. For patrons, this includes the name, address, and phone number. For checkouts, this includes the Patron ID, Book ID, Checkout date, and Due date.
This technical problem deals with designing a social network database schema that includes posts, comments, and likes. The input is a set of CREATE TABLE statements for the three tables, and the output is sample data for those tables.
Given a table of data with employee IDs, names, and salaries, write a SQL query to find the highest paid employee.
This technical problem involves designing a database to store information about a library's patrons, books, and checkout transactions. The database should be able to track patron information (name, ID, address, phone number, date of birth), book information (title, author, ISBN), and checkout information (checkout date, return date, overdue status).
Write a SQL query to find the top 5 most expensive items in the "Electronics" category.
The problem asks for a design of a database to store employee information. The input provides an example of the data that would be stored in the database, and the output shows an example of how the data might be organized in a table.
This technical problem asks the reader to design a database for tracking information about a company's employees. The example input provides a table with four columns: employee_id, name, department, and salary. The example output is the same as the input.