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 is the function of io/m signal in the 8085, What is the function of IO...

What is the function of IO/M signal in the 8085? It is a status signal. It is used to differentiate among memory locations and I/O operations. When this signal is low (IO/M = 0

Database backup, Discuss the importance and characteristics of database bac...

Discuss the importance and characteristics of database backup and recovery procedures, then describe the actions that must be detailed in backup and recovery plan

ER model, coventions for displaying an ER schema as ER diagram

coventions for displaying an ER schema as ER diagram

Illustrate about the advanced object design, Illustrate about the advanced ...

Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco

Explain the exists and unique functions of sql, Explain the EXISTS and UNIQ...

Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which

Illustrate package classes and associations into models, Package classes an...

Package classes and associations into models  Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part

Why do so various organizations use mysql, Why do so various organizations ...

Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Appointment systems with sms and voice call feedback, Automated system for ...

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

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

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