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.

Advantages to copying records from one table to another, What kind of advan...

What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

Sql insert statements, Submit SQL INSERT Statements that will populate the ...

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

Define atomicity and aggregation, Atomicity : Either all functions are lai...

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

Multiple column queries-syntax, Multiple column Queries: Syntax: ...

Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,....  FROM TABLE WHERE );

Need customer management program, Project Description: This is a Custome...

Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Goals, what are the purposes of dbms in details

what are the purposes of dbms in details

Datawarehouse, 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

Determine the benefits of object oriented design, Determine the benefits of...

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

SQL, Ask Write the SQL code that will create the table structure for a tabl...

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Determine the programming language structures, What is the most significant...

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu