Design and create a program that will allow a user(s) to maintain collection(s) of something of your choice. See rubric below. The following are the skills that you need to demonstrate: Methods, Arrays, File handling, Searching and Sorting. Your program should be able to do the following: Open and View the collection Add to the collection Search by each of 3 categories Sort by each of 3 categories Create a backup of the collection Delete an entry from the collection Allow multiple users to create other databases as well The database should include at least three characteristics of each entry in the collection, e.g. if your program is storing the names of MP3s in your collection, you might wish to store the title of the song, the artists name, and the songs category (hard rock, soft rock, R & B, Pop, Rap, etc.). Add other useful features to enhance and improve the over-all program and its interface. Level 0 any 3 options work unsatisfactory interface many skills (e.g. arrays, file handling, etc.) absent and/or incorrectly done provide an existing database with 10 entries unsatisfactory program style

Level 1

any 4 options work poor debugging skills poor interface many skills (e.g. arrays, file handling, etc.) absent and/or incorrectly done provide an existing database with 10 entries poor program style

Level 2

any 5 options work inefficient use of some skills (e.g. arrays, file handling, repetition, etc.) fair interface most skills demonstrated provide an existing database with 15 entries fair program style

Level 3

all 7 options work all skill are demonstrated efficient use of most skills including no global variables good interface user friendly provide at least one database with 20 entries good program style

Level 4

all 7 options work efficient use of all skills a clear and efficient method used including no global variables professional interface additional methods used very user friendly provide at least one database with at least 30 entries excellent program style.

For All Levels: Provide a soft copy of your database file

Summative Assignment: Database Application - Algorithm

Prior to starting to write the source code for your Database Application and programming it, you must do a high-level algorithm for your program.

A high-level algorithm is an algorithm that roughly lists the structure of and the steps used by a main program. Details of the sub- programs (methods) to be called by the main program need not be filled in for the high-level algorithm. In order to ensure that the

algorithm is clear however, care must be taken to provide sufficient details about what the input and output to a sub-program are and what the sub-program is expected to do (e.g. call sub-program Sort-by-Artist to sort table by artist name). This algorithm is to be shown to your teacher before beginning any work coding your program.