Express the queries in relational algebra, Database Management System

Assignment Help:

Question:

This question refers to the database schema.

a) Express the following queries in SQL:

(i) Write the SQL code that will create the table Company. Your answer should contain the primary key constraint declaration.

(ii) Having created the table structure in question (i), write the SQL code that will enter the first data row into the Company table.

(iii) Write the SQL code to change the Bank code to 880808 for the company whose CompanyNo is 01.

(iv) Write the SQL code required to list all car details whose manufacturer's name start with the letter ‘M'. In other words, the rows for both Mecerdes and Maserati should be included in the listing.

(v) Write the SQL code that will list the manufacturers of cars with the nationality "Italian" and with an engine size greater than 3500.

(b) Express the following queries in relational algebra.

i.) Find the manufacturers of cars with the nationality "Italian" and with an engine size greater than 3500.

ii.) Find the names, together with the registration number of cars they have on loan, for those drivers who are employed by the company with the bankcode 880513.

iii.) Find the names of those companies who hire all the different models of car manufactured in Italy.


Related Discussions:- Express the queries in relational algebra

What are the different integrity constraints in rdbms, What are the differe...

What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes

Convert encrypted hsql database into csv format, Project Description: We...

Project Description: We have an encrypted HSQL Database which we want to change into csv format. HSQL DB . We have java application (jar file) which reads that database but n

Describe entity referential integrity and integrity, Describe entity refere...

Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

Computing the closure of a set of functional dependency, What is meant by c...

What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

Information system fundamentals, A full discription of the new, a discripti...

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Database for online assignment system, i want to database for online assign...

i want to database for online assignment submission system

Explain current page table and shadow page table, Explain current page tabl...

Explain current page table and shadow page table. The key idea behind the shadow paging method is to maintain two page tables during the life of the transaction: the current pa

Which method is used to key transformation, Which method is used to key tra...

Which method is used to key transformation ? A hash method is used to key transformation.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd