Features Of A Relational Database - 2318 Words

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. Foreign keys: A foreign key is a column in a database that links data between tables by cross referencing because it references primary keys from other tables. For example if there are two tables, customer and order then a†¦show more content†¦It can also be broken down into short, medium and long date/time. Date: 31/01/14, 31-Jan-14, 31 January 2014 Time: 19:24, 7:24 PM, 19:24:30 Autonumber- This will increase by 1 each time a new record is added to the database Record 1 : 1 Record 2 : 2 Record 3 : 3 Boolean (yes/no)- This is a data type that restricts the record to only two choices, either yes or no. Yes : No On : Off Validation rules Validation within a database is used to make sure the data entered into the database is sensible and makes sense, also to avoid any typing errors. You make a rule which only allows certain things to be typed into the database e.g. only 11 numbers for a mobile phone number so that you don’t accidently type the wrong amount of digits. It will come up as an error if you try and then that is when you notice your mistake. Benefits Having a relational database will greatly reduce the data redundancy because it will get rid of the repeated data within a database. This is done by going through the normalisation process and therefore since there is less data in the database it is much faster access, searching data, updating data, sorting and reporting. Stages of normalisation The steps of normalisation will be fully explained in the following steps: Firstly you need to turn this into a unormalised table by: - Create column headings for the table for each data item on the report and ignore any calculatedShow MoreRelatedThe 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 MoreThe Features Of A Relational Database1406 Words   |  6 PagesP1 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 theRead 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