Data Storing

You are required to develop a console application using any programming language that you are familiar to store user’s information using linked lists. This application should act like a database. You need to develop: 1- A command line that asks user to type in commands. It should follow the SQL standard syntaxes such as: CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); Your command line would be able to accept these three major commands at least: I. CREATE TABLE: that would be able to create a new table. II. INTSERT INTO: which should able user to insert data into your table. III. SELECT-FROM: to select and display a certain line of data from table. It is clear that your command line need to be aware of available data types and has syntax checking system. In result user would able to type the command and the engine can create table or perform insert or display values functions. Group Assignment 30% Page 2 of 5 2- The engine that can build table using linked lists. The structure of CREATE TABLE in example above would be shown as below: As shown in figure above the engine should be able to create an object of class LIST to represent every column of the table. In this case a table with Five(5) fields would consists of a combination of five linked-list at least. Hint: You may want to define an extra list to keep the value of Current pointer location. You may also need to change the location of current pointer in all lists simultanously in order to display the right information row. REPORT STRUCTURE In the hardcopy of this assignment, you have to write according to the following structure: 1. Cover Page 2. Result  Explanation of your algorithm to approach the solution.  Findings, sample testing and conclusion 3. Source code  Print ALL your coding (Explain details as comments) 4. A copy of marking sheet MUST be included in last page of your report. SUBMISSION INFORMATION  Submission deadline is on Monday Week 12.  Plagiarism will be marked as ZERO for all group members.  This assignment is a group assignment consists of maximum THREE (3) students (no bargaining. If you are Four (4) you should divide in two groups of two).  Students are required to submit the report in hardcopy and the softcopy in CD. The assignment will not be marked if both of softcopy and hardcopy have not been submitted.