Questionthink following relational schema for a

Assignment Help Computer Engineering
Reference no: EM13348575

Question

Think following relational schema for a library-

member(memb_no,name,dob)
books(isbn,title,authors,publisher)
borrowed(memb_no,isbn,date)

Write following queries in relational algebra.

a. discover names of members who have borrowed any book published by "McGraw-Hill".

b. discover the names of members who have borrowed all book published by "McGraw-Hill".

c. discover the name and membership number of members who have borrowed more than 5 books published by "McGraw-Hill".

d. discover the name and membership number of members who have borrowed more than 5 different books of that publisher.

Reference no: EM13348575

Questions Cloud

Question 1a an interrupt triggers a number of events both : question 1a an interrupt triggers a number of events both in processor hardware and in software. discuss about the
Question1hadicke company purchased a delivery truck for : question1.hadicke company purchased a delivery truck for 44000 on 1st january 2012. the truck was assigned an evaluated
Questionthis program will permit the user to keep track of : questionthis program will permit the user to keep track of a cd or dvd collection. this can only work exclusively with
Questionpropose a broad audit plana what material kinds of : questionpropose a broad audit plana. what material kinds of transactions and transaction cycles are involved?b. what
Questionthink following relational schema for a : questionthink following relational schema for a
Question 1wedge corporation uses a discount rate of 14 and : question 1wedge corporation uses a discount rate of 14 and has a tax rate of 30. the subsequent cash flows occur in the
Questiona process is a program under execution and as it : questiona process is a program under execution and as it executes it changes state. the state of a process is defined
Question1 universities are typically organized by : question1. universities are typically organized by departments or colleges such as business biology engineering
Questiona what is compensation expense related to the stock : questiona. what is compensation expense related to the stock option plan in fiscal 2008b. what would the effect on cash

Reviews

Write a Review

Computer Engineering Questions & Answers

  D flip-flops

Using three D flip-flops,a multiplexer,decoders and gates, construct a 3-bit Gray code counter that has two inputs: reset, which sets the counter to 000, and inc, which makes the counter go to the next value in the sequence.

  Assess the security risks

As part of your project in order to assess the security risks in order to compute the infrastructure, you have discovered that other managers often have several ideas on the severity and levels of the risk.

  Program is re-written so it requires less memory

Cache misses are classified into one of three categories - compulsory, capacity, or conflict.

  What are the reasons for such a recommendation

One of business' contemporary principles states that organizations must move away from few top leaders and many managers to leaders at every level and few managers.

  Design a class for services offered by a hair-styling salon

The Curl Up and Dye Salon offers a variety of salon services for its customers. Jane Fields, owner, has contracted to have you write a program that allows reports to be output, sorted by each kind of service offered. Table below shows the various ..

  What are outputs and inputs to schedule control

What are the SMART criteria? What are the 5key points of using project milestones.

  Plan a network diagram for the tasks

imagine you have a project with seven activities Labeled A-G, as shown below. Derive the earliest completion time (or early finish time - EF), the latest completion time (or late finish - LF) and slack for each of the following tasks (begin at tim..

  Find whether the numbers would be an arithmetic

assume you are given a list of n integers in random order. Describe an algorithm that will determine whether the numbers would be an arithmetic progression if they were sorted.

  Database management

Additionally to limiting the actual tables or columns that a user has access to, you may also limit what the user does. Specify some of the ROLES you could allocate to the users and what would these roles do?

  Create a patient class for the wrightstown hospital billing

Create a Patient class for the Wrightstown Hospital Billing Department. Include a patient ID number, name, age, and amount due to the hospital. Include properties and any other methods you need. Override the ToString() method to return all the det..

  What are the types of new ethernet equipment

An older network using 10baseT technology needs an upgrade. The network contains a total of 220 workstations and 10 servers and has a network diameter of 300 meters. What type of new Ethernet equipment would you suggest be purchase to modernize th..

  Write a function that creates a cell and structure array

Write a function that creates a cell and structure array.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd