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 data defination language, What is DDL? Make a list of commands with...

What is DDL? Make a list of commands with short description used in DDL Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data struct

Construct a generalization-specialization hierarchy, Construct a generaliza...

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Determine the term- active values, Determine the term- Active values An...

Determine the term- Active values An active value is that has dependent values. Every dependent value registers itself with active value that contains a set of dependent values

What are the concurrency issues, Concurrency issues Data integrity...

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

What is the error handling, What is the error handling Traditionally, b...

What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

What are the benefits of prepared statements, What are the benefits of prep...

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Applications and goals of dbms, What do you mean by DBMS? What is its need ...

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

Table handling, Table Handling  In RDBMS more than one table can be tac...

Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai

Explain disadvantages of a dbms, Question : (a) Database Management Sy...

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

What is a foreign key, What is a foreign key, and what is it used for? ...

What is a foreign key, and what is it used for? A foreign key is used to establish relationships between relations in the relational model. Technically, a foreign key is a colu

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