How to define a structure with tag name car_table, Database Management System

Assignment Help:

QUESTION

(a) Consider a car database consisting of car model, car make, car origin, Engine capacity, color, cost.

                                              186_table.png

                                                                            Fig

Using this car database, illustrate the process of

(i) How to define a structure with tag name car_table.

(ii) How to declare an array of structures with the following

                                          variables car[1], car[2] and car[3].

(iii) How to enter the values in the table for the three cars. (Tips: use a FOR loop)

(iv) How to change the color of car2 from blue to black and display the new color.

(v) How to increase the cost of car 3 by 10 % and display the new cost.

(b) Using function write a C/C++ program to take two arrays of integer numbers and multiply each corresponding values and put the result in a third array.

Sample arrays and values are provided in Fig 2.

                                                     359_table2.png

                                                                                              Fig 2


Related Discussions:- How to define a structure with tag name car_table

Differentiate between natural join and outer join, Differentiate between na...

Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

Write short notes on data ware housing, Write short notes on data ware hous...

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Oracle SQL Developer, Introductory course and so does not require any fancy...

Introductory course and so does not require any fancy coding. I will provide a guidance document to help you in producing the solutions.

Purchase orber , Run the following queries. For each query show 1) What yo...

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c

A file manipulation command that extracts some records, A file manipulation...

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

Query, Use a Set operator to create a list of academics who have written or...

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Define lock, Define lock? Lock is the most common used to execute the r...

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Which operation is used if we are interested certain columns, Which operati...

Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

Keys, #questiontypes of keys examples..

#questiontypes of keys examples..

Differentiate between a unique key and a primary key, Differentiate between...

Differentiate between a unique key and a primary key. - By default, clustered index on column are created by primary key while nonclustered index are created by unique key.

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