Consider relational schema and construct algebra query, Database Management System

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







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
Related Questions
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? 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 automobile sales company

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 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 diagtram for icici

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 that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

what problems are raised by the database? why is it so controversial? why is data quality an issue?

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