What A Database Is, Features Of A Relational Database, And...

Introduction: 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 a large building services company which currently employs a team of IT technicians to manage their IT infrastructure and support the IT users. Recently, the company has taken over a similar but smaller company which also employs technical support staff in the same way. The company feels that it needs a centralised IT-based support system that will track, monitor and report on the progress of the problems identified by users across the two sites generally improving the IT support services. The IT Support System needs to monitor the use if IT hardware, such as: keyboard, monitor, printer, system unit, laptop, CD writer, mouse, in order to improve the service provided to users and ensure the service is operated in an efficient way. You have already met with the network manager and he has provided the main requirements of the system. The responsibility for monitoring each hardware item is allocated to a specific employee. I have decided to design a relational database for the IT supportShow 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 MoreRelational And Non Relational Database Model Essay1428 Words   |  6 Pagesclearly explain the concept of relational and non-relational databases. Although those literature hightligted varieties of significant theories, this review will attempt to establish a clear meaning of relational and non-relational database Concept, NoSQL data model, ACID and Base properties, CAP Theorem and Scalability. Furthermore, it will attempt to critically evaluate structured and unstructured data, elucidate on the strength and weakness of relational and NoSQL databases and give an overview of theRead 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 w ill have to be analyzed for gathering essential expertise. On the whole, relational 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 Pagesservice. What 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 databaseRead 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 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 resultRead MoreSql Vs. Relational Databases956 Words   |  4 PagesTo SQL or Not to SQL Relational databases play a major role in making many apps and programs work. They provide an easy way to store large amounts of data in a consistent, non duplicating, and maintainable way to be used by developers for analytical or software use (Advantages of a relational database, n.d.). However, more and more applications and companies with a tremendous amount of data such as search engines, social networks, and e-commerce sites have been requiring a level of speed and scalabilityRead MoreRelational Database : A Database1622 Words   |  7 Pages Relational Database Introduction – What is a relational database It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal things. ThisRead MoreWhat Are The Four Types Of Database And Their Pros And Cons1172 Words   |  5 PagesIntroduction: In this document I am going to explain what database is and then I am going to list four different types of database and their pros and cons (Advantages and Disadvantages) for all databases that has been listed. And finally I am going to give an example of each database when it can be used. What is a Database? A database is a group of data and ii is often shortened DB. They are mainly or normally used for two purposes. Storing data and sorting data. You can save different types of