Answered step by step
Verified Expert Solution
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 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 ; 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 column column column respectively.
If the user attempts a table that does not exist, you should print an error message.
Recommended database name: Employeesdatabase
Recommended table name: EmployeesYOEsalary
Recommended column names: employeeid yearsofexperience, salary
QUERY EXAMPLE:
INSERT INTO TABLE EmployeesYOEsalary VALUES
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started