What Is A Relational Database - 1043 Words

Introduction/Scenario case: Scenario: There is a large building service company named Iains and Co that is currently employing a team of IT technicians that are able to achieve their IT infrastructure and support from the IT users. Lately, the company has taken over a comparable small company which are also employing technical support staff in the exact way. The company are more comfortable to have a centralised IT-Based support system that is able to track, monitor and report on the improvement of problems acknowledged by users through the two sites normally improving the IT support service. What is a Relational Database? Relation database is a database model in which information is stored in separate tables stored in a linked†¦show more content†¦The negatives of a relational database are the expensive of having to set it up and keeping up to date with the database system. But in order to set up a relational database you must purchase the products that are needed for a relational database also it takes time to enter all the information in the database and for it to set up. Also some relational database may have limits on field lengths. Explain the features of a relational database: Relational database has several features one of them is that they have no duplicate tuples that have the same values for all the attributes, for example in any relation every row is unique. It has a table which is an entity that represent something for example each row has details of each customer details. An entity can be a place, a single place or a data that can be stored in a relation to a database Tuples are unordered for example the order for each row is irrelative. Another feature is the attributes which are things that describe entities, for example the order of columns in a relation would be irrelative. Also attribute values are Atomic which contains just one value in each attribute. Attributes are mainly common by being called primary keys and foreign keys that link into the entities together in organised database. Also another feature is a record which is a row that has structured data items in a table, for example in a database has rows in a