All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Search
Search
Sign In
Register
study help
computer science
database systems design implementation
Questions and Answers of
Database Systems Design Implementation
A module can be considered a(n) object or unit that can be combined or bound together to form a application.a. Dependent, big and complexb. Dependent, small and easierc. Independent, big and
Explain the advantages of using the NetBeans Module for Java project development.
Provide a brief discussion of Apache NetBeans Platform.
Provide a brief description of the Apache NetBeans Open Source IDE.
Refer to Section 5.3.2, and build a similar Java Ant application named SumTwoNumbers with the following functions:a) Build a GUI by adding a JFrame Form with two TextFields, Num1Field and Num2Field;
How do you normally define security? How is your definition similar to or different from the definition of database security?
Problem 1 is based on the DDBMS scenario in Figure P12.1.Specify the minimum types of operations the database must support to perform the following operations. These operations include remote
How do NewSQL databases compare to NoSQL databases in terms of consistency, availability, and partition tolerance?
As a discipline, data visualization can be studied as _________________ used to explore and discover data insights by applying: _________________, _________________, and _________________.
Using a simple example, explain the use of binary and shared/exclusive locks in a DBMS.
What is a lock, and how does it work in general?
What two courses of action are available to a designer who encounters a multivalued attribute?
How is a relationship between entities indicated in an ERD? Give an example using the Crow’s Foot notation.
Beverage Buddy (BB) is a diabetes-friendly mobile app to track and share beverage information with friends. BB tracks data about teas, coffees, and other drinks to help individuals with diabetes
Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number.
Generate a listing of all purchases made by the customers, using the output shown in Figure P7.11 as your guide. Sort the results by customer code, invoice number, and product description. Figure
Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should retrieve the assignment number, employee number, project number, the stored assignment charge
Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. The subtotal is a derived attribute
Write a query to count the number of customers with a balance of more than $500.
Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals (as calculated in Problem 12) for each customer.
Create a query to produce the total purchase per invoice, generating the results shown in Figure P7.16, sorted by invoice number. The invoice total is the sum of the product purchases in the LINE
Use a query to show the invoices and invoice totals in Figure P7.17. Sort the results by customer code and then by invoice number. Figure P7.17 Invoice Totals by Customer CUS_CODE INV_NUMBER
Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. Figure P7.21
Create a query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.22. Figure P7.22 Balance
Find the listing of customers who did not make purchases during the invoicing period. Sort the results by customer code. Your output must match the output shown in Figure P7.23. Figure P7.23 Balances
Create a query that summarizes the value of products currently in inventory. Note that the value of each product is a result of multiplying the units currently in inventory by the unit price. Sort
Write a query to display the SKU (stock keeping unit), description, type, base, category, and price for all products that have a PROD_BASE of Water and a PROD_CATEGORY of Sealer (Figure P7.28).
Write a query to display the first name, last name, and email address of employees hired from May 1, 2011, to December 31, 2012. Sort the output by last name and then by first name (Figure P7.29).
Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2021, and July 31, 2021. If a
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name
Write a query to display the number of products in each category that have a water base, sorted by category (Figure P7.35). Figure P7.35 Number of Water-Based Products in Each Category PROD CATEGORY
Write a query to display the number of products within each base and type combination, sorted by base and then by type (Figure P7.36). Figure P7.36 Number of Products of Each Base and Type PROD_BASE
Write a query to display the total inventory—that is, the sum of all products on hand for each brand ID. Sort the output by brand ID in descending order (Figure P7.37). Figure P7.37 Total Inventory
Write a query to display the department number and most recent employee hire date for each department. Sort theoutput by department number (Figure P7.39). Figure P7.39 Most Recent Hire in Each
Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made
Write a query to display the current salary for each employee in department 300. Assume that only current employees are kept in the system, and therefore the most current salary for each employee is
Write a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee number, employee first name, employee last
Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.
Write a query that displays the first and last name of every patron, sorted by last name and then first name. Ensure the sort is case insensitive (Figure P7.57). Figure P7.57 All Patron Names PAT
Write a query to display the checkout number, checkout date, and due date for every book that has been checked out sorted by checkout number (Figure P7.58). Figure P7.58 All Checkouts CHECK NUM CHECK
Write a query to display the different years in which books have been published. Include each year only once and sort the results by year (Figure P7.60). Figure P7.60 Unique Book Years BOOK
Write a query to display the book number, title, and cost of each book sorted by book number (Figure P7.62). Figure P7.62 Title and Replacement Cost for Books BOOK NUM 5235 Beginner's Guide to
Write a query to display the different subjects on which FACT has books. Include each subject only once and sort the results by subject (Figure P7.61). Figure P7.61 Unique Book Subjects BOOK
Write a query to display the checkout number, book number, patron ID, checkout date, and due date for every checkout that has ever occurred in the system. Sort the results by checkout date in
Write a query to display the book title, year, and subject for every book. Sort the results by book subject in ascending order, year in descending order, and then title in ascending order (Figure
Write a query to display the book number, title, and cost for all books that cost $59.95 sorted by book number (Figure P7.65). Figure P7.65 Books That Cost $59.95 BOOK_NUM BOOK_TITLE 5235 Beginner's
Write a query to display the book number, title, and replacement cost for all books in the “Database” subject sorted by book number (Figure P7.66). Figure P7.66 Database Books BOOK
Write a query to display the checkout number, book number, and checkout date of all books checked out before April 5, 2021 sorted by checkout number (Figure P7.67). Figure P7.67 Checkouts before
Write a query to display the book number, title, and year of all books published after 2015 and on the “Programming” subject, sorted by book number (Figure P7.68). Figure P7.68 Newer Books on
Write a query to display the book number, title, subject, and cost for all books that are on the subjects of “Middleware” or “Cloud,” and that cost more than $70, sorted by book number
Write a query to display the author ID, first name, last name, and year of birth for all authors born in the decade of the 1980s sorted by author ID (Figure P7.70). Figure P7.70 Authors Born in the
Write a query to display the book number, title, and subject for all books that contain the word “Database” in the title, regardless of how it is capitalized. Sort the results by book number
Write a query to display the patron ID, first and last name, and patron type for all patrons whose last name begins with the letter “C,” sorted by patron ID (Figure P7.73). Figure P7.73 Patrons
Write a query to display the author ID and first and last name of all authors whose year of birth is unknown. Sort the results by author ID (Figure P7.74). Figure P7.74 Authors with Unknown Birth
Write a query to display the author ID and first and last name of all authors whose year of birth is known. Sort the results by author ID (Figure P7.75). Figure P7.75 Authors with Known Birth
Write a query to display the checkout number, book number, patron ID, checkout date, and due date for all checkouts that have not yet been returned. Sort the results by book number (Figure P7.76).
Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name
Write a query to display the number of books in the FACT system (Figure P7.78). Figure P7.78 Number of Books Number of Books 20
Write a query to display the number of different book subjects in the FACT system (Figure P7.79). Figure P7.79 Number of Different Subjects Number of Subjects
Write a query to display the number of books that are available (not currently checked out) (Figure P7.80). Figure P7.80 Number of Books Not Currently Checked Out Available Books 14
Write a query to display the highest book cost in the system (Figure P7.81). Figure P7.81 Most Expensive Book Price Most Expensive 129.95
Write a query to display the lowest book cost in the system (Figure P7.82). Figure P7.82 Least Expensive Book Price Least Expensive 49.95
Write a query to display the number of different patrons who have ever checked out a book (Figure P7.83). Figure P7.83 Different Patrons to Check Out a Book DIFFERENT PATRONS 33
Write a query to display the subject and the number of books in each subject. Sort the results by the number of books in descending order and then by subject name in ascending order (Figure P7.84).
Write a query to display the author ID and the number of books written by that author. Sort the results in descending order by number of books, then in ascending order by author ID (Figure P7.85).
Write a query to display the total value of all books owned by the library (Figure P7.86). Figure P7.86 Total of All Books Library Value 1499
Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is the difference from the date on which the book is returned to the date it was checked out.
Write a query to display the patron ID, patron full name, and patron type for each patron sorted by patron ID (Figure P7.88). Figure P7.88 Patron and Patron Type PAT_ID Patron Name 1160 robert
Write a query to display the book number, title with year, and subject for each book. Sort the results by the book number (Figure P7.89). Figure P7.89 Book Title with Year BOOK NUM 5235 Beginner's
Write a query to display the author last name, author first name, and book number for each book written by that author. Sort the results by author last name, first name, and then book number (Figure
Write a query to display the author ID, book number, title, and subject for each book. Sort the results by book number and then author ID (Figure P7.91). (25 rows) Figure P7.91 Authors of Books AU_ID
Write a query to display the author last name, first name, book title, and replacement cost for each book. Sort the results by book number and then author ID (Figure P7.92). (25 rows) Figure P7.92
Write a query to display the patron ID, book number, patron first name and last name, and book title for all currently checked out books. (Remember to use the redundant relationship described in the
Write a query to display the patron ID, full name (first and last), and patron type for all patrons. Sort the results by patron type and then by last name and first name. Ensure that all sorting is
Write a query to display the book number and the number of times each book has been checked out. Do not include books that have never been checked out. Sort the results by the number of times checked
Write a query to display the author ID, first and last name, book number, and book title of all books in the subject “Cloud.” Sort the results by book title and then by author last name (Figure
Write a query to display the book number, title, author last name, author first name, patron ID, last name, and patron type for all books currently checked out to a patron. Sort the results by book
Write a query to display the book number, title, and number of times each book has been checked out. Include books that have never been checked out. Sort the results in descending order by the number
Write a query to display the book number, title, and number of times each book has been checked out. Limit the results to books that have been checked out more than five times. Sort the results in
Write a query to display the author ID, author last name, book title, checkout date, and patron last name for all the books written by authors with the last name “Bruer” that have ever been
Write a query to display the patron ID and first and last name of all patrons who have never checked out any book. Sort the result by patron last name and then first name (Figure P7.101). Figure
Write a query to display the patron ID, last name, number of times that patron has ever checked out a book, and the number of different books the patron has ever checked out. For example, if a given
Write a query to display the average number of days a book is kept during a checkout (Figure P7.103). Figure P7.103 Average Days Kept Average Days Kept 4.44
Write a query to display the patron ID and the average number of days that patron keeps books during a checkout. Limit the results to only patrons who have at least three checkouts. Sort the results
Write a query to display the book number, title, and cost of books that have the lowest cost of any books in the system. Sort the results by book number (Figure P7.105). Figure P7.105 Least Expensive
Write a query to display the book number, title, subject, average cost of books within that subject, and the difference between each book’s cost and the average cost of books in that subject. Sort
Write a query to display the author ID and first and last name for all authors who have never written a book with the subject Programming. Sort the results by author last name (Figure P7.106). Figure
Use the Ch08_AviaCo database shown in Figure P8.35 to work Problems 35–46. Modify the MODEL table to add the attribute and insert the values shown in the following table. Table P8.35 Attribute
Write a query to display the book number, title, subject, author last name, and the number of books written by that author. Limit the results to books in the Cloud subject. Sort the results by book
Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject (Figure P7.109). Figure P7.109 Lowest and Highest Average Subject
List and discuss the four individual transaction properties.
Showing 200 - 300
of 292
1
2
3