Develop a simple database of student records, Database Management System

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.

Posted Date: 3/19/2013 6:01:05 AM | Location : United States







Related Discussions:- Develop a simple database of student records, Assignment Help, Ask Question on Develop a simple database of student records, Get Answer, Expert's Help, Develop a simple database of student records Discussions

Write discussion on Develop a simple database of student records
Your posts are moderated
Related Questions
Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Explain the Static or conservative Two Phase Locking: Static (or conservative) Two Phase Locking: In this type of scheme, all the data items are locked earlier than any opera

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.