Assignment 2: I-Share Database

The information is stored in locked filing cabinets as the information can hold company details and account numbers this is only accessible by the Administration staff and each file is signed out on a register.

IT Coordinators create a user accounts for every employee at McGraw-Hill. Once an account is created, the employee would have 72 hours to logon to RAR system and create a password to access the data. After the employee has access to server he/she will have rights to create ticket, create customer, edit customer, and open a close ticket. The only right that employees wouldn’t have access to is deleting users, and data override.

The information is stored in locked filing cabinets as the information can hold company details and account numbers this is only accessible by the Administration staff and each file is signed out on a register.

* Describe the role of databases and database management systems in managing organizational data and information.

Identify one kind of human services organization—for example, mental health provider or foster care provider—and describe the services provided.

All of this information is stored and locked away in individual files in the manager’s office so that is not accessible for public view, all this information needs to be kept safe and secure to abide by confidentiality regulations. This information is only available to managerial staff when needed.

data are stored as files on internal devices (like hardware) and shared/managed through intranets and HRIS; this include electronic appraisal forms and self service systems.

With reference to source 1, 3, 4 and your understanding of the historical context, how valuable are these sources to a historian studying the extent of economic recovery in Germany by 1928?

It is every company mandatory requirement to make sure sensitive data is protected from public access at all times. In large organization sensitive information such as employee salary and performance should be kept confidential from most of the DBA users. For this DBMS uses database security and authorization subsystems that is responsible for security to the portions of database or to restrict the access to the sensitive information.

Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:

One of the many issues that the government faces on a daily bases and is often accused of using is propaganda. Thomas Jefferson believed that all government rested upon the consent of the governed but propaganda has historically been used as a loophole to circumvent this idea on which our government was built. In order for the governed to give their consent, they must be well informed on the issues that the government currently faces. Propaganda is used to shape public opinion during times of war and in times of peace in order to achieve an objective and can have both short and long term effects on the country. I believe that propaganda is usually unacceptable to use but sometimes is necessary in times of war.

accessible by assigned staff, via their corporate login. The system is deemed to be secure but

Three types of maintenance plans include: preventative, corrective, and adaptive maintenance which improve the data quality. Activities to improve data quality include database backups, integrity checks, optimizing the index. Preventative maintenance incorporates creating and continuously maintaining daily and/or weekly backups for data loss prevention, corrective maintenance ensures system errors are corrected. One activity associated to corrective maintenance includes resolving deadlocks, which occurs when two or more tasks permanently block each other. Adaptive maintenance includes enhancing system and database performance via based on utility assessments and optimized queries to improve performance. (Coronel, Morris, & Rob., 2013).

I would have the fields set up as first name (EMP_FIRST), middle initital, (EMP_INITIAL), last name (EMP_LAST), area code (EMP_AREACODE), phone (EMP_PHONE).

Few companies today can exist without an IT department. The IT department contains many of the company’s technology experts. Almost all companies rely on computers to some degree whether it is an international conglomerate or a small startup company. Some companies are very dependent on computer systems while others use them only for accounting for payrolls and everyday computer tasks. Most organization, even the smallest company have people whose job is to make sure that the computer system is up and running or an emergency contact to call when the computer systems goes down. In the future, I want to take the head of a database administrator of an IT department whether the size of the company is small or enormous.