Database and Nouns Major Topics
In Grandfield College, the Software-Tracking database will be used to help in managing the school’s software licensing. The software will be watched for lifecycle and version corrections as well as keeping track of the number of users accessing the software under the constraints of the license agreement. The faculty and staff computers will be followed for which version and licensed copy of software is presently running on each system. Objectives: 1. Have a better system by allowing employees to see the shared calendars and student’s grades.
Advance the tracking of Software Licensing and the Lifecycle of programs. Preliminary timeline: 1. Gathering Data: Meet with School Board and those involved to discuss the needs and wants for a database. 2. Analyzing Data: The information gathered from the meeting will be analyzed and form a rough draft of the database model. 3. Normalization: The database model will be completed and all last minute changes adjusted and any lasting questions answered. 4. Building the physical database: The database model will be constructed into the actual database program. Lab 1. 4 – Challenge Activity 1. There could be more than one Joe Smith entered into the database and info between the two could be confused. Misspelling could occur. 2. The relational database could assign a unique identifier to an entry and any changes to customer info could be managed in one area. 3. The biggest drawback is the chance of a misspelling after the fifth entry (for example) creating a whole new customer data file for an existing entity. 4. I would create at least three tables one for customer info, one for customer payments, and one that shows all payment info.