UMBC logo

CMSC 461, Database Management Systems, Fall 2018

 

Project Report Phase 4 (40 points) Due Mon 4/30/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.

YOU ARE NO LONGER REQUIRED TO SUBMIT SCREENSHOTS for phase 4. Instead, please submit in detail how you plan to support the various user interfaces. Describe which language or framework you will use, how you will support the user interaction given the language or framework.

For example:
"I plan to use web pages for my user interfaces using Django. I plan to have drop down menus which will provide the values the user can select to submit a form. For example, the create student rating page will have a drop down of book titles and the use can then select the title and provide a rating. This would then activate my Python script that would then update my database by inserting a new record into my book_rating table."

User the following document to help you with writing this report.

This is also the physical design phase of the project. You will create the actual database in this phase.

Implement your tables, constraints (at least 5 constraints (THAT DOES INCLUDE FOREIGN KEY CONSTRAINTS OR NOT NULL)), indexes, etc. in MySQL.

YOU SHOULD HAVE A MINIMUM OF 3 INDEXES (THAT DO NOT INCLUDE PRIMARY or FOREIGN KEYS)

You will need to generate scripts to maintain your database. Generate the following: Table creation (including constraints) script Table drop script Index creation script Index drop script Data insertion script Data deletion script You will also submit a user interface design which can include a written description of each interface, screenshots, handwritten pictures or graphical pictures. If "user interface design" sounds strange and scary, read the following Wikipedia page to understand better.

Please submit the scripts portion of this phase as separate ".sql" files. See below for script requirements.

Generate the following:

  1. Table creation (including constraints) script
  2. Table drop script
  3. Index creation script
  4. Index drop script
  5. Data insertion script
  6. Data deletion script
You will also include in the report a justification of your design choices. You may wish to change the design at this point, as you create the tables, make sure you indicate why in the report.

Your design should still satisfy the user requirements for Book Fetch.

What you are to submit:

  1. The scripts as .sql files
  2. Written report justifying your design choices and describing how you will implement your user interface design. (PDF format)
  3. Phase 3 diagram

[1] Abraham Silberschatz, Henry H. Korth, and S. Sudarashan, Database System Concepts, Sixth Edition, McGraw-Hill. ISBN-13: 978-0073523323 ISBN-10: 0073523321, website: http://www.db-book.com