Database
LP1_William_Norris Chapter 1 Practice question # 10 a) 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 passes, 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 student 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 structure/model based upon study of current system.
Time allotted: 1 week 3. Building the database, data model translated to RDBMS, creation of tables with specific data types, relations and constraints defined.
Time allotted: 2 days
Deliverables: “working” database for review 4. Testing,
History:
Historically, student data has been saved across spreadsheets. However, as time passes, 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 student 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 structure/model based upon study of current system.
Time allotted: 1 week 3. Building the database, data model translated to RDBMS, creation of tables with specific data types, relations and constraints defined.
Time allotted: 2 days
Deliverables: “working” database for review 4. Testing,