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

Referential integrity constraint - relational constraints, It defines that ...

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Define two-phase locking protocol, Define two-phase locking protocol. A...

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Read-set(t) and timestamps-optimistic concurrency contents, read-set(T) : E...

read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Define the concept of object diagram, Define the concept of Object Diagram ...

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

Project on designing and creating a database , This project will involve de...

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

What is data model explain object and data base models, What is data model?...

What is data model? Explain object based and record based data models? Ans: A data model is an abstract model in which describes how data is represented and accessed. (i)

Explain transaction manager and their work, Explain Transaction manager and...

Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

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