iLab 3: Database Creation and Table Manipulation
The object of the project is to give you the experience of solving a problem using the programming language of your choice and the MySQL database engine. Your database solution is pretty open ended. The main requirements are that your solution contains at least three tables and all of the data in those tables are manipulated by your programming language.
Listen
Guidelines
Week 1: Determine a Project
Consider a project that might solve a problem. Write a short report defining what the project is and what the problem is that it is designed to solve. The solution database must contain at least three tables. You may manipulate this database with any programming language you desire.
Week 2: Design the Database
Design the database by developing a fully attributed data model. The model should show all tables. Each table should have a primary key and may have foreign keys. Every field in each table should be identified, along with its data type and size.
Week 3: Create the Database
Create the database and associated tables in your database environment.
Week 4: Design the Menu System and Screens
Design the menu screen and all other screens in your application. This will form a major part of your documentation.
Week 5: Connect to the Database
Establish your connection to the database from your programming language. Here you will need to create your database connection string so that your program can access your data.
Week 6: Write the Add/Change/Delete Routines
Write the programs that will allow you to add a record, change a record, and delete a record for each of the tables in your database.
Week 7: Write the Report
Write the program that will allow you to print and/or display the data in each of the tables in your database.
Listen
Grading Rubrics
Category | Points | % | Description |
Determine a Project | 20 | 10 | Write a short, clear report defining what the project is and what problem it is designed to solve. |
Design the Database | 20 | 10 | Develop a fully attributed data model. |
Create the Database | 20 | 10 |
Create the database and associated tables in your database environment. |
Design the Menu System and Screens | 30 | 15 | Design the menu screen and all other screens in your application. |
Connect to the Database | 20 | 10 | Does the application connect to your database? |
Write the Add/Change/Delete Routines | 50 | 25 | Can a user add, change, and delete data in each of your tables? |
Write the Report | 40 | 20 | Can you print and/or display the data in each of the tables? |
Total | 200 | 100 | A quality paper will meet or exceed all of the above requirements. |