P1 M1 Btec Database Essay

2395 words - 10 pages

Table of Contents
Abstract 2
Introduction 3
Features of relational database 3
Entity and attribute 3
Validation 4
Keys 4
Referential Integrity 6
Advantages 7
Errors that can be encountered 8
Conclusion 9
Refference 10


This paper talks about how features of modern database can be useful in the modern business. It also talks about how they work and their importance and advantages without forgetting the errors that might be encountered. The purpose of this paper is to convince Modern Fishing Company to move to better ways of Data management. The findings of this paper state that the features of relational database can be used to ...view middle of the document...

In this kind of a database, an attribute appears with the entity when it is needed to, when one searches for it. If MFC needs their data do be available or found in a blink of an eye, relational database is their answer. Figure 1, bellow shows how an entity and an attribute might appeartogether in a database.

Figure 1 is an example of a table in a database. In this table, ‘Customer Name’ field is the entity since it is a person. And the other fields adds information regarding the entity, those are the attributes of the customers.

The researcher found out that another feature of relational database is Validation Rule. A validation rule is a set of rules that only allows the user to input a certain type of character or a certain amount of character in a given field. This means that the validationrule is a means of checking data accuracy and appropriateness when a user inputs data. Validation rules can be used to specify what data is required to be typed in. When the user inputs inappropriate characters in the field. An error message will pop up. This error message is set when the database designer creates the validation rule.
“The value of the Validation rule property is a string containing an expression that is used to test the user’s input. The expression used as a field’s Validation rule property cannot contain user-defined functions or any of the access domain or aggregate functions. A fields Validation Rule cannot reference forms,queries, or other tables in the application.” - Access 2007 Bible, By Michael R. Groh, Joseph C. Stockman, Gavin Powell, Cary N. Prague, Michael R. Irwin, Jennifer Reardon.
If MFC wants their data to be more valid, to reduce the chances of errors in their fields of records and to limit a user input into their data, they should move away from Excel Spreadsheets to modern ways of database management.

In a modern SQL database or any other, there are certain fields on a table that are purposed for Entity or Data identification. These fields are unique in a table that represents the entry on another table. These are called Keys. When a data or an entry is given an ID that uniquely identifies it in a table, it is called a Primary Key. According to Carlos Coronel and Steve Morris in the Database design, the most important characteristic of an entity is its primary key, which uniquely identifies the entities. He continued – “The keys function is to guarantee entity integrity.”
For an example, in this scenario, in employees table, ‘EmployeeID’ should be the primary key for this certain table. It is a must for a user to input appropriate data on this field. However important this field is, it is still an attribute of the customer.
Another type of a key is a Foreign Key. This is a primary key on a table that is in another table.
Mr. Coronel and Mr. Morrison did say something about these types of keys.
-“Primary keys and foreign keys work together to implement...

Other Essays Like P1 M1 Btec Database

Hgchgfjhfjhgf Essay


Business Unit 4 Essay

1012 words - 5 pages BTEC Level 3 in Business – Unit 4: Business Communication Context Businesses need accurate information. This information has to move between different individuals, different departments and different organisations. The information can be anything from a simple idea to masses of data on business performance. It can come from inside an organisation or from almost anywhere outside. Put simply, a business that does not plan how to deal with

Unit 9 Complete Booklet

