The Features Of A Relational Database - 1585 Words

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 fields. An example could be a library database which could have the ability to have 3 tables. To further this example one table could be Customers so when somebody joins the library a record is generated with their details on such as their name, address†¦show more content†¦You are able to produce restrictions which assures that only acceptable or appropriate data is inputted into the database. Queries – This is what makes the concept of searching for the data you require easily. Queries can be used to obtain a piece of data which can be defined by the user. All of the features above techniques on how a database can receive, store, search and send all types of data to a different database Data Types Databases always keep data as it stores it making the data more efficient and all the different types of data are generally categorised as a specific data type. There is 5 main types of data such as Boolean, date/time, currency Numerical and text. Boolean – This is when data is limited to only 2 different choices. An example is True/False Yes/No Male/Female Date/Time – This kind of data limits you to only being able to use numbers from 1 – 31 for the number of days in the month and 1 – 12 for the number of the month then it examines if the date in fact exists/. There is three different formats for this type of data such as long, medium and short. Long time – 19:25:00 Medium Time – 07:25PM Short time – 19.25 Long date – 30 April 2014 Medium date 30-Apr-14 Short date – 30/04/14 Currency – This type of data is automatically changes the data you enter to possess a  £ in front of it and 2 decimal places. An example of this is  £5.05 $6.99 Numerical – This is whatShow 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 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