The Features Of A Relational Database - 1406 Words

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,Show MoreRelatedFeatures Of A Relational Database2318 Words   |  10 Pages Features of a relational database Primary keys: The main feature of a relation database would be the primary key. It is a unique identifier set to each and every record that travels across different tables in relationships. An example of a primary key is a Social Security number. The primary keys job is to make each record unique and it lets data to be kept in more than one table. Each table within a relational database will have a field for the primary key. Read MoreThe Features Of A Relational Database1585 Words   |  7 Pages P1 - Explain the features of a relational database. This is to be shown as a report or presentation and must discuss the following. †¢ Features: entities; attributes; relationships; †¢ Entities: primary keys, foreign keys; referential integrity; attributes; †¢ Attributes: field properties e.g. data types, size, validation rules †¢ Relationships: one-to-many; one-to-one; many-to-many Relational database – This is a database that contains more than one table of which are linked using key fieldsRead MoreFeatures Of A Relational Database2399 Words   |  10 PagesFeatures of a relational database I will be explaining all the features of a relational database such as entities, attributes, relationships and benefits and will be giving examples on each of these to show how they affect the database. Primary keys: The main feature of a relation database would be the primary key. It is a unique identifier set to each and every record which moves across different tables in relationships. A good example of a primary key is a Social Security number. The primary keysRead MoreWhat A Database Is, Features Of A Relational Database, And The Benefits Of Relational Databases1659 Words   |  7 PagesIntroduction: In this report I am going to explain what a database is, features of a relational database, and the benefits of a relational database, purpose of primary keys and how they are used to build relationships, and I am also going to focus on, what are foreign keys and how they are been used, explain referential integrity and finally, how to apply referential integrity. I am also going to backed up my views and opinions with the valid references. Assessment introduction Iain’s Co is aRead MoreRelational Databases For An Efficient Data Management And Retrieval Of Data1032 Words   |  5 Pagesan issue due to the growing need in business and academia. To resolve these issues a number of databases models have been created. Relational databases allow data storage, retrieval and manipulation using a standard Structured Query Language (SQL). Until now, relational databases were an optimal enterprise storage choice. However, with an increase in growth of stored and analyzed data, relational databases have displayed a variety of limitations. The limitations of scalability, storage and efficiencyRead MoreKey Features Of The Database Management System1035 Words   |  5 Pagesthis paper we will examine the key features of the database management system MongoDB. Day-to-day information is growing in gigantic amount. Generated information include predominant information and it will have to be analyzed for gathering essential expertise. On the whole, re lational databases are used so as to system the data. These, ways works successfully for small amount of knowledge. What if the data is very tremendous? To avoid this problems Mongo databases are introduced. MongoDB is a cross-platformRead MoreAnalysis Memorandum1532 Words   |  7 Pagesanalysis memorandum proposing the use of Microsoft Access databases within our Security Division’s infrastructure. Many security managers are relying heavily on the use of Microsoft Excel spreadsheets in order to keep track of their personnel, security violations, inspection programs and training. While spreadsheets are effective means for complex calculations they are also limited in that they basically fall short in showing the relational qualities of security data in relationship to particularRead MoreWhat Is A Relational Database?1043 Words   |  5 PagesWhat is a Relational Database? Relation database is a database model in which information is stored in separate tables stored in a linked relationship in a table with rows and columns. Each table has a record which is known as tuples and each record has a field which is known as an attribute which all containing unique value, every table has at least one field with another table such as many to many’ ‘one to many’ or ‘one to one’ relationships. What is the purpose of a relational database? The purposeRead MoreRelational Database Management System Essay1078 Words   |  5 PagesRelational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of dataRead MoreBtec1256 Words   |  6 PagesLearner Registration No. Assessor Name LEI13160876 Soory Abbassi 15/10/13 Hand-in Date Submitted On 15/10/13 18/03/14 Qualification and Programme Number Unit Number and Title BTEC Extended Diploma In IT (QCF): Level 3 Unit 18: Database Design Assignment Title Assignment 1 No. 1 of 2 Whole or Part of Unit? Whole /Part Grade for Whole Unit Deadlines: If you do not meet the deadlines for handing in your assignments you may not have your work marked. This could result