4423 words - 18 pages . ------------------------------------------------- Learner: ------------------------------------------------- Signed: ------------------------------------------------- Date: Name of Assessor : ____________________________ Name of Internal Verifier: ____________________________ Complete portfolio to be handed in: 17 January 2014 UNIT 9 Creative Product Promotion BTEC NATIONAL DIPLOMA in Business 2013-2014 Internal verification of assignment brief (final agreed version

Performing Art

1996 words - 8 pages BTEC First Diploma in Performing Arts (Acting) Assignment Brief Assignment Title: 1.1 Devised Monologue Unit: A9: Acting Date Set: 19 September 2005 Completion Date: 7 October 2005 Feedback Date: 21 October 2005 Assessor: P. Daintry Internal Verifier: S. Bretterecker Vocational Context You are a member of a theatre company that has been commissioned to produce an evening of monologue performances. The first

Mr Thomas

3596 words - 15 pages |Qualification |Unit number and title | |Pearson BTEC Level 5 HND Diploma in Business (QCF) |Unit 3: Organisations and Behaviour | |Student name and ID number |Assessor name

test upload

5570 words - 23 pages complexity increases, so the number of possible permutations climbs ever more rapidly. By requiring that the list holds not all possible combinations, but all possible pairs, the list can be reduced. The following six permutations contain all the pairs; All possible pairs; M1, M2, M3. Q1, Q2, Q3. H1, H2, H3. L1, L2, L3. P1, P2, P3. U1, U2, U3. MH, ML, QH, QL, MP, MU, QP, QU. HP, LP, HU, LU. Customer 1 2 3 4 5 6 Account M M M Q Q Q Tariff 1 2 3 1

The Separation Of Capital Ownership And Control

1577 words - 7 pages The argument of whether the separation of capital ownership and control is an efficient form of organization has constantly been a controversial issue. The criticism whether the controllers’ act is in the best interest of the owners’ wills never end as long as hired managers operate management. As the number of public companies has been increasing over the course of this century, meanwhile the American style of contact based corporation has

The Versatility And Flexibility Of OLED's

1014 words - 5 pages In April 1, 2002, organic light emitting diodes gain rise in the scientific community with their published, more practical form at Ames Laboratory. “Scientists at the U.S. Department of Energy's Ames Laboratory, in collaboration with scientists at the University of Michigan, Ann Arbor, have developed and demonstrated a novel, fluorescence-based chemical sensor that is more compact, versatile and less expensive than existing technology of its

Comparing The Moral Virtues Of Antony And Julian The Apostate

1103 words - 5 pages Roman emperor Julian the Apostate and Christian leader Antony both exhibited many qualities of character during their existence. Both of them led very distinctive lives although shared several ethical values. Book 25 of “The Later Roman Empire” and the book “Early Christian Lives” show concrete evidence of this. In the following essay, I will argue how both leaders’ lives were devoted to their religious beliefs and their mutual cardinal virtues

Living In A Cashless Society

1637 words - 7 pages Money in a traditional sense no longer exists. Money is becoming much of a concept than a physical material, and most ordinary bitter have not see the reality of the switch. People today are using credit and debit cards on a regular basis and in everyday situations such as meal purchased at fast food, highway tolls, clothing, groceries, gas stations, etc. all of these means of systems could be regarded as a cashless society or world. The question

The French And Indian War: The "Real" First World War

1955 words - 8 pages The Seven Years War, or more commonly referred to as “The French and Indian War”, has been called the true First World War. In this book The French and Indian War: Deciding the Fate of North America, the author and historian Walter R. Borneman paints a detailed and elaborate picture that justifies the claim of it being the first true war of global proportions. If ever there truly was a climax to the never ending feud of the European powers

Related Papers

Health And Social Care Essay

846 words - 4 pages Qualification (Course code) | F12122BTEC Diploma Health Studies / Health & Social Care | Unit Number and Title | Unit 6: Personal and Professional Development | Assignment Number & Title | Assignment 1 | Issue date | Week commencing 22/2/16 | Submission date | Week commencing 7/3/16 | Assessor | Debbie Hilton | IQA | Alyson Blud | Grading Criteria:(P1): Explain key influences on the personal learning processes of individuals

Unit 14 Brief Essay

3868 words - 16 pages describe the level of achievement required to pass this unit. Assessment and grading criteria To achieve a pass grade the evidence must show that the learner is able to: To achieve a merit grade the evidence must show that, in addition to the pass criteria, the learner is able to: P1 explain the nature of two named physiological disorders [IE1; IE2; CT2] M1 assess possible difficulties involved in the diagnosis of the disorders from their signs

Business Accounting Spec Essay

3910 words - 16 pages study time and completion of assignments Edexcel BTEC Level 3 Nationals specification in Business – Issue 2 – June 2010 © Edexcel Limited 2010 5 Assessment To achieve P1, learners will describe clearly the main purpose of accounting for an organisation. The description may be brief but should be accurate and incorporate historical data in order to be able to check on current financial performance and position, as well as the planning

Types Of Abuse Essay

2476 words - 10 pages meet all the learning outcomes for the unit. The assessment criteria for a pass grade describe the level of achievement required to pass this unit.Pass Merit Distinction | P1 describe forms of abuse which may be experienced by adults | M1 assess the likely immediate effects of two different forms of abuse on the health and wellbeing of adults | D1 evaluate the