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

Explain displaying an er schema as an er diagram, Explain the conventions f...

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

Ordering of tuples, In a relation, tuples are not inserted in any definite ...

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

What are the objectives of advance object design, What are the Objectives o...

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo

Explain the disadvantages of file oriented approach, Explain the disadvanta...

Explain the disadvantages of file oriented approach? In the oriented approach Applications are designed in isolation. Design of application is optimized for one application. In

What purpose of tables, What is the purpose of tables, private synonyms and...

What is the purpose of tables, private synonyms and public synonyms? If there are multiple objects of similar name on an Oracle database, that order are they accessed in? The r

What is the highest normal form of the table - normalization, In problems 1...

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE

Dataset, The dataset " CFOLYMPICS.XLS " contains the observations used in t...

The dataset " CFOLYMPICS.XLS " contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purpo

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