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

Physical model of traffic data management, After the completion of the logi... After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i

View serialiabilty-labelled precedence graph, how to construct labelled pre... how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

Transactions and concurrency management, Transactions And Concurrency Manag... Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Explain the disadvantages of file oriented approach, Explain the disadvanta... Explain the disadvantages of file oriented approach? In the oriented approach Applications are designed in isolation. Design of application is optimized for one application. In

Explain the exec statement in sql, Explain the Exec statement in SQL An... Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

Determine the three views of data, Determine the Three Views of Data We... Determine the Three Views of Data We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed alrea

Dataset, The dataset " CFOLYMPICS.XLS " contains the observations used in t... The dataset " CFOLYMPICS.XLS " contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purpo

Write short notes on index structure of files, WRITE SHORT NOTES ON INDEX S... WRITE SHORT NOTES ON INDEX STRUCTURE OF FILES? There are two basic parts of indices 1.   Ordered indices 2.   Hash indices Every technique must be evaluated on the bas

Describe the four main ways of optimising disk block access, Describe the f... Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

Types of locks, Types of Locks There are two necessary types of locks: ... Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc