Dbm 380 Database Environment

Words: 820
Pages: 4
Open Document
Database Environment
DBM 380

Database Environment
This paper will describe a database environment within my workplace. Currently I am in the United States Army. We track a lot of data in the unit level for all of soldiers. One of the most key database trackers would be tracking training data. I chose this database because the importance of being able to track this data. Knowing that your soldiers are fully trained is very important in making sure they can succeed on the battlefield. This type of database would allow supervisors to check training stats, get physical training test average, and generate reports to keep track who is due or behind with training requirements.
Due to this having to be a rather large database using …show more content…
It should not be any contrasting colors that will be hard on the eyes. This Database will have a lot of Data Field that will have to be made in order to track important information. It will have to have all the normal stuff like Name, Rank, and social. But it will also need some other important stuff like:
• Weapons Qualification- when the last time a soldier qualified. Also what range did they attend
• Physical Fitness Test Qualification – this will keep soldiers current scores and also you will be able to query an average of the scores.
• Profiles - This will allow any soldier with injury can be tracked. This also important so that you can track how many non-deployable you have. This so important because every unit needs to be at a 90 percent deployment rate.
• Medical Readiness- This block will be able to track another database system call Medpros. It will track the individual soldiers status to ensure he/she meets all medical ready and fit in the case of …show more content…
For example, monthly deployment ready stats have to be given to show the unit readiness to deploy. There should be a Query button to click to generate a report showing what percentage is your medical readiness. It is not good if you let this get under 90 percent. The software will also have the ability to generate an email to the personnel who are out of tolerance. This email could make those who are too lazy to keep track of their own information. This could be a technique to get leadership more engaged in what is going on. Another report that would need to be generated would be who is due Physical Fitness test. This database will have everyone’s scores and the dates of last test. Normally a unit will conduct this test once a month. An easy to click query button would work nice to generate a list of personnel who need to take the test. From the list an email can also be generated to make personnel aware that they will have complete the next physical fitness test. Some may say this is a system of laziness. But look at it of a way to be more
Show More

Related Documents: Dbm 380 Database Environment

Essay about week1individual 1

Database Systems and Their Architecture Design Victoria Thompson April 13, 2015 DBM/380 Instructor Scott Cain Database Systems and Their Architectural Design According to PCMag Digital Group (1996-2015) a database system is defined as "software that controls the organization, storage, retrieval, security, and integrity of data in a database" (para. 1). Database systems consist of the following four components- end users, database application(s),the database management system, and the database…

Words 591 - Pages 3

Questions On Database Design

Week 1 Individual: Database Design Kristin M. Sullivan DBM/380 May 19, 2014 Sandra Graca Database systems are designed to allow developers to create a database, fill it with information and be able to call up that information and change it as necessary. This also allows the user not to worry about data storage and retrieval. Some of the other aspects to database systems are: “User access and security management systems provide appropriate data access to multiple users while protecting…

Words 561 - Pages 3

Data Base Environment

Data Base Environment Paper Patrick Pasquali DBM/380 Kurt Jost October 27th 2014 Database Environment 1 The current database at the school that I work at is in need of a an overhaul that will make it easier to track tablets that need to be fixed, also the parts they need, as well as the locations of tablets. This database is primarily done on in a spreadsheet format that allows for the tracking of all the above mentioned information. The database has been functional for some…

Words 788 - Pages 4

What Is The Database For The Art Museum

Shawn Callaway DBM 380 Database Environment Paper James O’Brien February 16, 2015 Museum Analysis The database for the art museum would be a very simple one that is not too hard to manage or maintain. There are not too many moving parts to complicate the data. When creating this database it is very important to give each piece of artwork a unique identification number. With each piece of art there needs to also be the artist and locations where the art is displayed or stored. With the tracking…

Words 797 - Pages 4

Essay on Database Design

Database Environment Brandon Smith DBM/380 10-8-2012 Kenneth Hoskins Database Environment “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able…

Words 1207 - Pages 5