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

Data Relation diagram, Can you assist me in Database management system? I n...

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...

Define a property that is not a property of transactions, Define a property...

Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions

Name the three major database in oracle, Name the three major set of files ...

Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

ER diagrams, explain exhaustively the problems associated with ER diagrams....

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

What is sql, What is SQL, and why is it important? SQL stands for Struc...

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm

What is null, What is NULL? Simply NULL means not in value.

What is NULL? Simply NULL means not in value.

List two restrictions that are applied on the modification, List two restri...

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Data warehouse, 1) Define a job scheduling strategy that will meet business...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

What is system r?what are its two major subsystems?, System R was develop...

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

Keys, #questiontypes of keys examples..

#questiontypes of keys examples..

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