Questions On Database Management System

Data objects can model relational data or advanced data types such as graphics, movies, and audio. Smalltalk, C++, Java, and others are objects used in object-oriented data. The object-relational is a combination of relational and object-oriented databases. Traditional and advanced data types can be used to construct database management systems. These systems can connect to a company’s website and update records as needed. Database Approach The main purpose of a database is data storage that can be stored and retrieved when needed. A popular common language called structured query language (SQL) is used to store and retrieve data in relational database. This language enables the systems to run a report or modify data or remove the data from the database. A database management system (DBMS) controls all aspects of a database, this is not limited to the creation, maintenance, and use of database. The DBMS ensures proper applications are able to access the database. An important purpose of a DBMS is to maintain the data definitions (data dictionary) for all the data elements in the database. It also enforces data integrity and security measures. Data Models Data models provide a contextual framework and graphical representation that aid in the definition of data elements. In a relational database, the data model lays the foundation for the database and identifies important entities,

Step 2. Data Analysis: The data will be analyzed to determine database modeling. Step 3. Database normalization: Fields and

De-Normalization is a process of adding redundant data to get rid of complex joins for optimizing database performance.

The time spent on security measures, data backup and reduction of duplication could be saved in this project, if relational database management system would be adopted. The latest technology is used for making the work and environment of Inspiration Space more accessible and faster.

Another challenge that the company is likely to face is difficult in decision-making. This is because the information about repairs, maintenance, revenues, and total expenses are stored manually. This means it will take lot of workforce to undertake the process of sorting out the papers in order to prepare the reports required for decision-making. In that connection, it is very difficult for the managers to retrieve the data stored in different files. As a result, managers are complaining of how the current process is time consuming and difficult.

(1)The problem found in the health gym located in mankau Auckland which was recently opened is that owner is storing all its information of the members in rolodex file and then later information is transferred to computer or spreadsheets manually. There is wastage of time as the process of transferring data is time consuming, there is no security as data can be misplaced, accuracy can be another problem faced by gym management while transferring data as error can occur while transferring data from the file, concurrency only one person can use data from file at one time so concurrency is another problem, and backup once file lost data is never recovered and it require a lot of storage space and high cost is involved in storage and paper.

Relational database normalization entails organizing database and it includes the creation of tables as well as relationships establishment between the tables using designed rules intended to protect the data as well as make the database to be flexible. This is achieved through the elimination of redundancy as well as inconsistent dependency. Redundant data is known to waste the space of the disk thereby creating problems of

Furthermore, you need to beware of user error. Often that company engineer is the main problems. A common way that users always lose their data is when they are doing any editing a document and accidentally delete the portions of data. After

The database and file specifications are developed,which defines what data will be stored and where they will be stored.

In the HR Cube software, it has multiple options for the user to store or save the employees detail or information in different aspects such as personal, professional, work experience, facilities, emergency contact, and dependents in family and addresses detail. In addition, this software can be used to store all the data at the same location or databases. This allows the user or organization to review the data of employee with click on “view employee detail”. This allows the HR department to sort, search and store the detail with systematically and easy for the user to find the information about the employees. Other than that, this function also saves time for the user, because to search the employees with manually is very time consuming for the organization that have big number of employees.

Local data: let us consider example of organization as amazon which maintains vast amount of data. It contains departments like developers, database administrators, sales and many more. When local data is taken into consideration, for example, in sales if we take delivery service department. It simply considers invoice of customer as it will start it service and keeps track until courier is delivered. After delivering, invoice will be erased from their system as they won’t be connected in remaining issues. This invoice number can also be used across the organization i.e. if we consider customer service department they should maintain this invoice in order to inform details if any customer approaches them before delivery.

Data redundancy is when the same data are stored unnecessarily at different places. Spreadsheets /islands of information lead up to the date redundancy. (pg. 16)

Data in regard to an employee’s tax records, personal data, employment contracts and training data, transactions, entry/exit records and browsing/working records are deemed sensitive data.

Relational database management systems (RDBMS) have a number of characteristics that make them more efficient and preferred operational choices. One characteristic is the independence of logical data structures as tables, indexes, and views from physical storage structures. Because the logical and the physical structures are separate from each other, physical data storage can be managed and organized without affecting access to logical structures. Renaming a database file, for example, does not rename the tables stored within that database file.

Normalization can be used as a methodology for achieving an organized and logically designed database free of overused excessive data. The normalization process includes three integral fundamental steps which are the first normal form, second normal form, and third normal form. Logically organizing data in a manner that reduces or eradicates excessive equivalent data allows for accurate and concise data tracking within a database, and normalization can help achieve this.