Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use c code : A database management system manages different databases. A database consists of multiple tables, each table has multiple columns. All columns in

use c code : A database management system manages different databases. A database consists of multiple tables, each table has multiple columns. All columns in a table have a common number of rows. Each row has a unique id number. For the stored data in a given column, each entry has the row id number as an identifier. A user may insert a new row in a table.
Create the structs for the database, table, and column. For each of these structs, include an id element and a name of 20 characters at most. A database should point to its tables and each table should point to its database. Each table should point to its columns and each column should point to its table. For simplicity, consider that all columns contain integers only and that the maximum number of rows in a column is 100; Create one database only, then create one table only in that database. Let the user be able to insert a new entry in that table by entering the following sentence:
INSERT INTO TABLE VALUES
Where is replaced by the table name created earlier, ,, are the values stored in column1, column2, column3,..., respectively.
If the user attempts a table that does not exist, you should print an error message.
Recommended database name: Employees_database
Recommended table name: Employees_YOE_salary
Recommended column names: employee_id, years_of_experience, salary
QUERY EXAMPLE:
INSERT INTO TABLE Employees_YOE_salary VALUES 122498

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Android 4 Application Development

Authors: Reto Meier

3rd Edition

1118223853, 9781118223857

More Books

Students also viewed these Programming questions

Question

Are summer stipends available?

Answered: 1 week ago

Question

Explain the steps involved in training programmes.

Answered: 1 week ago

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

What is a manufacturing system?

Answered: 1 week ago

Question

Given and find P(AB). If, further, are A and B independent?

Answered: 1 week ago