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 subschema expresses, What subschema expresses ? A subschema expres... What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

Explain interblock gap, Explain Interblock gap? Interblock Gap - A trac... Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

What is meant by functional dependencies, What is meant by functional depen... What is meant by functional dependencies? Consider a relation schema R and α C R and β C R. The functional dependency α ->β  holds on relational schema R if in any legal relati

What is a block and a block number, What is a block and a block number? ... What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

Explain the fourth normal form, Fourth Normal Form (4NF) When attribut... Fourth Normal Form (4NF) When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued d

Determine the advanced modeling concepts, Determine the Advanced modeling c... Determine the Advanced modeling concepts You have to follow some steps for object-oriented design. These steps for OO Design methodology are as follow:  1)  Produce objec

What are composite objects, What are composite objects? Objects that ha... What are composite objects? Objects that have other objects are known as complex objects or composite objects.

What is null, What is NULL? Simply NULL means not in value. What is NULL? Simply NULL means not in value.

Data handling and research methods, Data Handling and Research Methods: ... Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

Data manipulation language, Question 1 Discuss about second normal form an... Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La