UMBC logo

CMSC 461, Database Management Systems, Fall 2018

 

Project Report Final Phase (50 points) Due Mon 5/14/2018 at 11:59 PM


Please submit this phase using Blackboard.

THE PROJECT DESCRIPTION

Please refresh your mind regarding project policies by reading the syllabus.

This is final phase of our project (except for the research component). You will write code to correspond with the functional requirements. See the full project description for more details.

Please refer to the UI Requirements Page for User Interface Requirements.

NOTES: YOUR CODE MUST RUN SUCCESSFULLY OR YOU WILL LOSE CREDIT.

In this phase you will write python scripts or use a python notebook to program the modules and use some form of a UI, at a minimum a command line program, to access the modules that you have developed. You are not required to write any additional code that does not directly satisfy the functional requirements. For example, you do not have to write a login module, just assume the user for each of the modules.

In this phase you will also write queries to satisfy the Query/Report section of the project description. Provide a way for a user to select a report number through your interface. Display the results of the query in your python code as a table.

Additional indexes should be created when necessary and justified in the final report.

Also, create a .sql file that contains all of the queries that support the Query/Report section, correspond them to the numbers outlined in the Queries and Reports section.

For example:

/*1. List the details of students attending 'UMBC'.*/
Your query here.

Don't forget to populate your database with the provided data.

You will also create a final report in this phase which describes your application, libraries used, new indices added, and any other information that conveys the work you have put forth in this phase. Please include screen shots of your user interface modules with descriptions of each. This will be a substantial report, submitted as a PDF.

What you will submit in this phase:

  1. Python code for your Book Fetch application
  2. A PDF file that contains your final report and screen shots of your user interface modules (including descriptions)
  3. A .sql file that contains all of the queries that support the Query/Report section
  4. All of your sql scripts to generate the database and populate the tables
  5. **Everything you submitted in previous phases**