Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Q1. Describe the mapping of the given to the relational database schema.

a) Aggregation
b) Generalization or Specialization
c) Strong or weak entity sets
d) Ternary Relationship

Q2. Consider the given LIBRARY relational schema:

Book (Book_id, Title, Publisher_name)
Book_Authors (Book_id, Author_name)
Publisher (Name, Address, Phone)
Book_copies (Book_id, Branch_id, No_of_copies)
Book_loans (Book_id, Branch_id, Card_no, Date_out, Due_date)
Library_branch (Branch_id, Branch_name, Address)
Borrower (Card_no, Name, Address, Phone)

prepare down the relational algebra expression for the given queries:

a) Determine the number of copies of the book titled TLT owned by library branch whose name is "S"?

b) Determine the number of copies of the book titled TLT owned by each and every library branch?

c) Determine the names of all borrowers who don’t have any books checked out.

d) Determine the book title, the borrower's name, and the borrower's address for each book which is loaned out from branch named "S" and whose Due Date is today.

e) For each and every library branch, determine the branch name and the total number of books loaned from that branch.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M911728

Have any Question? 


Related Questions in DBMS

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Tasks objectives1 manage client-server connections using

Tasks Objectives: 1. Manage client-server connections using RDBMS Net Services 2. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system 3. Manage Redo log inf ...

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

Homeworkunlimited pickers is a group of workers who have

Homework Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from loca ...

Lab manualin this lab you will learn how to use ddl and

Lab Manual In this lab you will learn how to use DDL and Oracle Enterprise server to create user accounts, modify, monitor and delete them. You will take the first look at object permissions in Oracle. The last assignmen ...

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

Prepare a brief report that describes how data warehouses

Prepare a brief report that describes how data warehouses and online transaction processing complement each other. In your report make sure to include the following: • Why do companies use data warehouses? • What are the ...

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro