1,147
23
Essay, 2 pages (400 words)

Database

Advantages of a database over the Instructor’s current system would be; organization of data Into one location rather than across several spreadsheets, and ease and speed regarding both data storage and retrieval. B) Major topics of the database Include; students, dates attended, assignment and test scores, and overall grades. C) A statement of work for this database may look like the following; History: Historically, student data has been saved across spreadsheets.

However, as time asses, the number of spreadsheet to search for data has increased, making this system cumbersome and unwieldy. Scope: The database will manage student information as It relates to this class. The database shall be large enough to retain Information of students no longer enrolled In the class as well as that of current students. The Information will be private, accessible to only the Instructor.

The Instructor will be able to generate reports based on the data retrieved Objectives: * Create a more intuitive system for the instructor to store, search for, and retrieve tuned data * The new system should have enough fields so that it can store student’s names/personal information, their grade, the dates they were enrolled for at least five years, and still allow for the addition of new students. * Data must be retrievable by either using student name, last 4 of student social security number, or dates. Tasks and deliverables: 1 . Gathering data, interview with instructor, review current data on spreadsheets.

Time allotted: 3 days 2. Analyzing data, preliminary considerations for database Truckee/model based upon study of current system. Time allotted: 1 week 3. Building the database, data model translated to READS, creation of tables with specific data types, relations and constraints defined. Time allotted: 2 days Deliverables: ” working” database for review 4. Testing, Sample data will be entered into the database, data storage, retrieval, and security will be tested. Test results will be documented Time allotted: 1 week Deliverables: Test results 5.

Completion/lamentation, changes made as necessary, sample data removed, database Installed on Instructor’s workstation. Time allotted: 5 days Deliverables: working database Questionnaire for college help desk database users: 1 . Will you require service technician’s access to the database in order to update the status of work orders? 2. Do you require a method of listing work orders closed/ completed by date? 3. Should help desk customers have limited access to the database via work order number in order to rate service as (UN)satisfactory. 4. Should help desk solutions be stored as searchable by FAQ to help address future issues?

Thank's for Your Vote!
Database. Page 1
Database. Page 2
Database. Page 3

This work, titled "Database" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Database'. 30 September.

Reference

AssignBuster. (2022, September 30). Database. Retrieved from https://assignbuster.com/database-essay-samples-6/

References

AssignBuster. 2022. "Database." September 30, 2022. https://assignbuster.com/database-essay-samples-6/.

1. AssignBuster. "Database." September 30, 2022. https://assignbuster.com/database-essay-samples-6/.


Bibliography


AssignBuster. "Database." September 30, 2022. https://assignbuster.com/database-essay-samples-6/.

Work Cited

"Database." AssignBuster, 30 Sept. 2022, assignbuster.com/database-essay-samples-6/.

Get in Touch

Please, let us know if you have any ideas on improving Database, or our service. We will be happy to hear what you think: [email protected]