Proposed Company Database Record Fields
Proposed Student Database Record Fields
Proposed Database Field Structure
The previous fields and example database structure offer a preview of the types of data fields that will be needed to correctly run the information system correctly. The most important field is that of the key field. This field is a unique field which olds a unique number for each student and company. With this unique field we will be able to give multiple instances for companies and students as well as give each record its own unique identity for query purposes.
The other field names are very verbose and explain themselves briefly while also complying in the naming scheme for oracle. These other fields are necessary for holding such information such as company and student names, addresses, phone numbers, etc.
These
fields are not set in stone and will be discussed with the client and changed
before the final structure is determined.
We will be able to add and or change as many fields as necessary to
satisfy the client.
Design Inventory
.
Alpha testing – an early stage of testing a software program.
Database – a collection of information organized in a way that makes it easier to locate desired pieces.
Debugging – finding and correcting errors in a program.
Digital Foundry – The name of our team, which is developing ScipaNet.
HTML – Hyper Text Markup Language
ITS – Information and Technology Services, the branch of Siena College which is in charge of information technology on campus.
Java Script – A web based scripting language
Normalization – The process of removing redundancies from a Database.
NT Administrator – the member of our team who is responsible for controlling user accounts on our Windows NT computer, they are also responsible for security and networking.
Oracle – A particular brand of Database Management Systems, and also the name of the parent company that makes this brand.
ScipaNet – The name given to the software plan which Digital Foundry is developing for Dr. Lederman
SQL – Structured Query Language, a way of requesting specific information from a database.
Synopsizer – Enables the Coordinator to highlight key words from the Statement of Interest and Project Proposal in order to create a brief profile to make matching easier.
Webmaster – the member of our team that is responsible for making all of our documents accessible through a web page.
Web server – a computer that stores and delivers web pages.