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

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 ...

1 draw and explain erm diagram andnbsp explain what is

1. Draw and explain ERM diagram and  explain what is REM 2. Explain what is Normalization . what is 0NF,1NF, 2NFand ,3NF and explain what is in the tables Entity Relationship Modeling and Normalization: 1 System Analysis ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

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 ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Hospital database determining keysdevelop a microsoft

Hospital Database: Determining Keys Develop a Microsoft Access database based upon the following business scenario. Be sure to include tables, fields, keys, relationships, and test data in your database. Your final submi ...

Assignmentthis assignment requires you to design a video

Assignment This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ...

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 ...

Assignmentconsider the employee database with the following

Assignment Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. The list of tables is: Company(cid, company_name, city, state) /* city ...

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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen