Consider the following relational schema:
PERSON (SS#, NAME, ADDRESS)
CAR (REGISTRATION_NUMBER, YEAR, MODEL)
ACCIDENT (DATE, DRIVER, CAR_REG_NO)
OWNS (SS#, LICENSE)

Construct the subsequent relational algebra queries:
(i) Find out the names of persons who are included in an accident.
(ii) Find out the registration number of cars that were not involved in any accident.
Ans: (i) πNAME(PERSON) ∩ πDRIVER(ACCIDENT)
(ii) πREGISTRATION_NUMBER(CAR) - πCAR_REG_NO(ACCIDENT)

Posted Date: 5/10/2013 1:43:19 AM | Location : United States

Ask an Expert

Related Discussions:- Consider relational schema and construct algebra query, Assignment Help, Ask Question on Consider relational schema and construct algebra query, Get Answer, Expert's Help, Consider relational schema and construct algebra query Discussions

Write discussion on Consider relational schema and construct algebra query
Your posts are moderated

Write your message here..

Related Questions

What is the used of specifying alias, What is the used of specifying alias?... What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

Differentiate sub-class and super-class, Differentiate sub-class and super-... Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

Design a gennalization and specialization hierarchy for an a, Design a genn... Design a gennalization and specialization hierarchy for an automobile sales company

Need for multiple access paths, Need for Multiple Access Paths In pract... Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

Explain the project-join normal form, Explain the Project-Join normal form ... Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,

Er diagram, er diagtram for icici er diagtram for icici

Replicating data, Replicating Data One approach that may support effici... Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Draw an er diagram for organization of a student database, Draw an ER diagr... Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Case study, what problems are raised by the database? why is it so controve... what problems are raised by the database? why is it so controversial? why is data quality an issue?

Define the relations as tables in sql, Consider the relations given below ... Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio