Question: Consider the below schema for a library database. Author(authorname, citizenship, birthyear) Book(isbn, title, authorname) Topic(isbn, subject) Branch(libname, city) For each of the following Relational Algebra

Consider the below schema for a library database.

Author(authorname, citizenship, birthyear)

Book(isbn, title, authorname)

Topic(isbn, subject)

Branch(libname, city)

For each of the following Relational Algebra queries, write in English what they mean.

  1. authorname (birthyear>1940 (Author)) (0.25 mark)

Answer:

  1. libname (city=Sydney (Branch)) (0.25 mark)

Answer:

title (subject=alcohol OR subject=drugs (Book Topic))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

INTRODUCTION TO DATABASE (IT244) ASSIGNMENT 1 (LAST DATE TO SUBMIT: 20/02/2016) Q1: Consider the below schema for a library database and write relational algebra expressions for the following queries...

Q:

Q1: Consider the below schema for a library database and write relational algebra expressions for the Following 1. Author ( authorname, citizenship, birthyear) 2. Book (isbn, title, authorname) 3....

Q:

Consider the Bellow schema for a library database and write relational algebra expressions for the following queries Author (authorname, citizenship, birthyear) Book(isbn title, authorname)...

Q:

Q1: Consider the Bellow schema for a library database and write relational algebra expressions for the following queries 1-Author ( authorname, citizenship, birthyear) 2-Book(isbn, title, authorname)...

Q:

Problem 5.1 Consider the AlRLINE relational database schema described below. Schema 1. AIRPORT (Airport_Code. City, State, Name) 2. AIRPLANE_TYPE(Airplane type name, Company, Max_Seats) 3....

Q:

Consider the following relational database for the GBP case. Green Book Publisher (GBP) wants to maintain data about its authors, the books, editorial staff, and their work for the books. Each author...

Q:

What is the purpose of normalisation ? What problems does normali- sation gets rid of? When is it used? Consider the relational schema R with key ( a, b, c ) and no alternative keys. Below all its...

Q:

1. Consider a database schema consisting of two relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) The Product relation gives the manufacturer, model number...

Q:

sql (1) Consider a relational schema R(A, B, C, D, E) and the following set of functional dependencies valid in the schema List all minimal keys valid in the schema. List all derivations of function...

Q:

PART II - Relational Algebra Queries Consider the relational schema below and answer the next 6 questions. PK stands for primary key, and FK for foreign key. Not all the schema is shown, but you do...

Q:

Abbey Products Company is studying the results of applying factory overhead to production. The following data have been used: estimated factory overhead, $60,000; estimated materials costs, $50,000;...

Q:

A study reported in The New England Journal of Medicine revealed surprisingly large differences in rates of lung cancer among smokers of different races.14 For each group, the study reported a rate...

Q:

The broad term for the risk that a misstatement occurs, is not prevented or detected by the cllent's internat control, and is not detected by the audit team's substantive procedures is audit risk.

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

It contained the correct shower gels, but not the correct body lotions. Instead of Jasmine and Ocean Mist, you received Country Rose and Citrus Breeze. File an e-mail claim with Soft n Glow, your...

Q:

You work for a company that owns several office buildings in your town. Your employers have decided to change all locks in their buildings from key to card access. Notify the tenants of each building...

Q:

For the past six years, Jet Printing has had a display at the regional business expo. Because booth spaces are assigned on a first-come, first-served basis, you always reserve your space and send...