Develop a simple database of student records, Database Management System

Assignment Help:

In this programming assignment, you will develop a simple database of student records. Here are the requirements:

1) A student record contains a name and a number. We assume that all the student numbers different. You should use struct data type for student records.

2) The database uses a list data structure.

3) The following four operations over the database should be supported by the application.

a. The application can read a student record from the user and add the record into the database.

b. The application can read a student number from the user, search the database using the student number, and display the student name in the found student record.

c. The application can read a student number from the user, search the related student record in database using the student number, and delete the student record from the database. You should note that the record to be deleted can be anywhere in the database.

d. The application can list all the student records in the database.

4) The application should use a text-based user interface to get commands from the user, which use the four operations in 3).

5) You should not assume that only a fixed number of student records can be added into the database. The database should be able to dynamically shrink or grow with the user commands, such as, 3.a and 3.c.

When you test the application, you should add at least 5 student records first, test all the other database operations, add 5 more student records again, and test all the other operations again. You should use the user interface, not hard coded test statements.


Related Discussions:- Develop a simple database of student records

Concatenation operator-data manipulation language, Concatenation operator ...

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Attributes and tuple, Before we talk about the relational model in more det...

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

What is a cascading update, What is a cascading update? Referential int...

What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar

I want a professional with strong it background, I want a professional with...

I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

Pl/SQL, I need solution of the question posted at http://www.expertsmind.c...

I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

What is a database graph, What is a database graph? The partial orderin...

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

ER diagram, Construct a clean ans concise ER diagram for the database indic...

Construct a clean ans concise ER diagram for the database indicating the cardinality mapping for Employee management syatem

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS...

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

What are the types of storage devices, What are the types of storage device...

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd