Database Task 1 UNIT 10 Lukasz Gorniak Overview
Database Task 1 UNIT 10 Lukasz Gorniak
Overview of the Employees database Employment database is some think incredible of employees because they can store all the information about the workers in one place and access many information about such as name, address phone number etc. The main purpose of this kind of database is to keep information of enrolment of the workers in one place and stored safely those database can hold many information and save them for example if you pay your workers by hours you can use cloaking in and out system and then those information are saved in database this helps the employment to keep track of the hours of his workers that’s just one of many example how database can work for employees.
How the Employees would use Keep track of people hours Personal information address name phone number etc. Enrolment new workers Payroll
What are the constraints of Employees database the database One of the constraints of having database could be training each staff member to have know aged how to use database this can be expensive for small firms. Other constraints might be you might need constant access to internet and computer to access the database. The good thinks about database are they can be access any where if you have right access to then for example internet connection and your authorised to do so.
Why would it improve productivity One of the improvement of productivity could be have more trained staff in using database. Other improvement is that its stored in cloud instead of having every think in paper that could be lost or destroyed and not have record of that worker when now every think is sorted digitally.
Overview of the police database The police has database available to all police forces and criminal justice agencies. The police forces can you use that database to get personal information about the persona there are checking. The database can hold information such as if the persona has been convicted of crime before his basic information such as address name surname etc. The police forces can update any information at any time. They also are using them to track criminals and solve cases.
Why would it improve productivity The police database can improve productivity of police forces by a lot because they have access to many useful information right away about the person. This can save time so police forces can focus on some think else then looking up information all day.
How the police would use ? The police can use database in many ways and they have more then one database is well. One way they can use it is by cheeking some one crime history after just typing there name in the database it will show them every think about that person age name surname address what kind licenses he holds etc. They use it to get information about people or properties and many more things like cars basic they have all kind different records in there database. They can check history of any person, car motorbike right away just from typing correct information in to database it is very useful tool for police forces it saves a lot of time and they can check if people are saying truth because if they drive stolen vehicle they can check who's the real owner and it can be return to right full owner.
What are the constraints of the police database? One of constraints of police database can be if the servers are down and non information can be access this would have huge impact on police focus and this would make there work much harder that’s why police is securing and updating there database all the time so this wont happened. An other constrain of having such a big database about all living people in this country have risk of the personal information could be leak and this could cause damaged many people and much more could benefit it from it so that’s why its very importing to keep that database secured all the time.
The intended use and features of Police database how the tools and techniques of police databases are used Table structures: is also called database sheet the police is using it to hold different kind of data that police uses on daily bases this can be data when it happened people involved so you will input there details numbers codes and etc. Field characteristics: police would use it in different ways for example they would use it for saving data's or criminal records and maybe if they comment before crime so that would be in system already also police would have currency in field characteristics for example if they have been fine before this would show on system is well. Validation rules: for example in fields where you need to enter someone's DOB in the system this means you wouldn’t be allowed to enter any characters only numbers in that specific field. Indexing: means for police that the tables are setup robust and the data is loaded as fast possible for the officer. Forms: are used to enter information this could be entering someone's personal details so name surname address etc. Relationships: are used in police data base to link tables so an example of this can be when you enter details about the person you looking up main details such as name address etc. and some other tables would come up is well saying if the person has been convicted before or has any mental or health problems so police is aware who the dealing with or maybe that person is wanted. sorts and queries: when you able to setup certain criteria this can be fro example if you want to see who has commitment night crime all details about those people would come up and say what they have done in past. Records: are fields each of those contains records are holding information's this could be the time where was it who was involved and etc. they are used to hold records and information about people for future and present.
the tools and techniques of police database Productivity Since database where introduced they change how the police work the database are required to allow the police forces to work properly because in those days police are deeding on this so much because all needed information are stored on there for example when they are cheeking some ones identity they will enter the details in to the system and all information about that person will show up. Accuracy The accuracy of the database is very good all information are verify by people before they entered in to the police database and they are always updated so police always holds the newest information about people and this makes it very accuracy Usability Police forces are train how to use the database efficiently and quick so they can get the information needed as fast a possible.
The intended use and features of Employees database how the tools and techniques of Employees databases are used table structures: The table structures of employees database are using them to hold information about the workers this can have many categorise for example one of the table could hold information about the contact details where they live etc. field characteristics: employees database would use field characteristic for numbers only to keep track of how much money are paying the workers per hour and only number would be allowed to enter in that field. Indexing: is speed of database how fast it can load information about the works or how much they earn this important in database to quickly find out needed information about the workers. validation rules: they would use it for contact detail box for example they would set it up like that where you input you email you will must enter the @ symbol because otherwise it wont allow you to continue. Other example of validation rule would be how much they pay there workers it must be in currency and two decimal places so it can round it up. Records: the way they use records to keep how much hours each works has done during week so keeping records of that would keep a track of all those hours in one place. Relationships: are two section connect tougher for example validation rules when your talking about currency and records of how many hours they done those to section are in relationship because they need each other to work out how much the worker should get paid for each hour he did. forms, sorts and queries: in database context a from is window or screen that only contains numbers or spaces to enter data for example this could be how much hours they are doing per day and than they enter that amount in to that box.
The tools and techniques of Employees database Productivity: of database for employees Is making there job so much easier at each step because they hold details about the workers in place because of that they have quick access to those kind of of information also keeping tracking of who and how much earns each months is displayed there. Accuracy: The accuracy of employees database are very accuracy because they always keep to record of that the user input so the only errors that this database can have is human error if he inputs wrong details or numbers. Usability: The usability of employees database is straightforward you enter essential information address name surname DOB etc. then you set up how much you pay him an hour or monthly from there you pretty much done. The only think you need before use it some kind of training with someone to show you how to use.
the strengths and weaknesses of police databases. Strengths of police database are that is very powerful tool for police to use because it hold all details about all people living in this country the benefits of it is that they are stored in place and can be access quickly. It can show details if you haven been connived before or been arrested and can show if you been find. They can been access from different sites. It is very secured for that amount of information they hold on each of us. You can set up who has access to edit the database or just look at it.
The weaknesses of police databases. Weaknesses: If the police database is leak it can course massive damaged to different kind of of people and many can benefit from it specially criminals or company's sell your details for many. Angry police officers can mess up your papers and make you look bad in the system. could be abused by corrupt police. Every think is stored about you in one place. data could be used against the individuals
- Slides: 15