Difference between revisions of "Redesigning Patent Database"
ShelbyBice (talk | contribs) |
|||
| Line 3: | Line 3: | ||
|Has title=Redesigning Patent Database | |Has title=Redesigning Patent Database | ||
|Has owner=Shelby Bice | |Has owner=Shelby Bice | ||
| − | |Has start date= | + | |Has start date=201701 |
| − | |Has | + | |Has deadline=201705 |
|Has keywords=Database, Patent | |Has keywords=Database, Patent | ||
|Has notes= | |Has notes= | ||
| − | |Has project status= | + | |Has project status=Active |
|Is dependent on= | |Is dependent on= | ||
|Depends upon it= | |Depends upon it= | ||
Revision as of 12:46, 2 March 2017
Documentation on the process and eventual designs for the new patent database.
| Redesigning Patent Database | |
|---|---|
| Project Information | |
| Project Title | Redesigning Patent Database |
| Owner | Shelby Bice |
| Start Date | 201701 |
| Deadline | 201705 |
| Keywords | Database, Patent |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Contents
Redesigning Patent Database
Description
The purpose of this project is to create a new, redesigned database to hold all of the patent information that the McNair Center has accumulated and document the process so that the design can be easily understood and replicated or edited as needed.
This database will include design patents, utility patents, and reissues.
Development
Design will be built upon a relational database model. I will be referencing this article on database design as I develop the design (http://en.tekstenuitleg.net/articles/software/database-design-tutorial/one-to-many.html), and I will be creating an ER diagram.
Current Design and Scripts information
The scripts for querying data for the patent database exist in McNair/software/scripts/patent. If the design for the schema of the database tables are altered too much, may have to write new scripts.
