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

Assignment topic, assume we have the following apllicationthat model sccer ...

assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture

Describe object relational model, Describe Object Relational model ? O...

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

Distributed query and transaction processing, a.  Construct a query around ...

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

What is hashing file organization, What is hashing file organization? ...

What is hashing file organization? In the hashing file organization, a hash function is computed on some attribute of every record. The result of the hash function specify in

Process of implementing system design in dynamic models, Process of impleme...

Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:

Three levels of ANSI-SPARC architecture, a need some real life examples of...

a need some real life examples of database management systems three level of ANSI SPARC architecture life teacher and student ,company and employee or for NGO etc.

Describe the different raid levels, Describe the different RAID levels.  Di...

Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa

How to design a formal and exact model, How to design a formal and exact mo...

How to design a formal and exact model How to design a formal and exact model of real-world problems by applying findings of analysis phase of OMT. The object design phase find

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