Question: Please provide a complete code for creating a database in c++. sql test case In this assignment, you will write a program that allows a

Please provide a complete code for creating a database in c++. Please provide a complete code for creating a database in c++. sql

sql test case

test case In this assignment, you will write a program that allows

In this assignment, you will write a program that allows a database user to manage the metadata of their relational data. By metadata, we mean the database's high-level information (e.g., database's name, creation time, owner) as well as the properties of the tables (e.g., table's names, attributes, constraints). System Design - You are free (in fact, encouraged) to come up with your own design - For instance, Sqlite3 uses one single file for each "database." - Here is one possible design: - One Linux directory > a database O One regular file > a table Implementation - The program should not use an external database library or an existing SQL parser/compiler. - Any programming language is acceptable, e.g., Python, Java, C/C++, Go - Please pick one that you are most comfortable/proficient with - If you want to choose a language not mentioned above, please contact the TA before you start coding - Functionalities: - Database creation, deletion - Table creation, deletion, update, and query Interface - A similar but simpler interface than Sqlite3 - Examples (on a Linux terminal): - \#./> \# CREATE DATABASE db_name >; - The shell should prompt whether the command is successful or failed - If failed, don't crash but gracefully prompt why - Then when you check your file system, it might look like this: - /your_home/cs457/pa1/db_name - \#./> \# USE db_1; CREATE TABLE test_tbl (a1 int, a2 char(9)); - If successful, then your file system might look like this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!