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 with AI-Powered 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

Economics

Authors: R. Glenn Hubbard

6th edition

978-0134106243

Students also viewed these Programming questions

Question

What reasons may there be for a conglomerate discount existing?

Answered: 1 week ago

Question

Define a traverse in Surveying?

Answered: 1 week ago