Database and Nouns Major Topics
Jorge Santana
IT203 Database Development
Paul Michael Kelly Jr.
03/24/2014
LAB 1
Lab 1.1 – Explore the AdventurWorks Database Using SQL Server Management Studio.
Lab 1.2 – Define Major Topics for a Database
Nouns
Major Topics
Doctors
Doctor’s Information
Patients
Patient’s Information
Drugs
New drug, Prozac
Interviews
Extent of depression, sleeping patterns, activity level, etc.
Check ups
Blood pressure, blood test results, depression indicators, etc.
Lab 1.3 – Create a Statement of Work
Nouns
Major Topics
Faculty Users
Faculty User’s Information
Staff Users
Staff User’s Information
Machine
Machine’s Information
Software
Software license
Scope:
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.
2. 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.
IT203 Database Development
Paul Michael Kelly Jr.
03/24/2014
LAB 1
Lab 1.1 – Explore the AdventurWorks Database Using SQL Server Management Studio.
Lab 1.2 – Define Major Topics for a Database
Nouns
Major Topics
Doctors
Doctor’s Information
Patients
Patient’s Information
Drugs
New drug, Prozac
Interviews
Extent of depression, sleeping patterns, activity level, etc.
Check ups
Blood pressure, blood test results, depression indicators, etc.
Lab 1.3 – Create a Statement of Work
Nouns
Major Topics
Faculty Users
Faculty User’s Information
Staff Users
Staff User’s Information
Machine
Machine’s Information
Software
Software license
Scope:
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.
2. 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.