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

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

Salaries for database administrators database

SALARIES FOR DATABASE ADMINISTRATORS Database administrators (DBAs) are among the highest paid professionals in the information technology field. Many people work for 10 to 20 years to get a promotion to DBA. Connect to ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Homeworkgiven the relations below answer the following

HOMEWORK Given the relations below, answer the following queries using SQL. Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. MEMB ERS ME ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Unlimited pickers is a group of workers who have joined

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 location to l ...

  • 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