P1 Explain the features of a relational database.
Introduction: A company called Ian’s & Co currently employs a team of IT technicians to manage their IT infrastructure and also support the IT users. Also quite recently the company has taken over a similar but a smaller company which is also employs technical support staff in the same way.
What is a relational database?
Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between the tables. Also it is also known as reason such as a database is called relational database.
The purpose of relational database for Ian’s & Co:
Secondly the purpose of a database for Ian’s & Co is that basically you can make a lot of queries, forms, tables, and also even reports so that the users can basically report hardware trouble across the two cite. Secondly the company Ian’s and Co will also need desk that are also linked to other desks so that they can keep an eye on the hardware that are having quite a few problems , in addition this will progress the service which is provided to the users and also to make sure the service is operated in an efficient way.
What is an entity?
Firstly an entity is basically an entity of significance which data must be captured; also there are some examples of entities such as stock supplier and order. Furthermore in relational databases every entity is usually kept in a separate table. Also I have to make sure that put the employee details,
A Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. The system does not require many assumptions about how data is related t or how it is to be extracted from the database. The database can be viewed in several forms.
A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.
Database model defines the logical structure of the database by determining manner in which the data will be stored. Relational model is one of the most popular database models, which defines tables and relationships between the tables.
General a database has a lot of tables and some tables are related to each other so relationship is use to make the connection between two or more tables. It is a method to avoid excessive data and to ensure the data integrity. There have three types of relationships:
The tables in relational databases organize data in rows and columns, simplifying data access and manipulation. It is easier for manager to understand the relational model than put all data in one table. Besides, a relational database allows tables to be linked. And the linkage reduces data redundancy and allows data to be organized more logically. In a word, relational database is easier to control, more flexible, and more intuitive than approaches.
A database is an ordered collection of associated information. Database has data that is connected to each other. For example, a database that comprises information about company stock prices must not also contain information about student.
Iain’s & Co. are a large building company that currently employ a team of IT technicians to help them manage their IT infrastructure and their IT users. They recently have taken over a similar small company that employs technical staff in the same way. Iain’s & Co. feel that they need a centralised IT support system that will monitor, track and report problems that have been identified by their IT users across both sites. Iain’s & Co. have hired me as their Systems Analyst to provide them better solutions to manage their IT Supports system.
Each foreign key of a table can become a foreign key for another table depending on the relation between those two tables.
I would use a relational database. Hospital administrative data is readily used as a data collection source in health services research by looking at numerous records/tables effortlessly. Examples; Electronic patient management program, bed-days, discharges and inpatient medical review for length of stay. Also, “You can compare actual length of stay with regional, national, and patient-specific benchmarks based on real experience.” (TRUVEN HEALTH ANALYTICS,
In what way does the structure of a relational database assist the easy retrieval of information?
The knowledge base consists of information regarding the user behavior and ADL that include self-care tasks, household duties, and personal management actions. It specifies the task to be carried out and the actions to be performed. The relational database presents a natural association between the two elements of the decision support system, and the use of the database to additionally represent a novel approach to knowledge engineering (KE) for planning.
To edit a data entry, the user must complete all fields with the updated information, and then select “Edit”. In the case that a name must be changed, a new data entry should be created. To delete a data entry in the Employees table, only the “Employee Name” field must be completed; all other fields may be left null. When the user successfully adds, edit, or deletes an employee from the database, the user will receive a success message, as depicted below.
1.) The RDBMS is a program or a group of programs that helps to maintain a relational database. This software gives the ability to the user to convert the user’s requests for data into a logical format with the answers to that request. It also contains a data dictionary to make available more security, easier access, and data integrity.
Define the structure of a database: data types and restraint that the data have to satisfy.