Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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++.
sql test case
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 - \#./>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